isqlext.h

关系型数据库 Postgresql 6.5.2

#define SQL_FN_STR_LCASE		0x00000040L
#define SQL_FN_STR_REPEAT		0x00000080L
#define SQL_FN_STR_REPLACE		0x00000100L
#define SQL_FN_STR_RIGHT		0x00000200L
#define SQL_FN_STR_RTRIM		0x00000400L
#define SQL_FN_STR_SUBSTRING		0x00000800L
#define SQL_FN_STR_UCASE		0x00001000L
#define SQL_FN_STR_ASCII		0x00002000L
#define SQL_FN_STR_CHAR			0x00004000L
#define SQL_FN_STR_DIFFERENCE		0x00008000L
#define SQL_FN_STR_LOCATE_2		0x00010000L
#define SQL_FN_STR_SOUNDEX		0x00020000L
#define SQL_FN_STR_SPACE		0x00040000L

/* introduced in ODBC 3.0 */
#define SQL_FN_STR_BIT_LENGTH		0x00080000L
#define SQL_FN_STR_CHAR_LENGTH		0x00100000L
#define SQL_FN_STR_CHARACTER_LENGTH	0x00200000L
#define SQL_FN_STR_OCTET_LENGTH		0x00400000L
#define SQL_FN_STR_POSITION		0x00800000L

/*
 * Subqueries. A SQLUINTEGER bitmask enumerating the predicates that support
 * subqueries.
 */
#define SQL_SQ_COMPARISON		0x00000001L
#define SQL_SQ_EXISTS			0x00000002L
#define SQL_SQ_IN			0x00000004L
#define SQL_SQ_QUANTIFIED		0x00000008L
#define SQL_SQ_CORRELATED_SUBQUERIES	0x00000010L

/*
 * System Functions. A SQLUINTEGER bitmask enumerating the scalar system
 * functions supported by the driver and associated data source.
 */
#define SQL_FN_SYS_USERNAME		0x00000001L 
#define SQL_FN_SYS_DBNAME		0x00000002L
#define SQL_FN_SYS_IFNULL		0x00000004L

/*
 * Time-Date add and diff intervals. A SQLUINTEGER bitmask enumerating the
 * timestamp intervals supported by the driver and associated data source
 *  for the TIMESTAMPADD and TIMESTAMPDIFF scalar function.
 */
#define SQL_FN_TSI_FRAC_SECOND		0x00000001L
#define SQL_FN_TSI_SECOND		0x00000002L
#define SQL_FN_TSI_MINUTE		0x00000004L
#define SQL_FN_TSI_HOUR			0x00000008L
#define SQL_FN_TSI_DAY			0x00000010L
#define SQL_FN_TSI_WEEK			0x00000020L
#define SQL_FN_TSI_MONTH		0x00000040L
#define SQL_FN_TSI_QUARTER		0x00000080L
#define SQL_FN_TSI_YEAR			0x00000100L

/*
 * Time/Date functions. A SQLUINTEGER bitmask enumerating the scalar date
 * and time functions supported by the driver and associated data source.
 */
#define SQL_FN_TD_NOW			0x00000001L
#define SQL_FN_TD_CURDATE		0x00000002L
#define SQL_FN_TD_DAYOFMONTH		0x00000004L
#define SQL_FN_TD_DAYOFWEEK		0x00000008L
#define SQL_FN_TD_DAYOFYEAR		0x00000010L
#define SQL_FN_TD_MONTH			0x00000020L
#define SQL_FN_TD_QUARTER		0x00000040L
#define SQL_FN_TD_WEEK			0x00000080L
#define SQL_FN_TD_YEAR			0x00000100L
#define SQL_FN_TD_CURTIME		0x00000200L
#define SQL_FN_TD_HOUR			0x00000400L
#define SQL_FN_TD_MINUTE		0x00000800L
#define SQL_FN_TD_SECOND		0x00001000L
#define SQL_FN_TD_TIMESTAMPADD		0x00002000L
#define SQL_FN_TD_TIMESTAMPDIFF		0x00004000L
#define SQL_FN_TD_DAYNAME		0x00008000L
#define SQL_FN_TD_MONTHNAME		0x00010000L

