PreviousNext
Help > Development > Accessing AS/400 data > SQL > Prepared Queries > Parameters
Parameters

 

Parameters name in the statement must be prefixed by a colon ( :).

 

//Prepare SQL Query for multiple executions

HPrepareSQLQuery ( Insert , connection ,
hQueryWithoutCorrection... ,
"INSERT INTO employees VALUES (:name, :firstname, :age )" )

...

//Set param values; Execute

Insert.name = EmpName

Insert.firstname = EmpFirstName

Insert.age = EmpAge

HExecuteQuery (Insert)