sql.h

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

#define   SQLPFAT   4000		/* first attribute */
#define   SQLPBRS   4001		/* back end result sets */
#define   SQLPMUL   4002		/* multi-user */
#define   SQLPDMO   4003		/* demonstration version */
#define   SQLPLOC   4004		/* local version of database */
#define   SQLPFPT   4005		/* 1st participant */
#define   SQLPLAT   4006		/* last attribute */
#define   SQLPCAP   4007		/* API capability level */
#define   SQLPSCL   4008		/* server capability level */
#define   SQLPRUN   4009		/* runtime version */

/*	Server specific parameters
	---------------------------- */

#define   SQLPPLV   5001		/* print level */
#define   SQLPALG   5002		/* activity log */
#define   SQLPTMS   5003		/* time stamp */
#define   SQLPPTH   5004		/* path name seperator */
#define   SQLPTMZ   5005		/* time zone */
#define   SQLPTCO   5006		/* time colon only */

/*	SQL Server & Router/Gateway specific parameters
	------------------------------ */
#define   SQLPESTR  5101		/* get server error # and string */
#define   SQLPMSTR  5102		/* get server msg# and string */
#define   SQLPMAPC  5103		/* MapGTICursors */
#define   SQLPUPRE  5104		/* get user prefix */
#define   SQLPORID  5105		/* Oracle RowID */
#define   SQLPERRM  5106		/* error mapping */
#define   SQLPRTS   5107		/* SQL Server - Return Status */
#define   SQLPSAUT  5108		/* SQL Server - Autocommit */
#define   SQLPROW   5109		/* SQL Server - Command Type */
#define   SQLPEHC   5110		/* SQL Server - Enhanced Cursors */
#define   SQLPGFS   5111		/* SQL Server - Get Fetch Status */
#define   SQLPLBUF  5112		/* Longbuffer setting */
#define   SQLPDPH   5113		/* SQL Server - DBProcess handle */
#define   SQLPCKE   5114		/* SQL Server - CHECK EXISTS */
#define   SQLPWTX   5115		/* SQL Server - DBWRITETEXT */
#define   SQLPYLD   5116		/* SQL Server - YieldOnServerCall */
#define   SQLPOBN   5117		/* ODBC Router - backend brand */
#define   SQLPOBV   5118		/* ODBC Router - backend version */
#define   SQLPODN   5119		/* ODBC Router - driver name */
#define   SQLPODV   5120		/* ODBC Router - driver version */
#define   SQLPOCV   5121		/* ODBC Router - ODBC version */
#define   SQLPRSYS  5122  /* DRDA - EXEC SQL CONNECT TO remote system name */
#define   SQLPLAB   5123  /* DB2 - return label information if exists */
#define   SQLPCID   5124  /* DB2 - Set Current SQLID default */
#define   SQLPNUMST 5125		/* AS/400 Number of Statements */
#define   SQLPBNDRW 5126		/* Oracle- bind SQLPBUF as RAW */
#define   SQLPNLS   5127		/* Informix - NLS database */

#define   SQLPFRW   5200		/* fetchrow */
#define   SQLPBRW   5201		/* buffrow */

/* Sybase System 10 parameters (reserved 5220 - 5250)
   ------------------------------------------------------------ */

#define   SQLPNESTR 5220       /* SYB - get next error from client */
#define   SQLPNMSTR 5221       /* SYB - get next error from server */
#define   SQLPCESTR 5222       /* SYB - get client message count */
#define   SQLPCMSTR 5223       /* SYB - get server message count */
#define   SQLPTXT   5224       /* SYB - allow bind for text, image */
#define   SQLPEMC   5225       /* SYB - enable multiple connections */

/*	ODBC specific parameters - Refer to ODBC spec for definition
	------------------------------------------------------------ */

