SQL Embed Options |
A number of options are available to you when embedding SQL. These options are listed in Table: Embedded SQL Options.
Embedded SQL Options
| Option | Description |
|---|---|
| SQLBLOCKMAX
|
An option that contains the maximum number of records retrieved from an Oracle relational database at one time. |
| SQLCODE
|
(Read-only) An option that contains the value returned by the Oracle RDBMS after the most recently attempted SQL operation. |
| SQLERRM
|
(Read-only) After the Database reports an error and SQLCODE has a nonzero value, an option that contains the text that explains the problem. |
| SQLMESSAGES
|
An option that determines whether error messages are sent to the current output file. |