21. 4GL Statement Glossary : Set_sql
 
Share this page                  
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');