#define   SQLP_ACTIVE_CONNECTIONS	  5500
#define   SQLP_ACTIVE_STATEMENTS	  5501
#define   SQLP_DATA_SOURCE_NAME 	  5502
#define   SQLP_DRIVER_HDBC		  5503
#define   SQLP_DRIVER_HENV		  5504
#define   SQLP_DRIVER_HSTMT		  5505
#define   SQLP_DRIVER_NAME		  5506
#define   SQLP_DRIVER_VER		  5507
#define   SQLP_FETCH_DIRECTION		  5508
#define   SQLP_ODBC_API_CONFORMANCE	  5509
#define   SQLP_ODBC_VER 		  5510
#define   SQLP_ROW_UPDATES		  5511
#define   SQLP_ODBC_SAG_CLI_CONFORMANCE   5512
#define   SQLP_SERVER_NAME		  5513
#define   SQLP_SEARCH_PATTERN_ESCAPE	  5514
#define   SQLP_ODBC_SQL_CONFORMANCE	  5515
#define   SQLP_DATABASE_NAME		  5516
#define   SQLP_DBMS_NAME		  5517
#define   SQLP_DBMS_VER 		  5518
#define   SQLP_ACCESSIBLE_TABLES	  5519
#define   SQLP_ACCESSIBLE_PROCEDURES	  5520
#define   SQLP_PROCEDURES		  5521
#define   SQLP_CONCAT_NULL_BEHAVIOUR	  5522
#define   SQLP_CURSOR_COMMIT_BEHAVIOUR	  5523
#define   SQLP_CURSOR_ROLLBACK_BEHAVIOUR  5524
#define   SQLP_DATA_SOURCE_READ_ONLY	  5525
#define   SQLP_DEFAULT_TXN_ISOLATION	  5526
#define   SQLP_EXPRESSIONS_IN_ORDERBY	  5527
#define   SQLP_IDENTIFIER_CASE		  5528
#define   SQLP_IDENTIFIER_QUOTE_CHAR	  5529
#define   SQLP_MAX_COLUMN_NAME_LEN	  5530
#define   SQLP_MAX_CURSOR_NAME_LEN	  5531
#define   SQLP_MAX_OWNER_NAME_LEN	  5532
#define   SQLP_MAX_PROCEDURE_NAME_LEN	  5533
#define   SQLP_MAX_QUALIFIER_NAME_LEN	  5534
#define   SQLP_MAX_TABLE_NAME_LEN	  5535
#define   SQLP_MULT_RESULT_SETS 	  5536
#define   SQLP_MULTIPLE_ACTIVE_TXN	  5537
#define   SQLP_OUTER_JOINS		  5538
#define   SQLP_OWNER_TERM		  5539
#define   SQLP_PROCEDURE_TERM		  5540
#define   SQLP_QUALIFIER_NAME_SEPARATOR   5541
#define   SQLP_QUALIFIER_TERM		  5542
#define   SQLP_SCROLL_CONCURRENCY	  5543
#define   SQLP_SCROLL_OPTIONS		  5544
#define   SQLP_TABLE_TERM		  5545
#define   SQLP_TXN_CAPABLE		  5546
#define   SQLP_USER_NAME		  5547
#define   SQLP_CONVERT_FUNCTIONS	  5548
#define   SQLP_NUMERIC_FUNCTIONS	  5549
#define   SQLP_STRING_FUNCTIONS 	  5550
#define   SQLP_SYSTEM_FUNCTIONS 	  5551
#define   SQLP_TIMEDATE_FUNCTIONS	  5552
#define   SQLP_CONVERT_BIGINT		  5553
#define   SQLP_CONVERT_BINARY		  5554
#define   SQLP_CONVERT_BIT		  5555
#define   SQLP_CONVERT_CHAR		  5556
#define   SQLP_CONVERT_DATE		  5557
#define   SQLP_CONVERT_DECIMAL		  5558
#define   SQLP_CONVERT_DOUBLE		  5559
#define   SQLP_CONVERT_FLOAT		  5560
#define   SQLP_CONVERT_INTEGER		  5561
#define   SQLP_CONVERT_LONGVARCHAR	  5562
#define   SQLP_CONVERT_NUMERIC		  5563
#define   SQLP_CONVERT_REAL		  5564
#define   SQLP_CONVERT_SMALLINT 	  5565
#define   SQLP_CONVERT_TIME		  5566
#define   SQLP_CONVERT_TIMESTAMP	  5567
#define   SQLP_CONVERT_TINYINT		  5568
#define   SQLP_CONVERT_VARBINARY	  5569
#define   SQLP_CONVERT_VARCHAR		  5570
#define   SQLP_CONVERT_LONGVARBINARY	  5571
#define   SQLP_TXN_ISOLATION_OPTION	  5572
#define   SQLP_ODBC_SQL_OPT_IEF 	  5573

/*** ODBC SDK 1.0 Additions ***/
#define   SQLP_CORRELATION_NAME 	  5574
#define   SQLP_NON_NULLABLE_COLUMNS	  5575

