infxcli.h

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

/*****************************************************************
** INFXCLI.H - This is the the main include for Informix-CLI
**             applications.
**
** Preconditions:  
**                for Windows environment:
**                        #include "windows.h"
**
*********************************************************************/

#ifndef __INFXCLI_H
#define __INFXCLI_H

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

/*
**     include sql.h and sqlext.h
*/
#ifdef _WINDOWS_
#include "sql.h"
#include "sqlext.h"
#else
#include "infxsql.h"
#endif /*_WINDOWS_*/
/* For extended errors */

#define SQL_DIAG_ISAM_ERROR        13
#define SQL_DIAG_XA_ERROR          14


/* Ajay added till here */
/* START -- Q+E Software's SQLSetStmtOption extensions (1040 to 1139) */
/* defines here for backwards compatibility */

#define SQL_STMTOPT_START                       1040

/* Get the rowid for the last row inserted */
#define SQL_GET_ROWID                           (SQL_STMTOPT_START+8)

/* Get the value for the serial column in the last row inserted */
#define SQL_GET_SERIAL_VALUE                    (SQL_STMTOPT_START+9)

/* END -- Q+E Software's SQLSetStmtOption extensions (1040 to 1139) */

/*
**    Informix extensions
*/

/* Informix Column Attributes Flags Definitions */
#define FDNULLABLE      0x0001          /* null allowed in field */
#define FDDISTINCT      0x0002          /* distinct of all */
#define FDDISTLVARCHAR  0x0004          /* distinct of SQLLVARCHAR */
#define FDDISTBOOLEAN   0x0008          /* distinct of SQLBOOL */
#define FDDISTSIMP      0x0010          /* distinct of simple type */
#define FDCSTTYPE       0x0020          /* constructor type */
#define FDNAMED         0x0040          /* named row type */

#define ISNULLABLE( flags )       ( flags & FDNULLABLE ? 1 : 0)
#define ISDISTINCT( flags )       ( flags & FDDISTINCT ? 1 : 0)

/* Informix Type Estensions */
#define SQL_INFX_UDT_FIXED                      -100
#define SQL_INFX_UDT_VARYING                    -101
#define SQL_INFX_UDT_BLOB                       -102
#define SQL_INFX_UDT_CLOB                       -103
#define SQL_INFX_UDT_LVARCHAR                   -104
#define SQL_INFX_RC_ROW                         -105
#define SQL_INFX_RC_COLLECTION                  -106
#define SQL_INFX_RC_LIST                        -107
#define SQL_INFX_RC_SET                         -108
#define SQL_INFX_RC_MULTISET                    -109
#define SQL_INFX_UNSUPPORTED                    -110

typedef void * HINFX_RC;		/* row & collection handle */

/* Informix Connect Attributes Extensions */
#define SQL_OPT_LONGID                           2251
#define SQL_INFX_ATTR_LONGID                     SQL_OPT_LONGID
#define SQL_INFX_ATTR_LEAVE_TRAILING_SPACES      2252
#define SQL_INFX_ATTR_DEFAULT_UDT_FETCH_TYPE     2253
#define SQL_INFX_ATTR_ENABLE_SCROLL_CURSORS      2254
#define SQL_ENABLE_INSERT_CURSOR                 2255
#define SQL_INFX_ATTR_ENABLE_INSERT_CURSORS      SQL_ENABLE_INSERT_CURSOR
#define SQL_INFX_ATTR_OPTIMIZE_AUTOCOMMIT        2256
#define SQL_INFX_ATTR_ODBC_TYPES_ONLY            2257
#define SQL_INFX_ATTR_FETCH_BUFFER_SIZE          2258
#define SQL_INFX_ATTR_OPTOFC                     2259
#define SQL_INFX_ATTR_OPTMSG                     2260
#define SQL_INFX_ATTR_REPORT_KEYSET_CURSORS      2261
#define SQL_INFX_ATTR_LO_AUTOMATIC               2262
#define SQL_INFX_ATTR_AUTO_FREE                  2263
#define SQL_INFX_ATTR_DEFERRED_PREPARE           2265


/* Informix Descriptor Extensions */
#define SQL_INFX_ATTR_FLAGS                      1900 /* UDWORD */
#define SQL_INFX_ATTR_EXTENDED_TYPE_CODE         1901 /* UDWORD */
#define SQL_INFX_ATTR_EXTENDED_TYPE_NAME         1902 /* UCHAR ptr */
#define SQL_INFX_ATTR_EXTENDED_TYPE_OWNER        1903 /* UCHAR ptr */
#define SQL_INFX_ATTR_EXTENDED_TYPE_ALIGNMENT    1904 /* UDWORD */
#define SQL_INFX_ATTR_SOURCE_TYPE_CODE           1905 /* UDWORD */

/* Informix Statement Attributes Extensions */
#define SQL_VMB_CHAR_LEN                         2325
#define SQL_INFX_ATTR_VMB_CHAR_LEN               SQL_VMB_CHAR_LEN
#define SQL_INFX_ATTR_MAX_FET_ARR_SIZE           2326

/* Informix fOption, SQL_VMB_CHAR_LEN vParam */
#define SQL_VMB_CHAR_EXACT                       0
#define SQL_VMB_CHAR_ESTIMATE                    1

