A Rexx interface to SQL databases

Version 2.5

10 October 2006

SQLTABLES(stem name,qualifier name,owner name,table name,table type)

Arguments:

stem name

A stem that will contain the list of tables.

table qualifier

An optional string value specifying the table qualifier. You can use standard SQL wildcard characters in the string on some platforms.

table owner

An optional string value specifying the table owner. You can use standard SQL wildcard characters in the string on some platforms.

table name

An optional string value specifying the table name. You can use standard SQL wildcard characters in the string on some platforms.

table type

An optional string value specifying the table type. The table type can be an empty string, which will result in all types of database objects being returned, or or you can use various values like TABLE, VIEW or SYSTEM TABLE. On some platforms a combination of the values separated by commas (,) can be specified.

success: a number >= zero.

a value of zero indicates success.

failure: a negative number

Stem variable names:

stem-name.TABLE_CATALOG.n

Table qualifier

stem-name.TABLE_OWNER.n

Table owner

stem-name.TABLE_NAME.n

Table name

stem-name.TABLE_TYPE.n

Table type

stem-name.TABLE_DESCRIPTION.n

Table description