sqlcli.h

关系型数据库 Postgresql 6.5.2

#define SQL_DEFAULT_TRANSACTION_ISOLATION  26
#define SQL_IDENTIFIER_CASE                28
#define SQL_MAXIMUM_COLUMN_NAME_LENGTH     30
#define SQL_MAXIMUM_CURSOR_NAME_LENGTH     31
#define SQL_MAXIMUM_SCHEMA_NAME_LENGTH     32
#define SQL_MAXIMUM_CATALOG_NAME_LENGTH    34
#define SQL_MAXIMUM_TABLE_NAME_LENGTH      35
#define SQL_SCROLL_CONCURRENCY             43
#define SQL_TRANSACTION_CAPABLE            46
#define SQL_USER_NAME                      47
#define SQL_TRANSACTION_ISOLATION_OPTION   72
#define SQL_INTEGRITY                      73
#define SQL_GETDATA_EXTENSIONS             81
#define SQL_NULL_COLLATION                 85
#define SQL_ALTER_TABLE                    86
#define SQL_ORDER_BY_COLUMNS_IN_SELECT     90
#define SQL_SPECIAL_CHARACTERS             94
#define SQL_MAXIMUM_COLUMNS_IN_GROUP_BY    97
#define SQL_MAXIMUM_COLUMNS_IN_ORDER_BY    99
#define SQL_MAXIMUM_COLUMNS_IN_SELECT     100
#define SQL_MAXIMUM_COLUMNS_IN_TABLE      101
#define SQL_MAXIMUM_STATEMENT_LENGTH      105
#define SQL_MAXIMUM_TABLES_IN_SELECT      106
#define SQL_MAXIMUM_USER_NAME_LENGTH      107
#define SQL_OUTER_JOIN_CAPABILITIES       115
#define SQL_CURSOR_SENSITIVITY          10001
#define SQL_DESCRIBE_PARAMETER          10002
#define SQL_CATALOG_NAME                10003
#define SQL_COLLATING_SEQUENCE          10004
#define SQL_MAXIMUM_IDENTIFIER_LENGTH   10005

/* S-resource attribute values for cursor sensitivity */
#define SQL_UNSPECIFIED           0x00000000L
#define SQL_INSENSITIVE           0x00000001L

/* null handle used when allocating HENV */
#define SQL_NULL_HANDLE                    0L

/* SQL_ALTER_TABLE bitmasks */
#define SQL_AT_ADD_COLUMN         0x00000001L
#define SQL_AT_DROP_COLUMN        0x00000002L
#define SQL_AT_ALTER_COLUMN       0x00000004L
#define SQL_AT_ADD_CONSTRAINT     0x00000008L
#define SQL_AT_DROP_CONSTRAINT    0x00000010L

/* SQL_CURSOR_COMMIT_BEHAVIOR values */
#define SQL_CB_DELETE                       0
#define SQL_CB_CLOSE                        1
#define SQL_CB_PRESERVE                     2

/* SQL_FETCH_DIRECTION bitmasks */
#define SQL_FD_FETCH_NEXT         0x00000001L
#define SQL_FD_FETCH_FIRST        0x00000002L
#define SQL_FD_FETCH_LAST         0x00000004L
#define SQL_FD_FETCH_PRIOR        0x00000008L
#define SQL_FD_FETCH_ABSOLUTE     0x00000010L
#define SQL_FD_FETCH_RELATIVE     0x00000020L

/* SQL_GETDATA_EXTENSIONS bitmasks */
#define SQL_GD_ANY_COLUMN         0x00000001L
#define SQL_FD_ANY_ORDER          0x00000002L

/* SQL_IDENTIFIER_CASE values */
#define SQL_IC_UPPER                        1
#define SQL_IC_LOWER                        2
#define SQL_IC_SENSITIVE                    3
#define SQL_IC_MIXED                        4

/* SQL_IDENTIFIER_CASE values */
#define SQL_NC_HIGH                         1
#define SQL_NC_LOW                          2