/* Added in ODBC 3.0 */
#define SQL_FN_TD_CURRENT_DATE		0x00020000L
#define SQL_FN_TD_CURRENT_TIME		0x00040000L
#define SQL_FN_TD_CURRENT_TIMESTAMP	0x00080000L
#define SQL_FN_TD_EXTRACT		0x00100000L

/*
 * Transaction Capable. A SQLUSMALLINT value describing the transaction
 * support in the driver or data source.
 */
#define SQL_TC_NONE		0x0000
#define SQL_TC_DML		0x0001
#define SQL_TC_ALL		0x0002
#define SQL_TC_DDL_COMMIT	0x0003
#define SQL_TC_DDL_IGNORE	0x0004

/*
 * Unions. A SQLUINTEGER bitmask enumerating the support for the UNION
 * clause.
 */
#define SQL_U_UNION		0x00000001L
#define SQL_U_UNION_ALL		0x00000002L


/* SQLStatistics: Type, Smallint */
#define SQL_TABLE_STAT		0
#define SQL_INDEX_CLUSTERED	1
#define SQL_INDEX_HASHED	2
#define SQL_INDEX_OTHER		3

/* SQLProcedures: Type: Smallint */
#define SQL_PT_UNKNOWN		0
#define SQL_PT_PROCEDURE	1
#define SQL_PT_FUNCTION		2

/* SQLSpecialColumns: PSEUDO_COLUMN: Smallint */
#define SQL_PC_UNKNOWN		0
#define SQL_PC_PSEUDO		1		
#define SQL_PC_NOT_PSEUDO	2

/* SQLSet/Get/StmtOptions: ASYNC_ENABLE. A SQLUINTEGER */
#define SQL_ASYNC_ENABLE_OFF		0UL
#define SQL_ASYNC_ENABLE_ON		1UL
#define SQL_ASYNC_ENABLE_DEFAULT	SQL_ASYNC_ENABLE_OFF

/*
 * SQLSet/GetStmtOptions: CONCURRENCY. A SQLUINTEGER. Note most of these
 * are above in the original isqlext.h code.
 */
#define SQL_CONCUR_DEFAULT	SQL_CONCUR_READ_ONLY

/* 
 * SQLSet/GetStmtOptions: CURSOR_SCROLLABLE. A SQLUINTEGER. Added in ODBC
 * 3.0.
 */
#define SQL_NONSCROLLABLE	0UL
#define SQL_SCROLLABLE		1UL
#define SQL_CURSOR_SCROLLABLE_DEFAULT	SQL_NONSCROLLABLE

/* 
 * SQLSet/GetStmtOptions: CURSOR_SENSITITY. A SQLUINTEGER. Added in ODBC
 * 3.0.
 */
#define SQL_UNSPECIFIED		0UL
#define SQL_INSENSITIVE		1UL
#define SQL_SENSITIVIE		2UL
#define SQL_CURSOR_SENSITIVITY_DEFAULT	SQL_UNSPECIFIED

/* 
 * SQLSet/GetStmtOptions: CURSOR_TYPE: A SQLUINTEGER value that specifies the
 * cursor type
 */
#define	SQL_CURSOR_FORWARD_ONLY		0UL
#define SQL_CURSOR_KEYSET_DRIVEN	1UL
#define SQL_CURSOR_DYNAMIC		2UL
#define SQL_CURSOR_STATIC		3UL
#define SQL_CURSOR_DEFAULT	SQL_CURSOR_FORWARD_ONLY 

/*
 * ENABLE_AUTO_IPD: A SQLUINTEGER, either SQL_TRUE or SQL_FALSE. Default
 * dependent on connection option SQL_ATTR_AUTO_IPD. Added in ODBC 3.0.
 */

/*
 * METADATA_ID: A SQLUINTEGER, either SQL_TRUE or SQL_FALSE. Added in
 * ODBC 3.0.
 */
