sql.h

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

/* COPYRIGHT (C) GUPTA TECHNOLOGIES, LLC 1984-2004 */
/*
INTERFACE TO
  SQL
*/
/*
REVISION HISTORY
  12/04/91 GTI release 5.0.0
  12/08/91 GTI release 5.0.1
  04/01/92 GTI release 5.0.2
  08/28/92 GTI release 5.1.0
  11/02/92 GTI release 5.1.1
  02/12/93 GTI release 5.1.2
  04/02/93 GTI release 5.2.0
  05/03/93 GTI release 5.2.0
  06/15/93 GTI release (null)
  06/15/93 GTI release 5.2.A
  06/30/93 GTI release 5.1.3
  08/04/93 GTI release 5.1.4
  01/19/94 GTI release 5.2.C
  03/22/94 GTI release 5.2.0
  04/18/93 GTI release 6.0.A
  01/14/94 GTI release 6.0.B
  05/11/94 GTI release 6.0.C
  09/27/94 GTI release 6.0.0
  04/12/95 GTI release 6.0.1
  08/02/95 GTI release 6.1.0
  11/14/96 GTI release 6.5.0
  10/20/97 GTI release 7.0.0
  10/23/98 GTI release 7.5.0
  11/10/00 GTI release 7.6.0
  08/22/01 RWS release 8.0.0
  10/22/02 GTI release 8.1.0
  12/20/02 GTI release 8.5.0
  01/18/05 RWS release 9.0.1
DESCRIPTION
  This file contains structure	definitions  and  defined  constants  used  to
  interface with SQLBASE.  For a more  complete  definition  see  "SQLBASE:  C
  Programmer's Guide".
*/

#ifndef SQL
#define SQL