/* Informix row/collection traversal constants */
#define SQL_INFX_RC_NEXT		1
#define SQL_INFX_RC_PRIOR		2
#define SQL_INFX_RC_FIRST		3
#define SQL_INFX_RC_LAST		4
#define SQL_INFX_RC_ABSOLUTE		5
#define SQL_INFX_RC_RELATIVE		6
#define SQL_INFX_RC_CURRENT		7

/*******************************************************************************
 * Large Object (LO) related structures
 *
 * LO_SPEC: Large object spec structure
 * It is used for creating smartblobs. The user may examin and/or set certain
 * fields of LO_SPEC by using ifx_lo_spec[set|get]_* accessor functions.
 *
 * LO_PTR: Large object pointer structure
 * Identifies the LO and provides ancillary, security-related information.
 *
 * LO_STAT: Large object stat structure
 * It is used in querying attribtes of smartblobs. The user may examin fields
 * herein by using ifx_lo_stat[set|get]_* accessor functions. 
 *
 * These structures are opaque to the user. Accessor functions are provided
 * for these structures.
 ******************************************************************************/

/* Informix GetInfo Extensions to obtain length of LO related structures */
#define SQL_INFX_LO_SPEC_LENGTH                  2250 /* UWORD */
#define SQL_INFX_LO_PTR_LENGTH                   2251 /* UWORD */
#define SQL_INFX_LO_STAT_LENGTH                  2252 /* UWORD */

/******************************************************************************
 * LO Open flags: (see documentation for further explanation)
 *
 * LO_APPEND   - Positions the seek position to end-of-file + 1. By itself,
 *               it is equivalent to write only mode followed by a seek to the
 *               end of large object. Read opeartions will fail.
 *               You can OR the LO_APPEND flag with another access mode.
 * LO_WRONLY   - Only write operations are valid on the data.
 * LO_RDONLY   - Only read operations are valid on the data.
 * LO_RDWR     - Both read and write operations are valid on the data.
 *
 * LO_RANDOM   - If set overrides optimizer decision. Indicates that I/O is
 *               random and that the system should not read-ahead.
 * LO_SEQUENTIAL - If set overrides optimizer decision. Indicates that
 *               reads are sequential in either forward or reverse direction.
 *
 * LO_FORWARD  - Only used for sequential access. Indicates that the sequential
 *               access will be in a forward direction, i.e. from low offset
 *               to higher offset.
 * LO_REVERSE  - Only used for sequential access. Indicates that the sequential
 *               access will be in a reverse direction.
 *
 * LO_BUFFER   - If set overrides optimizer decision. I/O goes through the
 *               buffer pool.
 * LO_NOBUFFER - If set then I/O does not use the buffer pool.
 ******************************************************************************/

#define LO_APPEND       0x1
#define LO_WRONLY       0x2
#define LO_RDONLY       0x4     /* default */
#define LO_RDWR         0x8

#define LO_RANDOM       0x20    /* default is determined by optimizer */
#define LO_SEQUENTIAL   0x40    /* default is determined by optimizer */

#define LO_FORWARD      0x80    /* default */
#define LO_REVERSE      0x100

#define LO_BUFFER       0x200   /* default is determined by optimizer */
#define LO_NOBUFFER     0x400   /* default is determined by optimizer */

#define LO_DIRTY_READ   0x10
#define LO_NODIRTY_READ 0x800
    
/*******************************************************************************
 * LO create-time flags: 
 *
 * Bitmask - Set/Get via ifx_lo_specset_flags() on LO_SPEC.
 ******************************************************************************/
 
#define LO_ATTR_LOG                          0x0001
#define LO_ATTR_NOLOG                        0x0002
#define LO_ATTR_DELAY_LOG                    0x0004
#define LO_ATTR_KEEP_LASTACCESS_TIME         0x0008
#define LO_ATTR_NOKEEP_LASTACCESS_TIME       0x0010
#define LO_ATTR_HIGH_INTEG                   0x0020
#define LO_ATTR_MODERATE_INTEG               0x0040

/*******************************************************************************
 * Symbolic constants for the "lseek" routine
 ******************************************************************************/
 
#define LO_SEEK_SET 0   /* Set curr. pos. to "offset"           */
#define LO_SEEK_CUR 1   /* Set curr. pos. to current + "offset" */
#define LO_SEEK_END 2   /* Set curr. pos. to EOF + "offset"     */
 
/*******************************************************************************
 * Intersolv specific infoTypes for SQLGetInfo
 ******************************************************************************/

#define SQL_RESERVED_WORDS						 1011
#define SQL_PSEUDO_COLUMNS						 1012
#define SQL_FROM_RESERVED_WORDS					 1013
#define SQL_WHERE_CLAUSE_TERMINATORS			 1014
#define SQL_COLUMN_FIRST_CHARS					 1015
#define SQL_COLUMN_MIDDLE_CHARS					 1016
#define SQL_TABLE_FIRST_CHARS					 1018
#define SQL_TABLE_MIDDLE_CHARS					 1019
#define SQL_FAST_SPECIAL_COLUMNS				 1021
#define SQL_ACCESS_CONFLICTS					 1022
#define SQL_LOCKING_SYNTAX						 1023
#define SQL_LOCKING_DURATION					 1024
#define SQL_RECORD_OPERATIONS					 1025
#define SQL_QUALIFIER_SYNTAX					 1026


#ifdef __cplusplus
}                                    /* End of extern "C" { */
#endif  /* __cplusplus */

#endif /* __INFXCLI_H */