#define SQL_ATTR_METADATA_ID_DEFAULT	SQL_FALSE

/*
 * SQLSet/GetStmtOptions: NOSCAN. A SQLUINTEGER value that indicates whether
 * the driver should scan SQL strings for escape sequences.
 */
#define SQL_NOSCAN_OFF		0UL
#define SQL_NOSCAN_ON		1UL
#define SQL_NOSCAN_DEFAULT	SQL_NOSCAN_OFF

/*
 * SQLSet/GetStmtOptions: PARAM_OPERATION: SQLUSMALLINT *. Added in ODBC 3.0
 *
 */
#define SQL_PARAM_PROCEED	0
#define SQL_PARAM_IGNORE	1

/*
 * SQLSet/GetStmtOptions: PARAM_STATUS: SQLUSMALLINT *. Added in ODBC 3.0
 *
*/
#define SQL_PARAM_SUCCESS		0
#define SQL_PARAM_SUCCESS_WITH_INFO	6
#define SQL_PARAM_ERROR			5
#define SQL_PARAM_UNUSED		7
#define SQL_PARAM_DIAG_UNAVAILABLE	1

/*
 * SQLSet/GetStmtOptions: RETRIEVE_DATA: SQLUINTEGER value.
 */
#define SQL_RD_OFF	0UL
#define SQL_RD_ON	1UL
#define SQL_RD_DEFAULT	SQL_RD_ON

/*
 * SQLSet/GetStmtOptions: BIND_TYPE: SQLUINTEGER. sets binding orientation.
 */
#define SQL_BIND_BY_COLUMN	0UL
#define SQL_BIND_TYPE_DEFAULT	SQL_BIND_BY_COLUMN

/*
 * SQLSet/GetStmtOptions: ROW_OPERATION: SQLUSMALLINT *. Added in ODBC 3.0
 */
#define SQL_ROW_PROCEED		0
#define SQL_ROW_IGNORE		1

/*
 *  SQL_ROWSET_SIZE
 */
#define SQL_ROWSET_SIZE_DEFAULT 	1UL

/*
 *  SQL_KEYSET_SIZE
 */
#define SQL_KEYSET_SIZE_DEFAULT		0UL

/*
 * SQLSet/GetStmtOptions: SIMULATE_CURSOR: SQLUINTEGER value that specifies
 * whether drivers that simulate positioned update and delete statements
 * guarantee that such statements affect only a single row.
 */
#define SQL_SC_NON_UNIQUE	0UL
#define SQL_SC_TRY_UNIQUE	1UL
#define SQL_SC_UNIQUE		2UL

/*
 * SQLSet/GetStmtOptions: USE_BOOKMARKS: SQLUINTEGER value that specifies
 * whether an application will use bookmarks with a cursor.
 */
#define SQL_UB_OFF		0UL
#define SQL_UB_ON		1UL
#define SQL_UB_FIXED		SQL_UB_ON	/* Deprecated in ODBC 3.0 */
#define SQL_UB_VARIABLE		2UL	/* Added in ODBC 3.0 */
#define SQL_UB_DEFAULT		SQL_UB_OFF

/* Deprecated */
#define SQL_DATABASE_NAME		16 
#define SQL_FD_FETCH_PREV		SQL_FD_FETCH_PRIOR 
#define SQL_FETCH_PREV			SQL_FETCH_PRIOR 
#define SQL_CONCUR_TIMESTAMP		SQL_CONCUR_ROWVER 
#define SQL_SCCO_OPT_TIMESTAMP		SQL_SCCO_OPT_ROWVER 
#define SQL_CC_DELETE			SQL_CB_DELETE 
#define SQL_CR_DELETE			SQL_CB_DELETE 
#define SQL_CC_CLOSE			SQL_CB_CLOSE 
#define SQL_CR_CLOSE			SQL_CB_CLOSE 
#define SQL_CC_PRESERVE			SQL_CB_PRESERVE 
#define SQL_CR_PRESERVE			SQL_CB_PRESERVE 
#define SQL_FETCH_RESUME                7     
#define SQL_SCROLL_FORWARD_ONLY         0L
#define SQL_SCROLL_KEYSET_DRIVEN        (-1L)
#define SQL_SCROLL_DYNAMIC              (-2L)
#define SQL_SCROLL_STATIC               (-3L)
 