/* SQL_OUTER_JOIN_CAPABILITIES bitmasks */
#define SQL_OUTER_JOIN_LEFT                   0x00000001L
#define SQL_OUTER_JOIN_RIGHT                  0x00000002L
#define SQL_OUTER_JOIN_FULL                   0x00000004L
#define SQL_OUTER_JOIN_NESTED                 0x00000008L
#define SQL_OUTER_JOIN_NOT_ORDERED            0x00000010L
#define SQL_OUTER_JOIN_INNER                  0x00000020L
#define SQL_OUTER_JOIN_ALL_COMPARISION_OPS    0x00000040L

/* SQL_SCROLL_CONCURRENCY bitmasks */
#define SQL_SCCO_READ_ONLY                    0x00000001L
#define SQL_SCCO_LOCK                         0x00000002L
#define SQL_SCCO_OPT_ROWVER                   0x00000004L
#define SQL_SCCO_OPT_VALUES                   0x00000008L

/* SQL_IDENTIFIER_CASE values */
#define SQL_TC_NONE                         0
#define SQL_TC_DML                          1
#define SQL_TC_ALL                          2
#define SQL_TC_DDL_COMMIT                   3
#define SQL_TC_DDL_IGNORE                   4

/* SQL_TRANSACTION_ISOLATION bitmasks */
#define SQL_TRANSACTION_READ_UNCOMMITTED      0x00000001L
#define SQL_TRANSACTION_READ_COMMITTED        0x00000002L
#define SQL_TRANSACTION_READ_REPEATABLE_READ  0x00000004L
#define SQL_TRANSACTION_READ_SERIALIZABLE     0x00000008L



#define SQL_TRANSACTION_READ_UNCOMMITTED    0x00000001L
#define SQL_TRANSACTION_READ_UNCOMMITTED    0x00000001L
#define SQL_FD_FETCH_NEXT         0x00000001L

/* CLI function signatures */

SQLRETURN  SQLAllocConnect(SQLHENV EnvironmentHandle,
			   SQLHDBC *ConnectionHandle);

SQLRETURN  SQLAllocEnv(SQLHENV *EnvironmentHandle);

SQLRETURN  SQLAllocHandle(SQLSMALLINT HandleType,
			  SQLINTEGER InputHandle,
			  SQLINTEGER *OutputHandle);

SQLRETURN  SQLAllocStmt(SQLHDBC ConnectionHandle,
                         SQLSTMT *StatementHandle);

SQLRETURN  SQLBindCol(SQLHSTMT StatementHandle,
		      SQLSMALLINT ColumnNumber,
		      SQLSMALLINT BufferType,
		      SQLPOINTER Data,
		      SQLINTEGER BufferLength,
		      SQLINTEGER *DataLength);

SQLRETURN  SQLBindParam(SQLHSTMT StatementHandle,
			SQLSMALLINT ParamNumber,
			SQLSMALLINT BufferType,
			SQLSMALLINT ParamType,
			SQLINTEGER ParamLength,
			SQLSMALLINT Scale,
			SQLPOINTER Data,
			SQLINTEGER *DataLength);

SQLRETURN  SQLCancel(SQLHSTMT StatementHandle);

SQLRETURN  SQLCloseCursor(SQLHSTMT StatementHandle);

SQLRETURN  SQLColAttribute(SQLHSTMT StatementHandle,
			   SQLSMALLINT ColumnNumber,
			   SQLSMALLINT FieldIdentifier,
			   SQLCHAR *CharacterAttribute,
			   SQLINTEGER BufferLength,
			   SQLINTEGER *AttributetLength,
			   SQLINTEGER *NumericAttribute);

SQLRETURN  SQLConnect(SQLHDBC ConnectionHandle,
		      SQLCHAR *ServerName,
		      SQLSMALLINT NameLength1,
		      SQLCHAR *UserName,
		      SQLSMALLINT NameLength2,
		      SQLCHAR *Authentication,
		      SQLSMALLINT NameLength3);

SQLRETURN  SQLCopyDesc(SQLHDESC SourceDescHandle,
		       SQLHDESC TargetDescHandle);

SQLRETURN  SQLDataSources(SQLHENV EnvironmentHandle,
			  SQLSMALLINT Direction,
			  SQLCHAR *ServerName,
			  SQLSMALLINT BufferLength1,
			  SQLSMALLINT *NameLength1,
			  SQLCHAR *Description,
			  SQLSMALLINT BufferLength2,
			  SQLSMALLINT *NameLength2);