/*** ODBC SDK 2.0 Additions ***/
#define   SQLP_DRIVER_HLIB		  5576
#define   SQLP_DRIVER_ODBC_VER		  5577
#define   SQLP_LOCK_TYPES		  5578
#define   SQLP_POS_OPERATIONS		  5579
#define   SQLP_POSITIONED_STATEMENTS	  5580
#define   SQLP_GETDATA_EXTENSIONS	  5581
#define   SQLP_BOOKMARK_PERSISTENCE	  5582
#define   SQLP_STATIC_SENSITIVITY	  5583
#define   SQLP_FILE_USAGE		  5584
#define   SQLP_NULL_COLLATION		  5585
#define   SQLP_ALTER_TABLE		  5586
#define   SQLP_COLUMN_ALIAS		  5587
#define   SQLP_GROUP_BY 		  5588
#define   SQLP_KEYWORDS 		  5589
#define   SQLP_ORDER_BY_COLUMNS_IN_SELECT 5590
#define   SQLP_OWNER_USAGE		  5591
#define   SQLP_QUALIFIER_USAGE		  5592
#define   SQLP_QUOTED_IDENTIFIER_CASE	  5593
#define   SQLP_SPECIAL_CHARACTERS	  5594
#define   SQLP_SUBQUERIES		  5595
#define   SQLP_UNION			  5596
#define   SQLP_MAX_COLUMNS_IN_GROUP_BY	  5597
#define   SQLP_MAX_COLUMNS_IN_INDEX	  5598
#define   SQLP_MAX_COLUMNS_IN_ORDER_BY	  5599
#define   SQLP_MAX_COLUMNS_IN_SELECT	  5600
#define   SQLP_MAX_COLUMNS_IN_TABLE	  5601
#define   SQLP_MAX_INDEX_SIZE		  5602
#define   SQLP_MAX_ROW_SIZE_INCLUDES_LONG 5603
#define   SQLP_MAX_ROW_SIZE		  5604
#define   SQLP_MAX_STATEMENT_LEN	  5605
#define   SQLP_MAX_TABLES_IN_SELECT	  5606
#define   SQLP_MAX_USER_NAME_LEN	  5607
#define   SQLP_MAX_CHAR_LITERAL_LEN	  5608
#define   SQLP_TIMEDATE_ADD_INTERVALS	  5609
#define   SQLP_TIMEDATE_DIFF_INTERVALS	  5610
#define   SQLP_NEED_LONG_DATA_LEN	  5611
#define   SQLP_MAX_BINARY_LITERAL_LEN	  5612
#define   SQLP_LIKE_ESCAPE_CLAUSE	  5613
#define   SQLP_QUALIFIER_LOCATION	  5614

#define   SQLP_GET_TYPE_INFO		  5699


/*	The following parmeters in the range 6000 - 7000 are reserved for
	SQLBase INTERNAL use.
*/

#define  SQLP000    6000		/* for internal use only */
#define  SQLP999    6999		/* for internal use only */
#define  SQLPITP  0x4000		/* INTERNAL USE ONLY */
#define  SQLPITC  0x8000		/* INTERNAL USE ONLY */

/* end of SET and GET PARAMETER TYPES */


/* defines for ON, OFF, DEFAULT parameter values */

#define   SQLVOFF    0			/* parameter should be OFF */
#define   SQLVON     1			/* parameter should be ON */
#define   SQLVDFL    2			/* parameter should default */

/* defines for SQLPDBM (db mode) */

#define   SQLMDBL    1			/* DB Local */
#define   SQLMRTR    2			/* DB Router */
#define   SQLMCOM    3			/* DB Combo */

/* defines for database brands */