/*
 *  ODBC keywords
 */
#define SQL_ODBC_KEYWORDS \
"ABSOLUTE,ACTION,ADA,ADD,ALL,ALLOCATE,ALTER,AND,ANY,ARE,AS,"\
"ASC,ASSERTION,AT,AUTHORIZATION,AVG,"\
"BEGIN,BETWEEN,BIT,BIT_LENGTH,BOTH,BY,CASCADE,CASCADED,CASE,CAST,CATALOG,"\
"CHAR,CHAR_LENGTH,CHARACTER,CHARACTER_LENGTH,CHECK,CLOSE,COALESCE,"\
"COBOL,COLLATE,COLLATION,COLUMN,COMMIT,CONNECT,CONNECTION,CONSTRAINT,"\
"CONSTRAINTS,CONTINUE,CONVERT,CORRESPONDING,COUNT,CREATE,CROSS,CURRENT,"\
"CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_USER,CURSOR,"\
"DATE,DAY,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE,"\
"DEFERRED,DELETE,DESC,DESCRIBE,DESCRIPTOR,DIAGNOSTICS,DISCONNECT,"\
"DISTINCT,DOMAIN,DOUBLE,DROP,"\
"ELSE,END,END-EXEC,ESCAPE,EXCEPT,EXCEPTION,EXEC,EXECUTE,"\
"EXISTS,EXTERNAL,EXTRACT,"\
"FALSE,FETCH,FIRST,FLOAT,FOR,FOREIGN,FORTRAN,FOUND,FROM,FULL,"\
"GET,GLOBAL,GO,GOTO,GRANT,GROUP,HAVING,HOUR,"\
"IDENTITY,IMMEDIATE,IN,INCLUDE,INDEX,INDICATOR,INITIALLY,INNER,"\
"INPUT,INSENSITIVE,INSERT,INTEGER,INTERSECT,INTERVAL,INTO,IS,ISOLATION,"\
"JOIN,KEY,LANGUAGE,LAST,LEADING,LEFT,LEVEL,LIKE,LOCAL,LOWER,"\
"MATCH,MAX,MIN,MINUTE,MODULE,MONTH,MUMPS,"\
"NAMES,NATIONAL,NATURAL,NCHAR,NEXT,NO,NONE,NOT,NULL,NULLIF,NUMERIC,"\
"OCTET_LENGTH,OF,ON,ONLY,OPEN,OPTION,OR,ORDER,OUTER,OUTPUT,OVERLAPS,"\
"PAD,PARTIAL,PASCAL,PLI,POSITION,PRECISION,PREPARE,PRESERVE,"\
"PRIMARY,PRIOR,PRIVILEGES,PROCEDURE,PUBLIC,"\
"REFERENCES,RELATIVE,RESTRICT,REVOKE,RIGHT,ROLLBACK,ROWS,"\
"SCHEMA,SCROLL,SECOND,SECTION,SELECT,SEQUENCE,SESSION,SESSION_USER,SET,SIZE,"\
"SMALLINT,SOME,SPACE,SQL,SQLCA,SQLCODE,SQLERROR,SQLSTATE,SQLWARNING,"\
"SUBSTRING,SUM,SYSTEM_USER,"\
"TABLE,TEMPORARY,THEN,TIME,TIMESTAMP,TIMEZONE_HOUR,TIMEZONE_MINUTE,"\
"TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATION,TRIM,TRUE,"\
"UNION,UNIQUE,UNKNOWN,UPDATE,UPPER,USAGE,USER,USING,"\
"VALUE,,VARCHAR,VARYING,VIEW,WHEN,WHENEVER,WHERE,WITH,WORK,YEAR"

