dbeventdisplay

integer

Enables or disables the display of events as they are queued to an application. Specify 1 to enable display, 0 to disable display.

dbeventhandler

function pointer

Specifies a user-defined routine to be called when an event notification is queued to an application. The event handler must be specified as a function pointer.

dbmserror

integer

Sets the value returned by the inquire_sql(dbmserror) statement. For details about the values returned by the inquire_sql(dbmserror) statement, see Local and Generic Errors.

errorhandler

function pointer

Specifies a user‑defined routine to be called when an OpenSQL error occurs in an embedded application. The error handler must be specified as a function pointer.

errorno

integer

Sets the value returned by the inquire_sql(errorno) statement. For details about the values returned by the inquire_sql(errorno) statement, see Local and Generic Errors.

errortype

character string

Specifies the type of error number returned to errorno and sqlcode. Value can be either genericerror, specifying generic error numbers, or dbmserror, specifying local DBMS error numbers. Generic error numbers are returned by default. For information about local and generic errors, see Local and Generic Errors.

gcafile

character string

Specifies an alternate text file to which OpenSQL writes GCA information. The default file name is “iiprtgca.log”. To enable this feature, use the set_sql printgca option.

If a directory or path specification is omitted, the file is created in the current default directory.

printgca

integer

Turns the printgca debugging feature on or off. Printgca prints all communications (GCA) messages from the application as it executes (by default, to the file “iiprtgca.log” in the current directory). Value can be either 1, to turn the feature on, or 0, to turn the feature off.

printqry

integer

Turns the printqry debugging feature on or off. Printqry prints all query text and timing information from the application as it executes (by default to the file “iiprtqry.log” in the current directory). Value can be either 1, to turn the feature on, or 0, to turn the feature off.

printtrace

integer

Enable/disable trapping of DBMS trace messages to a text file (by default, “iiprttrc.log”). Specify 1 to enable trapping of trace output, 0 to disable trapping.

programquit

integer

Specifies whether OpenSQL aborts on one of the following errors:

An application issues a query, but is not connected to a database.

The Enterprise Access product or DBMS fails.

Communications services fail.

Specify 1 to abort on these conditions, 0 to continue.

qryfile

character string

Specifies an alternate text file to which OpenSQL writes query information. The default file name is “iiprtqry.log”. To enable this feature, use the set_sql printqry option.

If a directory or path specification is omitted, the file is created in the current default directory.

savequery

integer

Enables/disables saving of the text of the last query issued. Specify 1 to enable, 0 to disable. To obtain the text of the last query, issue the inquire_sql(querytext) statement. To determine whether saving is enabled, use the inquire_sql(savequery) statement.

session

integer

Sets the current session. Value can be any session identifier associated with an open session in the application.

tracefile

character string

Specifies an alternate text file to which OpenSQL writes tracepoint information. The default file name is “iiprttrc.log”. To enable this feature, use the set_sql printtrace option.

If a directory or path specification is omitted, the file is created in the current default directory.