A Rexx interface to SQL databases

Version 2.6

16 September 2012

SQLGETINFO([connection name],variable name [,stem name])

Like SQLVARIABLE this function returns its information in the return string, but by specifying a stem name, the results are returned in that stem variable. The stem name must include a trailing period.
The stem name option is useful for the DATATYPES option, as many databases have datatype names that contain spaces.

Arguments:

connection name

This is the connection name used when retrieving variables that require a database connection. If the connection name is not used and the variable requires a database connection, the current connection is used.

variable name

The name of the variable who's value is to be retrieved.

with stem name specified:

the value of the variable name option in a compound variable. The compound variable consists of a stem corresponding to connection name and a tail corresponding to variable name. A return code of 0 indicates the function completed successfully, or a negative number representing an internal or database error.

with stem name NOT specified:

the value of the variable name option

• DATATYPES
  this returns a space seperated list of column attributers appropriate for the database. See SQLDESCRIBE and the database-specific appendix for a list and description of these attributes.

• DESCRIBECOLUMNS
  this returns a space seperated list of column attributers appropriate for the database. See SQLDESCRIBE and the database-specific appendix for a list and description of these attributes.

• SUPPORTSTRANSACTIONS
  this returns 1 if the database supports transactions. ie. the SQLCOMMIT and SQLROLLBACK functions actually do something. A value of 0 indicates the database does not support transactions.

• SUPPORTSSQLGETDATA
  this returns 1 if the database supports the Rexx/SQL function; SQLGETDATA. A value of 0 indicates the database does not support SQLGETDATA.

• SUPPORTSTHREADS
  this returns 1 if the database client software (what Rexx/SQL uses to interface to the database) is thread-safe. A value of 0 indicates the database client software may or may not be thread-safe.

• DBMSNAME
  this returns the name of the database currently connected to and optionally a version number of that database.

• DBMSVERSION
  this returns the version number of the database currently connected to, provided the database client software provides this information.

Say "Getting mSQL datatypes with stem..."
rc = sqlgetifno("c1","DATATYPES","dt.")
Do i = 1 To dt.0
   Say i '-' dt.i
End
Say "Getting mSQL datatypes without stem..."
Say sqlgetifno(c1,"DATATYPES")