#ifdef __cplusplus
extern "C" {		/* Assume C declarations for C++ */
#endif	/* __cplusplus */

#ifndef SBSTDCALL
#ifdef __GNUC__
	#define SBSTDCALL  /* stdcall */
#else
	#define SBSTDCALL __stdcall
#endif
#endif

/* VERSION NUMBER */
#define   SQLVERS   90001		/* version number */
#define   SQLAPIV   00102		/* API version number since 3.6 */
/* DEFINED CONSTANTS */

/*-------------------------------------------------------------------------
  For 32-bit target systems, such as NetWare 386, Windows/NT, and OS/2 2.x,
  redefine some 16-bit-oriented constructs, such as far, near, pascal, etc.
  These redefinitions assume the compiler being used supports the flat
  memory model.
  ------------------------------------------------------------------------- */

# undef far
# undef near
# undef pascal
# undef cdecl

# define far
# define near
# define pascal
# define cdecl
# ifndef CDECL
#   define CDECL __cdecl
# endif
# define PTR *

/* FETCH RETURN CODES */
#define   FETRTRU   1			/* data truncated */
#define   FETRSIN   2			/* signed number fetched */
#define   FETRDNN   3			/* data is not numeric */
#define   FETRNOF   4			/* numeric overflow */
#define   FETRDTN   5			/* data type not supported */
#define   FETRDND   6			/* data is not in date format */
#define   FETRNUL   7			/* data is null */
/* DATABASE DATA TYPES */
#define   SQLDCHR   1			/* character data type */
#define   SQLDNUM   2			/* numeric data type */
#define   SQLDDAT   3			/* date-time data type */
#define   SQLDLON   4			/* long data type */
#define   SQLDDTE   5			/* date (only) data type */
#define   SQLDTIM   6			/* time (only) data type */
#define   SQLDHDL   7			/* sql handle data type */
#define   SQLDBOO   8			/* boolean data type */
#define   SQLDDTM   8			/* maximum data type */
/* PROGRAM DATA TYPES */
#define   SQLPBUF   1			/* buffer */
#define   SQLPSTR   2			/* string (zero terminated) */
#define   SQLPUCH   3			/* unsigned char */
#define   SQLPSCH   4			/* char */
#define   SQLPUIN   5			/* unsigned int */
#define   SQLPSIN   6			/* int */
#define   SQLPULO   7			/* unsigned long */
#define   SQLPSLO   8			/* long */
#define   SQLPFLT   9			/* float */
#define   SQLPDOU   10			/* double */
#define   SQLPNUM   11			/* SQLBASE internal numeric format */
#define   SQLPDAT   12			/* SQLBASE internal datetime format */
#define   SQLPUPD   13			/* unsigned packed decimal */
#define   SQLPSPD   14			/* signed packed decimal */
#define   SQLPDTE   15			/* date only format */
#define   SQLPTIM   16			/* time only format */
#define   SQLPUSH   17			/* unsigned short */
#define   SQLPSSH   18			/* short */
#define   SQLPNST   19			/* numeric string */
#define   SQLPNBU   20			/* numeric buffer */
#define   SQLPEBC   21			/* EBCDIC buffer format */
#define   SQLPLON   22			/* long text string */
#define   SQLPLBI   23			/* long binary buffer */
#define   SQLPLVR   24			/* char\long varchar > 254 */
#define   SQLPULL   25			/* unsigned long long */
#define   SQLPSLL   26			/* long long */
#define   SQLPDTM   26			/* data type maximum */
/* EXTERNAL DATA TYPES */
#define   SQLEINT   1			/* INTEGER */
#define   SQLESMA   2			/* SMALLINT */
#define   SQLEFLO   3			/* FLOAT */
#define   SQLECHR   4			/* CHAR */
#define   SQLEVAR   5			/* VARCHAR */
#define   SQLELON   6			/* LONGVAR */
#define   SQLEDEC   7			/* DECIMAL */
#define   SQLEDAT   8			/* DATE */
#define   SQLETIM   9			/* TIME */
#define   SQLETMS   10			/* TIMESTAMP */
#define   SQLEMON   11			/* MONEY */
#define   SQLEDOU   12			/* DOUBLE */
#define   SQLEGPH   13			/* GRAPHIC */
#define   SQLEVGP   14			/* VAR GRAPHIC */
#define   SQLELGP   15			/* LONG VAR GRAPHIC */
#define   SQLEBIN   16			/* BINARY */
#define   SQLEVBI   17			/* VAR BINARY */
#define   SQLELBI   18			/* LONG BINARY */
#define   SQLEBOO   19			/* BOOLEAN */
#define   SQLELCH   20			/* CHAR > 254 */
#define   SQLELVR   21			/* VARCHAR > 254 */

/* SET and GET PARAMETER TYPES */
/*	Global parameters
	------------------ */
#define   SQLPDDB   1			/* default database name */
#define   SQLPDUS   2			/* default user name */
#define   SQLPDPW   3			/* default password */
#define   SQLPGBC   4			/* global cursor value */
#define   SQLPLRD   5			/* local result set directory */
#define   SQLPDBM   6			/* db mode - see below */
#define   SQLPDBD   7			/* dbdir */
#define   SQLPCPG   8			/* code page information */
#define   SQLPNIE   9			/* null indicator error */
#define   SQLPCPT   10			/* connect pass thru to backend */
#define   SQLPTPD  11			/* temp dir */
#define   SQLPDTR  12			/* distributed transaction mode */
#define   SQLPPSW  15			/* server password */
#define   SQLPOOJ  16			/* oracle outer join */
#define   SQLPNPF  17			/* net prefix */
#define   SQLPNLG  18			/* net log */
#define   SQLPNCT  19			/* net check type */
#define   SQLPNCK  20			/* net check */
#define   SQLPLCK  22			/* locks */
#define   SQLPINT  25			/* interrupt */
#define   SQLPERF  27			/*  error file */
#define   SQLPDIO  28			/*  direct I/O */
#define   SQLPSWR  29			/*  default write */
#define   SQLPCTY  31			/*  country */
#define   SQLPCSD  32			/*  commit server daemon */
#define   SQLPCSR  33			/*  commit server */
#define   SQLPCCK  36			/*  client check */
#define   SQLPCTS  37			/*  characterset */
#define   SQLPCGR  38			/*  cache group */
#define   SQLPAIO  39			/*  asyncio */
#define   SQLPANL  40			/*  apply net log */
#define   SQLPGRS  41			/*  get reentracy state */
#define   SQLPSTF  42			/*  set SQLTrace flags */
#define   SQLPCLG  43			/*  set commit-order logging */

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

#define   SQLPHEP   1001		/* HEAP size for TSR executables */
#define   SQLPCAC   1002		/* CACHE size in Kbytes */
#define   SQLPBRN   1003		/* brand of database */
#define   SQLPVER   1004		/* release version (ex. "4.0.J") */
#define   SQLPPRF   1005		/* server profiling */
#define   SQLPPDB   1006		/* partitioned database */
#define   SQLPGCM   1007		/* group commit count */
#define   SQLPGCD   1008		/* group commit delay ticks */
#define   SQLPDLK   1009		/* number of deadlocks */
#define   SQLPCTL   1010		/* command time limit */
#define   SQLPAPT   1011		/* process timer activated */
#define   SQLPOSR   1012		/* OS sample rate */
#define   SQLPAWS   1013		/* OS Averaging window size */
#define   SQLPWKL   1014		/* Work Limit */
#define   SQLPWKA   1015		/* Work Space allocation */
#define   SQLPUSR   1016		/* Number of users */
#define   SQLPTMO   1017		/* time out */
#define   SQLPTSS   1018		/* thread stack size */
#define   SQLPTHM   1019		/* thread mode */
#define   SQLPSTC   1020		/* sortcache size in kilobytes */
#define   SQLPSIL   1021		/* silent mode */
#define   SQLPSPF   1022		/* server prefix */
#define   SQLPSVN   1024		/* server name */
#define   SQLPROM   1025		/* read-only mode (0 or 1) */
#define   SQLPSTA   1026		/* enable stats gathering */
#define   SQLPCSV   1027		/* commit server */
#define   SQLPTTP   1028		/* trace for 2PC */
#define   SQLPAJS   1029		/* ANSI join syntax */
#define   SQLPSDIR  1030		/* server module directory */
#define   SQLPSINI  1031		/* server ini file full path name */
#define   SQLPBLD   1032		/* server build number	*/

/*	Database specific parameters
	---------------------------- */

#define   SQLPDBN   2001		/* database name */
#define   SQLPDDR   2002		/* database directory */
#define   SQLPLDR   2003		/* log directory */
#define   SQLPLFS   2004		/* log file size in Kbytes */
#define   SQLPCTI   2005		/* checkpoint time interval in mins */
#define   SQLPLBM   2006		/* log backup mode? (0 or 1) */
#define   SQLPPLF   2007		/* Pre-allocate log files? (0 or 1) */
#define   SQLPTSL   2008		/* transaction span limit */
#define   SQLPROT   2009		/* read-only transactions (0, 1, 2) */
#define   SQLPHFS   2010		/* history file size in Kbytes */
#define   SQLPREC   2011		/* recovery */
#define   SQLPEXE   2012		/* name of executable */
#define   SQLPNLB   2013		/* next log to backup */
#define   SQLPROD   2014		/* read-only database (0 or 1) */
#define   SQLPEXS   2015		/* database file extension size */
#define   SQLPPAR   2016		/* partitioned database (0 or 1) */
#define   SQLPNDB   2017		/* NEWDB */
#define   SQLPLGF   2018		/* log file offset */
#define   SQLPDTL   2019		/* command timelimit */
#define   SQLPSMN   2020		/* show main db */
#define   SQLPCVC   2021		/* catalog version counter */
#define   SQLPDBS   2022		/* database block size */
#define   SQLPUED   2023		/* update external dictionary */
#define   SQLPCINI  2024		/* client ini file full path name */

/*	Cursor specific parameters
	-------------------------- */

#define   SQLPISO   3001		/* isolation level (SQLILRR etc..) */
#define   SQLPWTO   3002		/* lock wait timeout in seconds */
#define   SQLPPCX   3003		/* preserve context (0 or 1) */
#define   SQLPFRS   3004		/* front end result sets */
#define   SQLPLDV   3005		/* load version (ex. "3.6.22") */
#define   SQLPAUT   3006		/* autocommit */
#define   SQLPRTO   3007		/* rollback trans on lock timeout */
#define   SQLPSCR   3008		/* scroll mode (0 or 1) */
#define   SQLPRES   3009		/* restriction mode (0 or 1) */
#define   SQLPFT    3010		/* fetch through */
#define   SQLPNPB   3011		/* no pre-build in RL mode */
#define   SQLPPWD   3012		/* current password */
#define   SQLPDB2   3013		/* DB2 compatibility mode */
#define   SQLPREF   3014		/* referential integrity checking */
#define   SQLPBLK   3015		/* bulk-execute mode */
#define   SQLPOBL   3016		/* optimized bulk-execute mode */
#define   SQLPLFF   3017		/* LONG data allowed in FERS */
#define   SQLPDIS   3018		/* When to return Describe info */
#define   SQLPCMP   3019		/* Compress messages sent to server */
#define   SQLPCHS   3020		/* chained cmd has SELECT (0 or 1) */
#define   SQLPOPL   3021		/* optimizer level */
#define   SQLPRID   3022		/* ROWID */
#define   SQLPEMT   3023		/* Error Message Tokens */
#define   SQLPCLN   3024		/* client name */
#define   SQLPLSS   3025		/* last compiled SQL statement */
#define   SQLPEXP   3026		/* explain query plan */
#define   SQLPCXP   3027		/* cost of execution plan */
#define   SQLPOCL   3028		/* optimizercostlevel */
#define   SQLPTST   3029		 /* distributed transaction status */
#define   SQLP2PP   3030		/* 2-phase protocol (SQL2STD, etc.) */
/*	defined for Load/Unload parsed parameters - cursor specific */
#define   SQLPCLI   3031		/* ON CLIENT option */
#define   SQLPFNM   3032		/* load/unload file name */
#define   SQLPOVR   3033		/* file OVERWRITE flag */
#define   SQLPTFN   3034		/* A Temporary file name */
#define   SQLPTRC   3035		/* Trace stored procedures */
#define   SQLPTRF   3036		/* Tracefile for stored procedures */
#define   SQLPCTF   3037		/* control file flag */

#define   SQLPMID   3038		/* mail id */
#define   SQLPAID   3039		/* adapter id */
#define   SQLPNID   3040		/* network id */
#define   SQLPUID   3041		/* user application id */
#define   SQLPCIS   3042		/* client identification strings */
#define   SQLPIMB   3043		/* input message buffer size */
#define   SQLPOMB   3044		/* output message buffer size */
#define   SQLPWFC   3045		/* which fetchable command */
#define   SQLPRFE   3046		/* Return on First Error-bulk insert */
#define   SQLPCUN   3047		/* Current cursor user name */
#define   SQLPOFF   3048		/* Optimize First Fetch */
#define   SQLPUSC   3049		/* Use Specified Cursor for ref */
#define   SQLPPDG   3050		/* Plan Debug		*/

/*   Application Specific ie. applicable to all cursors that
     belong to the same application  (3700 -  3799) */

#define   SQLPCCB   3700		/* Connect Closure Behaviour */
#define   SQLPTTV   3701		/* Thread Timeout Value */

/*	Static attributes
	-------------------------- */