| 1 | Connection handle | Input | Binary(4) |
| 2 | SQL statement | Input | Char(*) |
| 3 | Length of SQL statement | Input | Binary(4) |
| 4 | SQL communications area | Output | Char(136) |
| 5 | Error code | I/O | Char(*) |
The Process Immediate SQL Statement (QxdaProcessImmediateEDRS) API is used to run an SQL statement on the database server. The statement is processed exactly as provided, without coded character set identifier (CCSID) conversion.
None.
The handle number of the connection on which to process the SQL statement. The connection handle must have been generated by the QxdaConnectEDRS API in the current job and activation group.
The SQL statement to process.
The length of the SQL statement passed.
Returns diagnostic information. It includes the SQLCODE variable, indicating whether an error has occurred. If SQLCODE has a value of 0 after a call to this API, the function was successful.
The format of this structure is standard and is described more completely in the SQL programming and DB2® for IBM® i SQL reference topic collections.
The structure in which to return error information. For the format of the structure, see Error code parameter.
This function may be called from the initial thread of a job only.
| Message ID | Error Message Text |
|---|---|
| CPF180C E | Function &1 not allowed. |
| CPF24B4 E | Severe error while addressing parameter list. |
| CPF3C90 E | Literal value cannot be changed. |
| CPF9872 E | Program or service program &1 in library &2 ended. Reason code &3. |
| CPFB750 E | Connection handle specified not valid. |
| CPFB752 E | Internal error in &1 API. |
| CPFB756 E | Rollback operation performed. |
| CPFB757 E | The connection is suspended. |
| CPFB758 E | The EDRS server system has been switched. |
[ Back to top | Database and File APIs | APIs by category ]