sql.h

SQLAPI C/C++ 连接Oracle 数据库！

#define   SQLTCMT   9			/* commit */
#define   SQLTRBK   10			/* rollback */
#define   SQLTACO   11			/* add column */
#define   SQLTDCO   12			/* drop column */
#define   SQLTRTB   13			/* rename table */
#define   SQLTRCO   14			/* rename column */
#define   SQLTMCO   15			/* modify column */
#define   SQLTGRP   16			/* grant privilege on table */
#define   SQLTGRD   17			/* grant dba */
#define   SQLTGRC   18			/* grant connect */
#define   SQLTGRR   19			/* grant resource */
#define   SQLTREP   20			/* revoke privilege on table */
#define   SQLTRED   21			/* revoke dba */
#define   SQLTREC   22			/* revoke connect */
#define   SQLTRER   23			/* revoke resource */
#define   SQLTCOM   24			/* comment on */
#define   SQLTWAI   25			/* wait */
#define   SQLTPOS   26			/* post */
#define   SQLTCSY   27			/* create synonym */
#define   SQLTDSY   28			/* drop synonym */
#define   SQLTCVW   29			/* create view */
#define   SQLTDVW   30			/* drop view */
#define   SQLTRCT   31			/* row count */
#define   SQLTAPW   32			/* alter password */
#define   SQLTLAB   33			/* label on */
#define   SQLTCHN   34			/* chained command */
#define   SQLTRPT   35			/* repair table */
#define   SQLTSVP   36			/* savepoint */
#define   SQLTRBS   37			/* rollback to savepoint */
#define   SQLTUDS   38			/* update statistics */
#define   SQLTCDB   39			/* check database */
#define   SQLTFRN   40			/* foreign DBMS commands */
#define   SQLTAPK   41			/* add primary key */
#define   SQLTAFK   42			/* add foreign key */
#define   SQLTDPK   43			/* drop primary key */
#define   SQLTDFK   44			/* drop foreign key */
/* SERVER COMMAND TYPES */
#define   SQLTCDA   45			/* create dbarea */
#define   SQLTADA   46			/* alter  dbarea */
#define   SQLTDDA   47			/* delete dbarea */
#define   SQLTCSG   48			/* create stogroup */
#define   SQLTASG   49			/* alter  stogroup */
#define   SQLTDSG   50			/* delete stogroup */
#define   SQLTCRD   51			/* create database */
#define   SQLTADB   52			/* alter  database */
#define   SQLTDDB   53			/* delete database */
#define   SQLTSDS   54			/* set default stogroup */
#define   SQLTIND   55			/* install database */
#define   SQLTDED   56			/* de-install database */
/* END OF SERVER COMMAND TYPES */

#define   SQLTARU   57			/* add RI user error */
#define   SQLTDRU   58			/* drop RI user error */
#define   SQLTMRU   59			/* modify RI user error */
#define   SQLTSCL   60			/* set client */
#define   SQLTCKT   61			/* check table */
#define   SQLTCKI   62			/* check index */
#define   SQLTOPL   63			/* PL/SQL Stored Procedure */
#define   SQLTBGT   64			/* BEGIN TRANSACTION */
#define   SQLTPRT   65			/* PREPARE TRANSACTION */
#define   SQLTCXN   66			/* COMMIT TRANSACTION */
#define   SQLTRXN   67			/* ROLLBACK TRANSACTION */
#define   SQLTENT   68			/* END TRANSACTION */