# ifdef __cplusplus
	extern  "C" {
# endif

RETCODE SQL_API SQLSetConnectOption (HDBC, UWORD, UDWORD);
RETCODE SQL_API SQLNumResultCols ( HSTMT, SWORD FAR* );

/*
 *   function prototypes previously missing from isqlext.h
 */
RETCODE SQL_API SQLColumns (HSTMT hstmt, 
	UCHAR FAR * szTableQualifier,
	SWORD cbTableQualifier,
	UCHAR FAR * szTableOwner,
	SWORD cbTableOwner,
	UCHAR FAR * szTableName,
	SWORD cbTableName,
	UCHAR FAR * szColumnName,
	SWORD cbColumnName);

RETCODE SQL_API SQLDriverConnect (HDBC hdbc,
	HWND hwnd,
	UCHAR FAR * szConnStrIn,
	SWORD cbConnStrIn,
	UCHAR FAR * szConnStrOut,
	SWORD cbConnStrOutMax,
	SWORD FAR * pcbConnStrOut,
	UWORD fDriverCompletion);

RETCODE SQL_API SQLGetConnectOption (HDBC hdbc,
	UWORD fOption,
	PTR pvParam);

RETCODE SQL_API SQLGetData (HSTMT hstmt,
	UWORD icol,
	SWORD fCType,
	PTR rgbValue,
	SDWORD cbValueMax,
	SDWORD FAR * pcbValue);

RETCODE SQL_API SQLGetFunctions (HDBC hdbc,
	UWORD fFunction,
	UWORD FAR * pfExists);

RETCODE SQL_API SQLGetInfo (HDBC hdbc,
	UWORD fInfoType,
	PTR rgbInfoValue,
	SWORD cbInfoValueMax,
	SWORD FAR * pcbInfoValue);

RETCODE SQL_API SQLGetStmtOption (HSTMT hstmt,
	UWORD fOption,
	PTR pvParam);

RETCODE SQL_API SQLGetTypeInfo (HSTMT hstmt,
	SWORD fSqlType);

RETCODE SQL_API SQLParamData (HSTMT hstmt,
	PTR FAR * prgbValue);

RETCODE SQL_API SQLPutData (HSTMT hstmt,
	PTR rgbValue,
	SDWORD cbValue);

RETCODE SQL_API SQLSetStmtOption (HSTMT hstmt,
	UWORD fOption,
	UDWORD vParam);

RETCODE SQL_API SQLSpecialColumns (HSTMT hstmt,
	UWORD fColType,
	UCHAR FAR * szTableQualifier,
	SWORD cbTableQualifier,
	UCHAR FAR * szTableOwner,
	SWORD cbTableOwner,
	UCHAR FAR * szTableName,
	SWORD cbTableName,
	UWORD fScope,
	UWORD fNullable);

RETCODE SQL_API SQLStatistics (HSTMT hstmt,
	UCHAR FAR * szTableQualifier,
	SWORD cbTableQualifier,
	UCHAR FAR * szTableOwner,
	SWORD cbTableOwner,
	UCHAR FAR * szTableName,
	SWORD cbTableName,
	UWORD fUnique,
	UWORD fAccuracy);

RETCODE SQL_API SQLTables (HSTMT hstmt,
	UCHAR FAR * szTableQualifier,
	SWORD cbTableQualifier,
	UCHAR FAR * szTableOwner,
	SWORD cbTableOwner,
	UCHAR FAR * szTableName,
	SWORD cbTableName,
	UCHAR FAR * szTableType,
	SWORD cbTableType);

RETCODE SQL_API SQLBrowseConnect (HDBC hdbc,
	UCHAR FAR * szConnStrIn,
	SWORD cbConnStrIn,
	UCHAR FAR * szConnStrOut, 
	SWORD cbConnStrOutMax,
	SWORD FAR * pcbConnStrOut);

RETCODE SQL_API SQLColumnPrivileges (HSTMT hstmt,
	UCHAR FAR * szTableQualifier,
	SWORD cbTableQualifier,
	UCHAR FAR * szTableOwner,
	SWORD cbTableOwner,
	UCHAR FAR * szTableName,
	SWORD cbTableName,
	UCHAR FAR * szColumnName,
	SWORD cbColumnName);

RETCODE SQL_API SQLDescribeParam (HSTMT hstmt,
	UWORD ipar,
	SWORD FAR * pfSqlType,
	UDWORD FAR * pcbColDef,
	SWORD FAR * pibScale,
	SWORD FAR * pfNullable);

RETCODE SQL_API SQLExtendedFetch (HSTMT hstmt,
	UWORD fFetchType,
	SDWORD irow,
	UDWORD FAR * pcrow,
	UWORD FAR * rgfRowStatus);

RETCODE SQL_API SQLForeignKeys (HSTMT hstmt,
	UCHAR FAR * szPkTableQualifier,
	SWORD cbPkTableQualifier,
	UCHAR FAR * szPkTableOwner,
	SWORD cbPkTableOwner,
	UCHAR FAR * szPkTableName,
	SWORD cbPkTableName,
	UCHAR FAR * szFkTableQualifier,
	SWORD cbFkTableQualifier,
	UCHAR FAR * szFkTableOwner,
	SWORD cbFkTableOwner,
	UCHAR FAR * szFkTableName,
	SWORD cbFkTableName);

RETCODE SQL_API SQLMoreResults (HSTMT hstmt);

RETCODE SQL_API SQLNativeSql (HDBC hdbc,
	UCHAR FAR * szSqlStrIn,
	SDWORD cbSqlStrIn,
	UCHAR FAR * szSqlStr,
	SDWORD cbSqlStrMax,
	SDWORD FAR * pcbSqlStr);

RETCODE SQL_API SQLNumParams (HSTMT hstmt,
	SWORD FAR * pcpar);

RETCODE SQL_API SQLParamOptions (HSTMT hstmt,
	UDWORD crow,
	UDWORD FAR * pirow);

RETCODE SQL_API SQLPrimaryKeys (HSTMT hstmt,
	UCHAR FAR * szTableQualifier,
	SWORD cbTableQualifier,
	UCHAR FAR * szTableOwner,
	SWORD cbTableOwner,
	UCHAR FAR * szTableName,
	SWORD cbTableName);

RETCODE SQL_API SQLProcedureColumns (HSTMT hstmt,
	UCHAR FAR * szProcQualifier,
	SWORD cbProcQualifier,
	UCHAR FAR * szProcOwner,
	SWORD cbProcOwner,
	UCHAR FAR * szProcName,
	SWORD cbProcName,
	UCHAR FAR * szColumnName,
	SWORD cbColumnName);

RETCODE SQL_API SQLProcedures (HSTMT hstmt,
	UCHAR FAR * szProcQualifier,
	SWORD cbProcQualifier,
	UCHAR FAR * szProcOwner,
	SWORD cbProcOwner,
	UCHAR FAR * szProcName,
	SWORD cbProcName);

RETCODE SQL_API SQLSetPos (HSTMT hstmt,
	UWORD irow,
	UWORD fOption,
	UWORD fLock);

RETCODE SQL_API SQLTablePrivileges (HSTMT hstmt,
	UCHAR FAR * szTableQualifier,
	SWORD cbTableQualifier,
	UCHAR FAR * szTableOwner,
	SWORD cbTableOwner,
	UCHAR FAR * szTableName,
	SWORD cbTableName);

RETCODE SQL_API SQLBindParameter (HSTMT hstmt,
	UWORD ipar,
	SWORD fParamType,
	SWORD fCType,
	SWORD fSqlType,
	UDWORD cbColDef,
	SWORD ibScale,
	PTR rgbValue,
	SDWORD cbValueMax,
	SDWORD FAR * pcbValue);

RETCODE SQL_API SQLSetScrollOptions (HSTMT hstmt,
	UWORD fConcurrency,
	SDWORD crowKeyset,
	UWORD crowRowset);


# ifdef __cplusplus
	}
# endif

#endif