Glb.PreSQLCode is a built-in segment attribute that is set when the Construct method of an SQLScript is invoked using the SQLScript variant of the Determine Actual logic command. It is set to the status code of the last-executed SQL statement.
Note: This attribute is valid for Windows-based systems only.
Valid Glb.PreSQLCode values are listed in the following table.
| Value | Execution |
|---|---|
| 0 | Successful |
| 1 | The statement executed, but a warning was generated. This occurs if more than one record is retrieved using a singleton SELECT SQL statement. |
| 100 | No data matching the query was found, or the end of the results set was reached. No rows are processed. |
| <0 (a negative value) | The statement did not execute, due to an application, database, system, or network error. |
All other values are database-specific. Refer to the appropriate database documentation for more information.
Properties
Length = 9
Primitive = Signed number