/*
**    Name: Procs.c
**
**    Date: Sun Jan 20 16:56:51 2002
**
*/

#include "ODBCLib.h"
#include "isql.h"
#include "isqlext.h"
#include "kernel.h"

SQLRETURN  SQLProcedures(
    SQLHSTMT hstmt,
    SQLCHAR * szCatalogName,
    SQLSMALLINT cbCatalogName,
    SQLCHAR * szSchemaName,
    SQLSMALLINT cbSchemaName,
    SQLCHAR * szProcName,
    SQLSMALLINT cbProcName)
    {
    _kernel_swi_regs regs;

/* Wait for ready status */

    if (ODBCLibWait(ODBC_STATE_READY))
        {
        return SQL_ERROR;
        }

/* Store parameters */

    regs.r[0] = SQL_Procedures;
    regs.r[1] = (int)hstmt;
    regs.r[2] = (int)szCatalogName;
    regs.r[3] = (int)cbCatalogName;
    regs.r[4] = (int)szSchemaName;
    regs.r[5] = (int)cbSchemaName;
    regs.r[6] = (int)szProcName;
    regs.r[7] = (int)cbProcName;

    _kernel_swi(SQL_SystemTablesP,&regs,&regs);

/* Wait for completion */

    if (ODBCLibWait(ODBC_STATE_COMPLETE))
        {
        return SQL_ERROR;
        }

/* Get results */

    regs.r[0] = SQL_Procedures;
    regs.r[1] = (int)hstmt;
    regs.r[2] = (int)szCatalogName;
    regs.r[3] = (int)cbCatalogName;
    regs.r[4] = (int)szSchemaName;
    regs.r[5] = (int)cbSchemaName;
    regs.r[6] = (int)szProcName;
    regs.r[7] = (int)cbProcName;

    _kernel_swi(SQL_SystemTables,&regs,&regs);

    return (SQLRETURN)ODBCLibFinished();
    }