SQLRETURN  SQLDescribeCol(SQLHSTMT StatementHandle,
			  SQLSMALLINT ColumnNumber,
			  SQLCHAR *ColumnName,
			  SQLSMALLINT BufferLength,
			  SQLSMALLINT *ColumnNameLength,
			  SQLSMALLINT *ColumnType,
			  SQLINTEGER *ColumnLength,
			  SQLSMALLINT *ColumnScale,
			  SQLSMALLINT *Nullable);

SQLRETURN  SQLDisconnect(SQLHDBC ConnectionHandle);

SQLRETURN  SQLEndTran(SQLSMALLINT HandleType,
		      SQLHENV Handle,
		      SQLSMALLINT CompletionType);

SQLRETURN  SQLError(SQLHENV EnvironmentHandle,
		    SQLHDBC ConnectionHandle,
		    SQLSTMT StatementHandle,
		    SQLCHAR *Sqlstate,
		    SQLINTEGER *NativeError,
		    SQLCHAR *MessageText,
		    SQLINTEGER BufferLength,
		    SQLINTEGER *TextLength);

SQLRETURN  SQLExecDirect(SQLHSTMT StatementHandle,
                         SQLCHAR *StatementText,
			 SQLSMALLINT StringLength);

SQLRETURN  SQLExecute(SQLHSTMT StatementHandle);

SQLRETURN  SQLFetch(SQLHSTMT StatementHandle);

SQLRETURN  SQLFetchScroll(SQLHSTMT StatementHandle,
			  SQLSMALLINT FetchOrientation,
			  SQLINTEGER FetchOffset);

SQLRETURN  SQLFreeConnect(SQLHDBC ConnectionHandle);

SQLRETURN  SQLFreeEnv(SQLHENV EnvironmentHandle);

SQLRETURN  SQLFreeHandle(SQLSMALLINT HandleType,
                         SQLINTEGER Handle);

SQLRETURN  SQLFreeStmt(SQLHSTMT StatementHandle);

SQLRETURN  SQLGetConnectAttr(SQLHDBC ConnectionHandle,
			     SQLINTEGER Attribute,
			     SQLPOINTER Value,
			     SQLINTEGER BufferLength,
			     SQLINTEGER *StringLength);

SQLRETURN  SQLGetCursorName(SQLHSTMT StatementHandle,
			    SQLCHAR *CursorName,
			    SQLSMALLINT BufferLength,
			    SQLSMALLINT *NameLength);

SQLRETURN  SQLGetData(SQLHSTMT StatementHandle,
		      SQLSMALLINT ColumnNumber,
		      SQLSMALLINT TargetType,
		      SQLPOINTER TargetValue,
		      SQLINTEGER BufferLength,
		      SQLINTEGER *IndicatorValue);

SQLRETURN  SQLGetDescField(SQLHDESC DescriptorHandle,
			   SQLSMALLINT RecordNumber,
			   SQLSMALLINT FieldIdentifier,
			   SQLPOINTER Value,
			   SQLINTEGER BufferLength,
			   SQLINTEGER *StringLength);

SQLRETURN  SQLGetDescRec(SQLHDESC DescriptorHandle,
                         SQLSMALLINT RecordNumber,
			 SQLCHAR *Name,
                         SQLSMALLINT BufferLength,
			 SQLSMALLINT *StringLength,
                         SQLSMALLINT *Type,
			 SQLSMALLINT *SubType,
                         SQLINTEGER *Length,
			 SQLSMALLINT *Precision,
                         SQLSMALLINT *Scale,
			 SQLSMALLINT *Nullable);

SQLRETURN  SQLGetDiagField(SQLSMALLINT HandleType,
			   SQLINTEGER Handle,
			   SQLSMALLINT RecordNumber,
			   SQLSMALLINT DiagIdentifier,
			   SQLPOINTER DiagInfo,
			   SQLSMALLINT BufferLength,
			   SQLSMALLINT *StringLength);


