SQLColumns
Full Description
swirl
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.

Copyright © OmniMark Technologies Corporation, 1988-1998.