Full text search
function	SQLProcedureColumns

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (the list of input and output parameters was retrieved). SQL_SUCCESS_WITH_INFO (the list of input and output parameters was retrieved, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid). SQL_STILL_EXECUTING (the program is still executing).

Declaration

  define external counter function SQLProcedureColumns
     (  read-only SQL_handle_type StatementHandle,
        value stream CatalogName,
        value counter NameLength1,
        value stream SchemaName,
        value counter NameLength2,
        value stream ProcName,
        value counter NameLength3,
        value stream ColumnName,
        value counter NameLength4   )

Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. The information is returned as a result set on the specified statement.

Input arguments:

• StatementHandle.
• CatalogName. 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. A string-search pattern for schema names. If a driver supports schemas for some tables but not for others, such as when the driver retrieves data from different DBMSs, an empty string ("") denotes tables without schemas.
• NameLength2. The length of SchemaName.
• ProcName. A string-search pattern for procedure names.
• NameLength3. The length of ProcName.
• ColumnName. A string-search pattern for column names.
• NameLength4. The length of ColumnName.