Request Names for DBMSINFO Function

Valid request_names for the DBMSINFO function are as follows:

Returns 1 if autocommit is on and 0 if autocommit is off.

Returns the current time and date in an internal format, represented as the number of seconds since January 1, 1970 00:00:00 GMT.

Returns the number of I/Os to and from the front-end client (application) that created your session.

Returns Y if cache_dynamic is on; otherwise returns N.

Returns the value of II_CHARSETxx, the character set setting for the installation.

Returns the collation sequence defined for the database associated with the current session. This returns blanks if the database is using the collation sequence of the machine’s native character set, such as ASCII or EBCDIC.

Returns the session connect time limit or -1 if there is no connect time limit.

Returns Y if the session has create_procedure privileges in the database or N if the session does not.

Returns Y if the session has create_table privileges in the database or N if the session does not.

Returns the CPU time for the session in milliseconds.

Returns the decimal number representing a mask of internal privilege bits currently enabled for the user.

Returns the default mode for the cursor.

Returns the maximum number of cursors that a session may have open at one time.

Returns the mode of the current user.

Returns the database name.

Returns -2147483648 unless the user data types are in use.

Returns 0 unless the user data types are in use.

Returns the current date format setting (set on II_DATE_FORMAT or by the SET statement).

Returns the value of the date_alias parameter set at installation: either INGRESDATE or ANSIDATE.

Returns the user name of the database owner.

Returns Y if the session has db_admin privileges, and N if the session does not have db_admin privileges.

Returns the machine you are connected to. Valid even if not clustered.

Returns the number of distinct databases opened.

Returns lower, upper, or mixed.

Returns the cumulative non-disk I/O's performed by the server hosting session.

Returns the cumulative CPU time for the DBMS Server, in milliseconds, for all connected sessions.

Returns the cumulative disk I/O's performed by the server hosting session.

Returns LOWER if delimited identifiers are translated to lower case, UPPER if delimited identifiers are translated to upper case, or MIXED if the case of delimited identifiers is not translated.

Returns LOWER if regular identifiers are translated to lower case or UPPER if regular identifiers are translated to upper case.

Returns a decimal integer which represents a bit mask of "Subject" privileges.

Returns the 64 bit internal transaction ID as two decimal numbers.

Returns the current decimal format setting (set on II_DECIMAL or by the SET statement) for the session.

Returns the number of disk I/O requests for your session.

Returns the elapsed time since the start of your session, in seconds.

Returns Y if the DBMS Server is configured to flatten queries involving aggregate subselects; otherwise, returns N. (Query flattening options are specified when the DBMS Server is started.)

Returns Y if the DBMS Server is configured to flatten queries involving singleton subselects; otherwise, returns N. (Query flattening options are specified when the DBMS Server is started.)

Returns the group identifier of the session or blanks if no group identifier is in effect.

Returns the session idle time limit or -1 if there is no idle time limit.

Equivalent to IMA registration exp.gwf.gwm.glb.this_server, which returns the listen address of the attached server.

Returns the internal session ID in decimal format.

Equivalent to IMA registration exp.gwf.gwm.glb.def_vnode configuration value if set for the connected server. If not set, defaults to the local host name.

Returns the user identifier in effect at the start of the session.

Returns the language used in the current session to display messages and prompts.

Returns the cumulative time in milliseconds that a session has spent waiting for locks.

Returns Y if the user possesses lockmode database privileges or N if the user lacks these privileges.

Returns Y if 64 bit pointers are in use, or N if 32 bit addresses are used.

Returns the current connect time limit, as set by the set maxconnect statement, or the initial value if no connect time limit has been set.

Returns the value specified in the last set maxcost statement. If no previous set maxcost statement was issued or if set nomaxcost was specified last, this returns the same value as the request name query_io_limit.

Returns the value specified in the last set maxcpu statement. If no previous set maxcpu statement was issued or if set nomaxcpu was specified last, this returns the same value as the request name query_io_limit.

Returns the current idle time limit, as set with the set maxidle statement, or the initial value if no idle time limit has been set.

Returns the value specified in the last set maxio statement. If no previous set maxio statement was issued or if set nomaxio was specified last, this returns the same value as the request name query_io_limit.

Returns the value specified in the last set maxrow statement. If no previous set maxrow statement was issued or if set nomaxrow was specified last, this returns the same value as the request name query_row_limit.

Returns the value specified in the last set maxpage statement. If no previous set maxpage statement was issued or if set nomaxpage was specified last, this returns the same value as the request name query_io_limit.

Returns the size of the largest enable page cache in bytes.

Returns the decimal number representing a mask of internal privilege bits for which privileges the user might possess if all his/her privileges were enabled.

Returns the maximum width for a tuple that does not span pages. This depends on max_page_size.

Returns the current money format setting (set on II_MONEY_FORMAT or by the SET statement).

Returns the current money precision setting (set on II_MONEY_PREC or by the SET statement).

Returns the current setting for transaction error handling: rollback transaction or rollback statement. To set transaction error handling, use the set session with on_error statement.

Returns the number of times the database was opened.

Returns Y if this size cache is enabled.

Returns Y if this page type is supported.

Returns VECTOR if a partitioning specification is required on CREATE TABLE; otherwise NONE.

Returns the number of page faults for the server.

Returns the session value for query_io_limit or -1 if no limit is defined for the session.

Returns Y if the query flattening is in effect or N if the query flattening is not in effect.

Returns the session value for query_io_limit or -1 if no limit is defined for the session.

Returns sql or quel.

Returns the session value for query_io_limit or -1 if no limit is defined for the session.

Returns the session value for query_row_limit or -1 if no limit is defined for the session.

Returns the role identifier of the session or blanks if no role identifier is in effect.

Returns the name of the current security auditing log file if it is enabled and the user has maintain_audit privileges, otherwise, remains blank.

Returns the current security audit state. The following values are returned:

(blank) – Security auditing is not available

Returns Y if the effective user has the security privilege or N if the effective user does not have the security privilege.

Returns Y if the session has select_syscat privilege or N if the session does not have select_syscat privilege.

Returns the server class for the session.

Returns a description of the server class: RMS Gateway Server, Ingres Star Server, or Ingres DBMS Server.

Returns the internal session identifier in hexadecimal.

Returns the current session priority.

Returns the highest session priority that can be set, or an empty string if no session priority limit applies.

Returns the current schema name for the session.

Returns the current effective user ID of the session.

Returns the system user ID.

Returns the terminal address.

Returns Y or N, indicating that the database privilege GRANT TIMEOUT_ABORT is either enabled or disabled for the session.

Returns 1 if currently in a transaction and returns 0 if not currently in a transaction.

Returns the largest tuple for this page size or returns 0 if the cache for this page size is turned off.

Returns Unicode collation. The default is "udefault."

Returns the Unicode level for this database. Returns 0 if there is no Unicode level, otherwise returns 1 if the database is created with ‑i or ‑n flag.

Returns blank if the database does not support Unicode or does not perform normalization. Returns NFC if the database supports Normalization Form C. Returns NFD if the database supports Normalization Form D.

Returns qualified if inquire_sql(rowcount) returns the number of rows that qualified for change by the last query, or changed if inquire_sql(rowcount) returns the number of rows that were actually changed by the last query.

Returns Y if the effective user is allowed to update system catalogs or N if the effective user is not allowed to update system catalogs.

Returns the user name of the current user.

Returns the Ingres runtime number.

Returns the IP address of the node running the x100 server process.