DBPARAM function

Returns, as a character string, a comma-separated list of the parameters used to connect to the database.

Syntax 

 

DBPARAM ( integer-expression | logical-name | alias )

integer-expression

The sequence number of a database the ABL session is connected to. For example, DBPARAM(1) returns information on the first database the ABL session is connected to, DBPARAM(2) returns information on the second database the ABL session is connected to, etc. If you specify a sequence number that does not correspond to a database the ABL session is connected to, the DBPARAM function returns the Unknown value (?).

logical-name or alias

These forms of the DBPARAM function require a character expression as a parameter. An unquoted character string is not permitted. If the parameter is an alias or the logical name of a connected database, then the AVM returns the comma-separated parameter list. Otherwise, it returns the Unknown value (?).

Notes 

A database must be connected for the DBPARAM function to work as described.

If the CONNECT statement does not contain a -db (database) parameter, which is permissible, the string DBPARAM returns includes the -db parameter and the database name.

If the CONNECT statement contains the -pf parameter, which refers to a parameter file, the string DBPARAM returns includes the parameters in the file without “-pf” or any reference to the file.

If the CONNECT statement contains a userid and a password, the string DBPARAM returns includes only the userid.

The database can connect through the CONNECT statement, the command line, or an auto-connection.

See also 

DBCODEPAGE function, DBCOLLATION function, DBTYPE function, DBVERSION function