/* COMMIT SERVER COMMAND TYPES */
#define   SQLTCBT   69			/* begin transaction */
#define   SQLTCCT   70			/* commit transaction */
#define   SQLTCET   71			/* end	 transaction */
#define   SQLTCPT   72			/* prepare transaction */
#define   SQLTCRT   73			/* rollback transaction */
#define   SQLTCST   74			/* status transaction */
#define   SQLTCRX   75			/* reduce transaction */
#define   SQLTCSD   76			/* start daemon */
#define   SQLTCTD   77			/* stop daemon */
#define   SQLTCRA   78			/* resolve all transactions */
#define   SQLTCRO   79			/* resolve one transaction */
#define   SQLTCOT   80			/* orphan a transaction */
#define   SQLTCFL   81			/* CREATE FAILURE */
#define   SQLTDFL   82			/* DELETE FAILURE */
#define   SQLTSTN   83			/* SET TRACETWOPC ON */
#define   SQLTSTF   84			/* SET TRACETWOPC OFF */
#define   SQLTUNL   85			/* Unload command */
#define   SQLTLDP   86			/* load command */
#define   SQLTPRO   87			/* stored procedure */
#define   SQLTGEP   88			/* grant  execute privilege */
#define   SQLTREE   89			/* revoke execute privilege */
#define   SQLTTGC   90			/* create trigger */
#define   SQLTTGD   91			/* drop trigger */
#define   SQLTVNC   92			/* create event */
#define   SQLTVND   93			/* drop event */
#define   SQLTSTR   94			/* start audit */
#define   SQLTAUD   95			/* audit message */
#define   SQLTSTP   96			/* stop audit */
#define   SQLTACM   97			/* Alter CoMmand */
#define   SQLTXDL   98			/* lock database */
#define   SQLTXDU   99			/* unlock database */
#define   SQLTCEF  100			/* create external function */
#define   SQLTDEF  101			/* drop external function */
#define   SQLTDBT  102			/* DBATTRIBUTE */
#define   SQLTATG  103			/* ALTER TRIGGER */
#define   SQLTAEF  104			/* alter external function */
#define   SQLTADS  105			/* alter database security */
#define   SQLTAEK  106			/* alter exportkey */
#define   SQLTASP  107			/* alter server */

/* DEFAULTS */
#define   SQLDCGP   30			/* CACHEGROUP, cache page allocation group */
#define   SQLDCRT   5			/* CONNECTRETRY, seconds for connect timeout */
#define   SQLDCPT   10			/* CONNECTPAUSETICKS, ticks for pausing */
#define   SQLDDGH   10000l		/* HEAP, DBGATEWY heap size */
#define   SQLDDLH   145000l		/* HEAP, DBLOCAL heap size */
#define   SQLDDRH   20000l		/* HEAP, DBROUTER heap size */
#define   SQLDNTN   71			/* INTERRUPT, interrupt number */
#define   SQLDNBS   30000		/* NETBUFFER, size DBXROUTR network buffer */
#define   SQLDRET   3			/* RETRY, number of connect retries */
#define   SQLDSVS   0X8000		/* STACKSIZE, DBSERVER stack */
#define   SQLDSMS   0X8000		/* STACKSIZE, DBSIM stack */
#define   SQLDSRS   7000		/* STACKSIZE, DBSIM w/router stack */
#define   SQLDTMZ   0l			/* TIMEZONE */
#define   SQLDSVU   128 		/* USERS, DBSERVER users */
#define   SQLDSMU   3			/* USERS, DBSIM users */
#define   SQLDCLI   1024000L		/* checkpoint log interval in bytes */
#define   SQLDCTI   1			/* checkpt time interval in minutes */
#define   SQLDWSA   1000		/* cursor work space allocation */
#define   SQLDPRE   5			/* decimal precision */
#define   SQLDSCA   0			/* decimal scale */
#define   SQLDIML   2000		/* input message buffer length */
#define   SQLDPRI   10			/* integer precision */
#define   SQLDSUL   6			/* length of system user name */
#define   SQLDLBS   20480		/* log buffer size in bytes */
#define   SQLDLFS   1024000L		/* log file size in bytes */
#define   SQLDSLS   15			/* maximum # of large server stacks */
#define   SQLDHFS   1000		/* maximum history file size */
#define   SQLDLPM   20000		/* maximum number of rollback log pages */
#define   SQLDNES   100 		/* normal file extension size */
#define   SQLDOML   1000		/* output message buffer length */
#define   SQLDPES   1024		/* partitioned file extension size */
#define   SQLDPUB   "PUBLIC"		/* public user name */
#define   SQLDLPT   16000		/* rollback log page threshold */
#define   SQLDPRS   5			/* smallint precision */
#define   SQLDRTO   5			/* default response time out */
#define   SQLDSUN   "SYSADM"		/* system default username */
#define   SQLDESC   "$$"		/* connect escape sequence */
#define   SQLDSUN   "SYSADM"		/* system default username */
#define   SQLDNTG   16                  /* number of triggers allowed per event/time/scope */
                                        /* Maximum triggers for an event is * 4 */