SQLRETURN  SQLGetDiagRec(SQLSMALLINT HandleType,
			 SQLINTEGER Handle,
                         SQLSMALLINT RecordNumber,
			 SQLCHAR *Sqlstate,
                         SQLINTEGER *NativeError,
			 SQLCHAR *MessageText,
                         SQLSMALLINT BufferLength,
			 SQLSMALLINT *StringLength);

SQLRETURN  SQLGetEnvAttr(SQLHENV EnvironmentHandle,
                         SQLINTEGER Attribute,
			 SQLPOINTER Value,
                         SQLINTEGER BufferLength,
			 SQLINTEGER *StringLength);

SQLRETURN  SQLGetFunctions(SQLHDBC ConnectionHandle,
			   SQLSMALLINT FunctionId,
			   SQLSMALLINT *Supported);

SQLRETURN  SQLGetInfo(SQLHDBC ConnectionHandle,
		      SQLSMALLINT InfoType,
		      SQLPOINTER InfoValue,
		      SQLSMALLINT BufferLength,
		      SQLSMALLINT *StringLength);

SQLRETURN  SQLGetStmtAttr(SQLHSTMT StatementHandle,
			  SQLINTEGER Attribute,
			  SQLPOINTER Value,
			  SQLINTEGER BufferLength,
			  SQLINTEGER *StringLength);

SQLRETURN  SQLGetTypeInfo(SQLHSTMT StatementHandle,
			  SQLSMALLINT DataType);

SQLRETURN  SQLNumResultCols(SQLHSTMT StatementHandle,
			    SQLINTEGER *ColumnCount);

SQLRETURN  SQLParamData(SQLHSTMT StatementHandle,
			SQLPOINTER *Value);

SQLRETURN  SQLPrepare(SQLHSTMT StatementHandle,
		      SQLCHAR *StatementText,
		      SQLSMALLINT StringLength);


SQLRETURN  SQLPutData(SQLHSTMT StatementHandle,
		      SQLPOINTER Data,
		      SQLINTEGER StringLength);

SQLRETURN  SQLRowCount(SQLHSTMT StatementHandle,
		       SQLINTEGER *RowCount);

SQLRETURN  SQLSetConnectAttr(SQLHDBC ConnectionHandle,
			     SQLINTEGER AttributeCursorName,
			     SQLPOINTER Value,
			     SQLINTEGER StringLength);

SQLRETURN  SQLSetCursorName(SQLHSTMT StatementHandle,
			    SQLCHAR *CursorName,
			    SQLSMALLINT NameLength);

SQLRETURN  SQLSetDescField(SQLHDESC DescriptorHandle,
			   SQLSMALLINT RecordNumber,
			   SQLSMALLINT FieldIdentifier,
			   SQLPOINTER Value, SQLINTEGER BufferLength);

SQLRETURN  SQLSetDescRec(SQLHDESC DescriptorHandle,
                         SQLSMALLINT RecordNumber,
			 SQLSMALLINT Type,
                         SQLSMALLINT SubType,
			 SQLINTEGER Length,
                         SQLSMALLINT Precision,
			 SQLSMALLINT Scale,
                         SQLPOINTER Data,
			 SQLINTEGER *StringLength,
                         SQLSMALLINT *Indicator);

SQLRETURN  SQLSetEnvAttr(SQLHENV EnvironmentHandle,
                         SQLINTEGER Attribute,
			 SQLPOINTER Value,
                         SQLINTEGER StringLength);

SQLRETURN  SQLSetStmtAttr(SQLHSTMT StatementHandle,
			  SQLINTEGER Attribute,
			  SQLPOINTER Value,
			  SQLINTEGER StringLength);

/* These are in SQL3 from August 1994
 * but not in Date and Darwen, 1997
 * - Thomas Lockhart 1999-06-17

SQLRETURN  SQLLanguages(SQLHSTMT StatementHandle);

SQLRETURN  SQLReleaseEnv(SQLHENV EnvironmentHandle);

SQLRETURN  SQLScrollFetch(SQLHSTMT StatementHandle,
			  SQLINTEGER FetchOrientation,
			  SQLINTEGER FetchOffset);
*/