A Rexx interface to SQL databases

Version 2.5

10 October 2006

SQLDESCRIBE(statement name [,stem name])

Describes the expressions returned by a SELECT statement. The statement should first be prepared (with SQLPREPARE) and then described. Creates a compound variable for each column in the select list of the sql statement, with a stem equal to the statement name, followed by 'COLUMN' and with at least the following column attributes: NAME, TYPE, SIZE, SCALE, PRECISION, NULLABLE.

The full list of column attributes can be obtained by calling SQLVARIABLE with the DESCRIBECOLUMNS parameter. See the database-specific appendix for the meaning of other column attributes returned.


statement name
A name to identify the sql statement.

stem name
An optional name specifying the stem name of the Rexx variables created.

success: a positive number, or zero, indicating the number of expressions in the select list of the SELECT statement
failure: a negative number
rc = sqlprepare(s2,"select ename, empno from emp")
rc = sqldescribe(s2,"AA")

results in the following Rexx variables being set:

The values returned are implementation dependant.

Copyright © Mark Hessling 1997-2006 <>

Return to Table of Contents
Last updated 10 October 2006