Was this helpful?
II_EMBED_SET
II_EMBED_SET allows application programs to set a variety of features. It can be set installation-wide or locally. The acceptable values and the actions they specify are:
errorqry
Prints query that caused error.
savequery
Enables/disables saving of the text of the last query issued. Specify 1 to enable or 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.
printqry
Prints all query text and timing information to iiprtqry.log file in the current directory.
qryfile
Specifies an alternate text file to which query information is written. The default file name is iiprtqry.log.
printgca
Traces GCA messages to the iiprtgca.log file in the current directory.
gcafile
Specifies an alternate text file to which GCA information is written. The default file name is iiprtgca.log.
printtrace
Enables or disables saving of DBMS trace messages to a text file (specified by tracefile). Specify 1 to enable saving of trace output, or 0 to disable saving.
tracefile
Specifies an alternate text file to which tracepoint information is written. The default file name is iiprttrc.log.
sqlprint
Prints all errors and database procedure messages arising from embedded SQL statement.
eventdisplay
Print events as they return from DBMS.
dbmserror
Makes local (DBMS) error numbers the default error numbers returned to the application in errorno and the SQLCA’s sqlcode.
genericerror
Makes generic error numbers the default error numbers returned to the application in errorno and the SQLCA’s sqlcode.
prefetchrows
Specifies the number of rows to be “prefetched” when retrieving data using cursors. Valid arguments are:
0 (default)
Ingres determines the number of rows to prefetch.
1
Disables prefetching. Each row is fetched individually.
N (positive integer)
Specifies the number of rows to be prefetched.
Last modified date: 01/30/2023