#define   SQLBSQB    1			/* SQLBASE */
#define   SQLBDB2    2			/* DB2 */
#define   SQLBDBM    3			/* IBM OS/2 Database Manager */
#define   SQLBORA    4			/* Oracle */
#define   SQLBIGW    5			/* Informix */
#define   SQLBNTW    6			/* Netware SQL */
#define   SQLBAS4    7			/* IBM AS/400 SQL/400 */
#define   SQLBSYB    8			/* Sybase SQL Server */
#define   SQLBDBC    9			/* Teradata DBC Machines */
#define   SQLBALB   10			/* HP Allbase */
#define   SQLBRDB   11			/* DEC's RDB */
#define   SQLBTDM   12			/* Tandem's Nonstop SQL */
#define   SQLBSDS   13			/* IBM SQL/DS */
#define   SQLBSES   14			/* SNI SESAM */
#define   SQLBING   15			/* Ingres */
#define   SQLBSQL   16			/* SQL Access */
#define   SQLBDBA   17			/* DBase */
#define   SQLBDB4   18			/* SNI DDB4 */
#define   SQLBFUJ   19			/* Fujitsu RDBII */
#define   SQLBSUP   20			/* Cincom SUPRA */
#define   SQLB204   21			/* CCA Model 204 */
#define   SQLBDAL   22			/* Apple DAL interface */
#define   SQLBSHR   23			/* Teradata ShareBase */
#define   SQLBIOL   24			/* Informix On-Line */
#define   SQLBEDA   25			/* EDA/SQL */
#define   SQLBUDS   26			/* SNI UDS */
#define   SQLBMIM   27			/* Nocom Mimer */
#define   SQLBOR7   28			/* Oracle version 7 */
#define   SQLBIOS   29			/* Ingres OpenSQL */
#define   SQLBIOD   30			/* Ingres OpenSQL with date support */
#define   SQLBODB   31			/* ODBC Router */
#define   SQLBS10   32			/* SYBASE System 10 */
#define   SQLBSE6   33			/* Informix SE version 6 */
#define   SQLBOL6   34			/* Informix On-Line version 6 */
#define   SQLBNSE   35			/* Informix SE NLS version 6 */
#define   SQLBNOL   36			/* Informix On-Line NLS version 6 */
#define   SQLBSE7   37			/* Informix SE version 7 */
#define   SQLBOL7   38			/* Informix On-Line version 7 */
#define   SQLBETA   39			/* Entire Access, ADABAS */
#define   SQLBI12   40			/* Ingres CA-OpenIngres 1.2 */
#define   SQLBAPP   99			/* SQLHost App Services */

/* SIZES */
#define   SQLSNUM   12			/* numeric program buffer size */
#define   SQLSDAT   12   		/* date-time program buffer size */
#define   SQLSCDA   26			/* character date-time size */
#define   SQLSDTE   SQLSDAT		/* date (only) program buffer size */
#define   SQLSCDE   10			/* character date (only) size */
#define   SQLSRID   40			/* size of ROWID */
#define   SQLSTIM   SQLSDAT		/* time (only) program buffer size */
#define   SQLSCTI   15			/* character time (only) size */
#define   SQLSFEM   100L		/* file extension size (multi-user) */
#define   SQLSFES   20L 		/* file extension size (single-user) */
#define   SQLSTEX   5L			/* table extent size */


/* Two-phase Commit Protocols */

typedef   int		  SQLT2PP;		/* type: 2-phase commit protocol */

#define   SQL2MIN   SQL2STD		/* minimum protocol value */

#define   SQL2STD   ((SQLT2PP) 1)	/* standard 2pc protocol */
#define   SQL2PRA   ((SQLT2PP) 2)	/* presumed-abort 2pc protocol */
#define   SQL2PRC   ((SQLT2PP) 3)	/* presumed-commit 2pc protocol */
#define   SQL2DEF   SQL2STD		/* default is standard */

#define   SQL2MAX   SQL2PRC		/* maximum protocol value */

/* Two-phase Commit Votes */

typedef   int		  SQLT2PV;	/* type: 2-phase commit vote */

#define   SQLVMIN   SQLVCMT		/* minimum vote value */

#define   SQLVCMT   ((SQLT2PV) 1)	/* Vote Commit */
#define   SQLVRBK   ((SQLT2PV) 2)	/* Vote Rollback */
#define   SQLVRO    ((SQLT2PV) 3)	/* Vote ReadOnly */

#define   SQLVMAX   SQLVRO		/* maximum vote value */

/* defines for distributed transaction status */

typedef   int	  SQLTTST;		/* distributed transaction state */

#define   SQLSCMT  ((SQLTTST) 1)	/* transaction state = COMMITted */
#define   SQLSRBK  ((SQLTTST) 2)	/* transaction state = ROLLBACKed */
#define   SQLSUNK  ((SQLTTST) 3)	/* transaction state = UNKNOWN */


/* NULL POINTER */
#define   SQLNPTR   (ubyte1 PTR)0	/* null pointer */
/* RESULT COMMAND TYPES */
#define   SQLTSEL   1			/* select */
#define   SQLTINS   2			/* insert */
#define   SQLTCTB   3			/* create table */
#define   SQLTUPD   4			/* update */
#define   SQLTDEL   5			/* delete */
#define   SQLTCIN   6			/* create index */
#define   SQLTDIN   7			/* drop index */
#define   SQLTDTB   8			/* drop table */