CreateSQL
Mon 01 January 2018Syntax
CreateSQL([{sqlstring | SQL.SqlName}[, paramlist]])
Where paramlist is an arbitrary-length list of values in the form:
inval1 [, inval2] ...
Description
Use the CreateSQL function to instantiate a SQL object from the SQL class and opens it on the given sqlstring and input values. sqlstring is a PeopleCode string value giving the SQL statement.
Any errors in the SQL processing cause the PeopleCode program to be terminated with an error message.
You can use CreateSQL with no parameters to create an empty SQL object that can be used to assign properties before being populated and executed.
Parameters
|
Field or Control |
Definition |
|---|---|
| sqlstring | SQL . SqlName |
Specify either a SQL string containing the SQL command to be created or a reference to an existing SQL definition. This string can include bind variables, inline bind variables, and meta-SQL. |
| paramlist |
Specify input values for the SQL string. |
Returns
A SQL object.