Syntax
define external counter function SQLColumns
( read-only SQL_handle_type StatementHandle,
value stream CatalogName,
value counter NameLength1,
value stream SchemaName,
value counter NameLength2,
value stream TableName,
value counter NameLength3,
value stream ColumnName,
value counter NameLength4 )
Purpose
Returns the list of column names in specified tables. The information is returned as a result set on the specified statement handle.
Input arguments:
- StatementHandle.
- CatalogName.The catalog name. If a driver supports catalogs for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without catalogs. CatalogName cannot contain a string search pattern.
- NameLength1. The length of CatalogName.
- SchemaName. The string-search pattern for schema names. If a driver supports schemas for some tables but not others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without schemas.
- NameLength2. The length of SchemaName.
- TableName. The string-search pattern for table names.
- NameLength3. The length of TableName.
- ColumnName. The string-search pattern for column names.
- NameLength4. The length of ColumnName.
|