/* MAXIMUM SIZES */
#define   SQLMSBNL  18			/* short bind name length */
#define   SQLMBNL   36			/* bind name length */
#define   SQLMLBNL  64			/* long bind name length */
#define   SQLMBSL   32000		/* max length Backend string literal */
#define   SQLMCG1   32767		/* cache group pages */
#define   SQLMCKF   16			/* concatenated key fields */
#define   SQLMCLL   255 		/* clientlimit */
#define   SQLMCLN   12			/* maximum client name size */
#define   SQLMCLP   128 		/* commmand line parameter length */
#define   SQLMCMT   106 		/* max command types */
#define   SQLMCNM   SQLMBNL		/* max referential constraint name */
#define   SQLMCOH   255 		/* column heading string */
#define   SQLMCST   400 		/* max connect string length */
#define   SQLMDBA   10			/* number of databases accessed */
#define   SQLMDFN   25			/* database file name */
#define   SQLMPSS   25			/* process status string */
#define   SQLMDMO   750 		/* maximum DB size for demos (Kbytes) */
#define   SQLMSDNM  8			/* database name CAM_1..4_VERSION */
#define   SQLMDNM   16			/* database name */
#define   SQLMDVL   254 		/* data value length */
#define   SQLMERR   255 		/* error message length */
#define   SQLMETX   3000		/* error text length */
/* ------------------------------------------------------------------------- *
 * We are reverting back to the previous value of 128 for SQLMFNL because it *
 * is resulting in unnecessary complications in the cdm, aic size etc.	     *
 * ------------------------------------------------------------------------- */
#define   SQLMFNL   128 	 /* filename length */

/* ------------------------------------------------------------------------- *
 * Note : We are defining a new constant called SQLRFNL which is used to     *
 * create a filename of restricted length (128) instead of SQLMFNL. It is    *
 * required because the areas table created by main.ini uses a pathname of   *
 * 128 bytes								     *
 * ------------------------------------------------------------------------- */
#define   SQLRFNL   128
#define   SQLMFQN   3			/* number of fields in fully qualified column name */
#define   SQLMFRD   40			/* maximum size of foreign result set directory */
#define   SQLMGCM   32767		/* maximum group commit count */
#define   SQLMICO   255 		/* installed cache page owners */
#define   SQLMICU   255 		/* installed cursors */
#define   SQLMIDB   255 		/* installed databases */
#define   SQLMILK   32767		/* installed locks */
#define   SQLMINL   2000		/* input length */
#define   SQLMIPG   1000000		/* installed pages */
#define   SQLMIPR   800 		/* installed processes */
#define   SQLMITR   800 		/* installed transactions */
#define   SQLMJTB   17			/* joined tables */
#define   SQLMTAC   17*16       /* tables each tab can have subsel */
#define   SQLMLID   32			/* long identifiers */
#define   SQLMNBF   60000		/* network buffer size */
#define   SQLMNCO   254 		/* number of columns per row */
#define   SQLMUCO   253 		/* number of user columns available */
#define   SQLMNPF   3			/* NETPREFIX size */
#define   SQLMOUL   1000		/* output length */
#define   SQLMPAL   255 		/* max path string length */
#define   SQLMSVP   1024 		/* max serverpath (inside ini client section)  string length */
#define   SQLMPFS   21			/* max platform string length */
#define   SQLMPKL   254 		/* max primary key length */
#define   SQLMPRE   15			/* maximum decimal precision */
#define   SQLMPTL   4			/* maximum print level */
#define   SQLMPWD   128 		/* maximum password length */
#define   SQLMCTL   43200		/* max query timelimit (12 hours) */
#define   SQLMRBB   8192		/* maximum rollback log buffer */
#define   SQLMRCB   20480		/* maximum recovery log buffer */
#define   SQLMRET   1000		/* retry count */
#define   SQLMRFH   4			/* maximum # remote file handles */
#define   SQLMROB   8192		/* max size of restore output buffer */
#define   SQLMSES   16			/* number of sessions */
#define   SQLMSID   8			/* short identifiers */
#define   SQLMSLI   255 		/* max number of select list exprs. */
#define   SQLMSNM   8			/* server name */
#define   SQLMSRL   32			/* max length of SQL reserved word */
#define   SQLMSVN   199 		/* maximum server names */
#define   SQLMTFS   10			/* maximum temporary file size */
#define   SQLMTMO   200 		/* maximum timeout */
#define   SQLMTSS   256 		/* text string space size */
#define   SQLMUSR   128 		/* maximum username length */
#define   SQLMVER   8			/* max version string (nn.nn.nn) */
#define   SQLMXER   255 		/* Extended error message length */
#define   SQLMXFS   2147483648UL	/* max file size in bytes */
#define   SQLMXLF   2097152		/* max log file size in KB */
#define   SQLMTHM   2			/* maximum thread mode value */
#define   SQLMPKL   254 		/* max primary key length */
#define   SQLMGTI   250 		/* max global transaction-id length */
#define   SQLMAUF   32			/* max concurrent audit files */
#define   SQLMPNM   8			/* max protocol name length */
#define   SQLMOSR   255 		/* max OS sample rate */
#define   SQLMAWS   255 		/* max OS Averaging window size */
#define   SQLMMID   32			/* max length identificatin strings */

