Set_sql
Sets options for a DBMS session.
Syntax
set_sql (set_sql_constant = value
{, set_sql_constant = value})
set_sql_constant
Specifies one of the following DBMS constants:
connection_name
Specifies the name of the session. Can be a 4GL name. A varchar of length 128.
errortype
Specifies the type of error number returned to errorno; options are:
• Genericerror generic error number (default)
• dbmserror local DBMS error number
programquit
Specifies whether Ingres aborts on the following errors:
• An application that is not connected to a database issues a query
• The Ingres DBMS fails
• Communications services fail
Set programquit to 1 to abort on these errors.
session
Specifies an integer identifier for the session. Can be a 4GL name.
value
Specifies a character string expression (for connection_name or errortype) or integer expression (for programquit or session)
Description
The 4GL set_sql statement lets you set dynamically any of the following options for a DBMS session:
• The type of error number returned to errorno in an inquire_sql statement
• Whether Ingres aborts on certain errors
• The name and identifier for a session connection
Example
Specify that local DBMS error numbers are to be returned by an inquire_sql statement on errorno and sqlcode:
set_sql (errortype = 'dbmserror');