Description
The set_ingres statement allows your application program to:
• Enable or disable debugging features
• Specify the number of rows the DBMS Server prefetches when retrieving rows using cursors
• Specify whether the DBMS Server aborts or continues a session when certain errors occur
The set_ingres statement overrides any settings of II_EMBED_SET. For more information about II_EMBED_SET, see the System Administrator Guide. You must terminate the set_ingres statement according to the rules of your host language.
The following are valid parameters for the set_ingres statement (SQL-specific parameters are omitted):
prefetchrows
Integer. Specifies the number of rows the DBMS Server prefetches when retrieving data using cursors. Valid arguments are:
0
(Default) the DBMS Server determines the number of rows to prefetch
1
Disables prefetching; each row is fetched individually
n
(Positive integer) Specifies the number of rows the DBMS Server prefetches
printqry
Integer. Turns the printqry debugging feature on or off. As the application executes, printqry prints query text and timing information to the file "iiprtqry.log" in the current directory. Specify 1 to turn printqry on, 0 to turn printqry off.
qryfile
String. Specifies an alternate text file to which the DBMS Server writes query information. The default filename is "iiprtqry.log". To enable this feature, use the set_ingres printqry option.
If you omit a directory or path specification, the file is created in the current default directory.
printgca
Integer. Turns the printgca debugging feature on or off. As the application executes, printgca prints communications messages to the file "iiprintgca.log" in the current directory. Settings are:
1
Turns printgca on
0
Turns printgca off
gcafile
String. Specifies an alternate text file to which the DBMS Server writes GCA information. The default filename is "iiprtgca.log". To enable this feature, use the set_ingres printgca option.
If you omit a directory or path specification, the file is created in the current default directory.
printtrace
Integer. Enables or disables trapping of DBMS Server trace messages to a text file (iiprttrc.log, in the current directory). Settings are:
1
Enables trapping of trace output
0
Disables trapping
trcfile
String. Specifies an alternate text file to which the DBMS Server writes tracepoint information. The default filename is "iiprttrc.log". To enable this feature, use the set_ingres printtrace option.
If you omit a directory or path specification, the file is created in the current default directory.
programquit
Integer. Specifies whether the session aborts on the following errors:
• An application issues a query but is not connected to a database
• The DBMS Server fails
• Communications services fail
1
Specifies to abort on any of the previous conditions
0
Specifies to continue after any of the previous conditions
savequery
Integer. Enables or 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, you must issue the inquire_ingres(query=querytext) statement. To determine whether saving is enabled, use the inquire_ingres(status=savequery) statement.
errorno
Integer. Sets the value of the error return variable errorno.