/* MINIMUMS */
#define   SQLMCG0   1			/* cache group pages */
#define   SQLMEXS   1024		/* partitioned file extension size */
#define   SQLMLFE   100000L		/* minimum log file extension size */
#define   SQLMLFS   100000L		/* minimum log file size */
#define   SQLMPAG   15			/* minimum pages (cache) */
#define   SQLMITM   1			/* minimum thread mode value */

/* typedefs */
#if defined(WIN32) || defined(SYSFWNT)
    #ifndef SQLFI64
    #define SQLFI64
    typedef   __int64        b8;		/* 64-bits signed */
    typedef   unsigned __int64 ub8;		/* 64-bits unsigned */
    #endif

#else
    #ifndef SQLFI64
    #define SQLFI64
    typedef struct {
        unsigned long LoPart;
        unsigned long HiPart;
    } ub8;
    typedef struct {
        unsigned long LoPart;
        long          HiPart;
    } b8;
    #endif

#endif

typedef   unsigned char     ubyte1;
typedef   unsigned short    ubyte2;
typedef   unsigned long     ubyte4;
typedef   ub8               ubyte8;
typedef 	   ubyte1     byte1;
typedef 	   short     byte2;
typedef 	   long      byte4;
typedef   b8                 byte8;
typedef   unsigned char PTR ubyte1p;
typedef int (SBSTDCALL *SQLTPFP)(void);

typedef   ubyte1    SQLTARC;		/* remote connection architecture */
typedef   ubyte1    SQLTBNL;		/* bind name length */
typedef   ubyte1    SQLTBNN;		/* bind number */
typedef   ubyte1p   SQLTBNP;		/* bind name pointer */
typedef   byte2     SQLTNUL;		/* null indicator */
typedef   ubyte1    SQLTBOO;		/* boolean data type */
typedef   ubyte1    SQLTCDL;		/* column data length */
typedef   ubyte1    SQLTCHL;		/* column header length */
typedef   ubyte1    SQLTCHO;		/* check option */
typedef   ubyte1p   SQLTCHP;		/* column header pointer */
typedef   ubyte2    SQLTCLL;		/* column data length(long) */
typedef   ubyte1    SQLTCTY;		/* command type */
typedef   ubyte2    SQLTCUR;		/* cursor number */
typedef   ubyte2    SQLTDAL;		/* data length */
typedef   ubyte1p   SQLTDAP;		/* data pointer */
typedef   byte2     SQLTDAY;		/* number of days */
typedef   ubyte1    SQLTDDL;		/* database data length */
typedef   ubyte1    SQLTDDT;		/* database data type */
typedef   ubyte2    SQLTDEDL;		/* database extended data length */
typedef   ubyte2    SQLTDPT;		/* database parameter type */
typedef   ubyte4    SQLTDPV;		/* database parameter value */
typedef   ubyte2    SQLTEPO;		/* error position */
typedef   ubyte2    SQLTFAT;		/* file attribute */
typedef   ubyte2    SQLTFLD;		/* SELECT statement field number */
typedef   byte2     SQLTFLG;		/* flag field */
typedef   ubyte4    SQLTFLH;		/* file handle */
typedef   byte2     SQLTFMD;		/* file mode */
typedef   ubyte2    SQLTFNL;		/* file name length */
typedef   ubyte1p   SQLTFNP;		/* file name pointer */
typedef   ubyte1    SQLTFSC;		/* fetch status code */
typedef   ubyte1p   SQLTILV;		/* isolation level string */
typedef   ubyte1    SQLTLBL;		/* label information length */
typedef   ubyte1p   SQLTLBP;		/* label infromation pointer */
typedef   byte8     SQLTLLI;		/* long long integer */
typedef   byte4     SQLTLNG;		/* long size */
typedef   ubyte4    SQLTLSI;		/* long size */
typedef   ubyte2    SQLTMSZ;		/* message size */