Identifies the prepared statement about which you want to obtain information.
Identifies the table or view. When the DESCRIBE statement is executed, host-variable must be a character string data type (a CHAR or VARCHAR variable) that contains a name identifying a table or view. If the escape character is used in the string it must be the quotation mark (double-quotes). Host-variable must be preceded by a colon. An indicator variable is not allowed.
Identifies an SQL Descriptor Area (SQLDA) to be filled. See SQLDA (DESCRIBE or PREPARE INTO Statements). If the TABLE clause is used to describe a table or view, the information returned in the SQLDA describes the columns of the specified table or view. If statement-name is used to describe a select-statement associated with a dynamic cursor, the information returned in the SQLDA describes the columns of the result table of the select-statement. When any other prepared statement is described, the SQLD field of the SQLDA is set to zero, which indicates a statement other than a select-statement has been described.
Specifies if the SQLNAME field in the SQLDA is to contain a column name or a column label. If the requested value does not exist, SQLNAME is set to length 0.
Assigns the name of the column. This is the default.
Assigns the label for the column. A label is the column's CA Datacom Datadictionary field attribute HEADING-1.
Assigns the column label, or (if one does not exist) the column name.
Assigns the column names to the first n occurrences of SQLVAR, and the column labels to the second n occurrences.
|
Copyright © 2014 CA.
All rights reserved.
|
|