sqlucode.h

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

/*
 *  sqlucode.h
 *
 *  $Id: sqlucode.h,v 1.1 2007/01/09 19:52:21 yas Exp $
 *
 *  ODBC Unicode defines
 *
 *  The iODBC driver manager.
 *
 *  Copyright (C) 1996-2006 by OpenLink Software <[e-mail]>
 *  All Rights Reserved.
 *
 *  This software is released under the terms of either of the following
 *  licenses:
 *
 *      - GNU Library General Public License (see LICENSE.LGPL)
 *      - The BSD License (see LICENSE.BSD).
 *
 *  Note that the only valid version of the LGPL license as far as this
 *  project is concerned is the original GNU Library General Public License
 *  Version 2, dated June 1991.
 *
 *  While not mandated by the BSD license, any patches you make to the
 *  iODBC source code may be contributed back into the iODBC project
 *  at your discretion. Contributions will benefit the Open Source and
 *  Data Access community as a whole. Submissions may be made at:
 *
 *      http://www.iodbc.org
 *
 *
 *  GNU Library Generic Public License Version 2
 *  ============================================
 *  This library is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU Library General Public
 *  License as published by the Free Software Foundation; only
 *  Version 2 of the License dated June 1991.
 *
 *  This library is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *  Library General Public License for more details.
 *
 *  You should have received a copy of the GNU Library General Public
 *  License along with this library; if not, write to the Free
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 *
 *
 *  The BSD License
 *  ===============
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions
 *  are met:
 *
 *  1. Redistributions of source code must retain the above copyright
 *     notice, this list of conditions and the following disclaimer.
 *  2. Redistributions in binary form must reproduce the above copyright
 *     notice, this list of conditions and the following disclaimer in
 *     the documentation and/or other materials provided with the
 *     distribution.
 *  3. Neither the name of OpenLink Software Inc. nor the names of its
 *     contributors may be used to endorse or promote products derived
 *     from this software without specific prior written permission.
 *
 *  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 *  "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 *  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 *  A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL OPENLINK OR
 *  CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 *  EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 *  PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 *  PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
 *  LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 *  NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 *  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */

#ifndef _SQLUCODE_H
#define _SQLUCODE_H

#ifndef _SQLEXT_H
#include <sqlext.h>
#endif

#ifdef __cplusplus
extern "C" {
#endif


/*
 *  SQL datatypes - Unicode
 */
#define SQL_WCHAR				(-8)
#define SQL_WVARCHAR				(-9)
#define SQL_WLONGVARCHAR			(-10)
#define SQL_C_WCHAR				SQL_WCHAR

#ifdef UNICODE
#define SQL_C_TCHAR				SQL_C_WCHAR
#else
#define SQL_C_TCHAR				SQL_C_CHAR
#endif


/* SQLTablesW */
#if (ODBCVER >= 0x0300)
#define SQL_ALL_CATALOGSW			L"%"
#define SQL_ALL_SCHEMASW			L"%"
#define SQL_ALL_TABLE_TYPESW			L"%"
#endif /* ODBCVER >= 0x0300 */


/*
 *  Size of SQLSTATE - Unicode
 */
#define SQL_SQLSTATE_SIZEW			10


/*
 *  Function Prototypes - Unicode
 */
SQLRETURN SQL_API SQLColAttributeW (
    SQLHSTMT		  hstmt,
    SQLUSMALLINT	  iCol,
    SQLUSMALLINT	  iField,
    SQLPOINTER		  pCharAttr,
    SQLSMALLINT		  cbCharAttrMax,
    SQLSMALLINT		* pcbCharAttr,
    SQLLEN		* pNumAttr);

SQLRETURN SQL_API SQLColAttributesW (
    SQLHSTMT		  hstmt,
    SQLUSMALLINT	  icol,
    SQLUSMALLINT	  fDescType,
    SQLPOINTER		  rgbDesc,
    SQLSMALLINT		  cbDescMax,
    SQLSMALLINT		* pcbDesc,
    SQLLEN		* pfDesc);

SQLRETURN SQL_API SQLConnectW (
    SQLHDBC		  hdbc,
    SQLWCHAR		* szDSN,
    SQLSMALLINT		  cbDSN,
    SQLWCHAR		* szUID,
    SQLSMALLINT		  cbUID,
    SQLWCHAR		* szAuthStr,
    SQLSMALLINT		  cbAuthStr);

SQLRETURN SQL_API SQLDescribeColW (
    SQLHSTMT		  hstmt,
    SQLUSMALLINT	  icol,
    SQLWCHAR		* szColName,
    SQLSMALLINT		  cbColNameMax,
    SQLSMALLINT		* pcbColName,
    SQLSMALLINT		* pfSqlType,
    SQLULEN		* pcbColDef,
    SQLSMALLINT		* pibScale,
    SQLSMALLINT		* pfNullable);

SQLRETURN SQL_API SQLErrorW (
    SQLHENV		  henv,
    SQLHDBC		  hdbc,
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szSqlState,
    SQLINTEGER		* pfNativeError,
    SQLWCHAR		* szErrorMsg,
    SQLSMALLINT		  cbErrorMsgMax,
    SQLSMALLINT		* pcbErrorMsg);

SQLRETURN SQL_API SQLExecDirectW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szSqlStr,
    SQLINTEGER		  cbSqlStr);

SQLRETURN SQL_API SQLGetConnectAttrW (
    SQLHDBC		  hdbc,
    SQLINTEGER		  fAttribute,
    SQLPOINTER		  rgbValue,
    SQLINTEGER		  cbValueMax,
    SQLINTEGER		* pcbValue);

SQLRETURN SQL_API SQLGetCursorNameW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCursor,
    SQLSMALLINT		  cbCursorMax,
    SQLSMALLINT		* pcbCursor);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLSetDescFieldW (
    SQLHDESC		  DescriptorHandle,
    SQLSMALLINT		  RecNumber,
    SQLSMALLINT		  FieldIdentifier,
    SQLPOINTER		  Value,
    SQLINTEGER		  BufferLength);

SQLRETURN SQL_API SQLGetDescFieldW (
    SQLHDESC		  hdesc,
    SQLSMALLINT		  iRecord,
    SQLSMALLINT		  iField,
    SQLPOINTER		  rgbValue,
    SQLINTEGER		  cbValueMax,
    SQLINTEGER		* pcbValue);

SQLRETURN SQL_API SQLGetDescRecW (
    SQLHDESC		  hdesc,
    SQLSMALLINT		  iRecord,
    SQLWCHAR		* szName,
    SQLSMALLINT		  cbNameMax,
    SQLSMALLINT		* pcbName,
    SQLSMALLINT		* pfType,
    SQLSMALLINT		* pfSubType,
    SQLLEN		* pLength,
    SQLSMALLINT		* pPrecision,
    SQLSMALLINT		* pScale,
    SQLSMALLINT		* pNullable);

SQLRETURN SQL_API SQLGetDiagFieldW (
    SQLSMALLINT		  fHandleType,
    SQLHANDLE		  handle,
    SQLSMALLINT		  iRecord,
    SQLSMALLINT		  fDiagField,
    SQLPOINTER		  rgbDiagInfo,
    SQLSMALLINT		  cbDiagInfoMax,
    SQLSMALLINT		* pcbDiagInfo);

SQLRETURN SQL_API SQLGetDiagRecW (
    SQLSMALLINT		  fHandleType,
    SQLHANDLE		  handle,
    SQLSMALLINT		  iRecord,
    SQLWCHAR		* szSqlState,
    SQLINTEGER		* pfNativeError,
    SQLWCHAR		* szErrorMsg,
    SQLSMALLINT		  cbErrorMsgMax,
    SQLSMALLINT		* pcbErrorMsg);
#endif

SQLRETURN SQL_API SQLPrepareW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szSqlStr,
    SQLINTEGER		  cbSqlStr);

SQLRETURN SQL_API SQLSetConnectAttrW (
    SQLHDBC		  hdbc,
    SQLINTEGER		  fAttribute,
    SQLPOINTER		  rgbValue,
    SQLINTEGER		  cbValue);

SQLRETURN SQL_API SQLSetCursorNameW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCursor,
    SQLSMALLINT		  cbCursor);

SQLRETURN SQL_API SQLColumnsW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCatalogName,
    SQLSMALLINT		  cbCatalogName,
    SQLWCHAR		* szSchemaName,
    SQLSMALLINT		  cbSchemaName,
    SQLWCHAR		* szTableName,
    SQLSMALLINT		  cbTableName,
    SQLWCHAR		* szColumnName,
    SQLSMALLINT		  cbColumnName);

SQLRETURN SQL_API SQLGetConnectOptionW (
    SQLHDBC		  hdbc,
    SQLUSMALLINT	  fOption,
    SQLPOINTER		  pvParam);

SQLRETURN SQL_API SQLGetInfoW (
    SQLHDBC		  hdbc,
    SQLUSMALLINT	  fInfoType,
    SQLPOINTER		  rgbInfoValue,
    SQLSMALLINT		  cbInfoValueMax,
    SQLSMALLINT		* pcbInfoValue);

SQLRETURN SQL_API SQLGetTypeInfoW (
    SQLHSTMT		  StatementHandle,
    SQLSMALLINT		  DataType);

SQLRETURN SQL_API SQLSetConnectOptionW (
    SQLHDBC		  hdbc,
    SQLUSMALLINT	  fOption,
    SQLULEN		  vParam);

SQLRETURN SQL_API SQLSpecialColumnsW (
    SQLHSTMT		  hstmt,
    SQLUSMALLINT	  fColType,
    SQLWCHAR		* szCatalogName,
    SQLSMALLINT		  cbCatalogName,
    SQLWCHAR		* szSchemaName,
    SQLSMALLINT		  cbSchemaName,
    SQLWCHAR		* szTableName,
    SQLSMALLINT		  cbTableName,
    SQLUSMALLINT	  fScope,
    SQLUSMALLINT	  fNullable);

SQLRETURN SQL_API SQLStatisticsW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCatalogName,
    SQLSMALLINT		  cbCatalogName,
    SQLWCHAR		* szSchemaName,
    SQLSMALLINT		  cbSchemaName,
    SQLWCHAR		* szTableName,
    SQLSMALLINT		  cbTableName,
    SQLUSMALLINT	  fUnique,
    SQLUSMALLINT	  fAccuracy);

SQLRETURN SQL_API SQLTablesW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCatalogName,
    SQLSMALLINT		  cbCatalogName,
    SQLWCHAR		* szSchemaName,
    SQLSMALLINT		  cbSchemaName,
    SQLWCHAR		* szTableName,
    SQLSMALLINT		  cbTableName,
    SQLWCHAR		* szTableType,
    SQLSMALLINT		  cbTableType);

SQLRETURN SQL_API SQLDataSourcesW (
    SQLHENV		  henv,
    SQLUSMALLINT	  fDirection,
    SQLWCHAR		* szDSN,
    SQLSMALLINT		  cbDSNMax,
    SQLSMALLINT		* pcbDSN,
    SQLWCHAR		* szDescription,
    SQLSMALLINT		  cbDescriptionMax,
    SQLSMALLINT		* pcbDescription);

SQLRETURN SQL_API SQLDriverConnectW (
    SQLHDBC		  hdbc,
    SQLHWND		  hwnd,
    SQLWCHAR		* szConnStrIn,
    SQLSMALLINT		  cbConnStrIn,
    SQLWCHAR		* szConnStrOut,
    SQLSMALLINT		  cbConnStrOutMax,
    SQLSMALLINT		* pcbConnStrOut,
    SQLUSMALLINT	  fDriverCompletion);

SQLRETURN SQL_API SQLBrowseConnectW (
    SQLHDBC		  hdbc,
    SQLWCHAR		* szConnStrIn,
    SQLSMALLINT		  cbConnStrIn,
    SQLWCHAR		* szConnStrOut,
    SQLSMALLINT		  cbConnStrOutMax,
    SQLSMALLINT		* pcbConnStrOut);

SQLRETURN SQL_API SQLColumnPrivilegesW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCatalogName,
    SQLSMALLINT		  cbCatalogName,
    SQLWCHAR		* szSchemaName,
    SQLSMALLINT		  cbSchemaName,
    SQLWCHAR		* szTableName,
    SQLSMALLINT		  cbTableName,
    SQLWCHAR		* szColumnName,
    SQLSMALLINT		  cbColumnName);

SQLRETURN SQL_API SQLGetStmtAttrW (
    SQLHSTMT		  hstmt,
    SQLINTEGER		  fAttribute,
    SQLPOINTER		  rgbValue,
    SQLINTEGER		  cbValueMax,
    SQLINTEGER		* pcbValue);

SQLRETURN SQL_API SQLSetStmtAttrW (
    SQLHSTMT		  hstmt,
    SQLINTEGER		  fAttribute,
    SQLPOINTER		  rgbValue,
    SQLINTEGER		  cbValueMax);

SQLRETURN SQL_API SQLForeignKeysW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szPkCatalogName,
    SQLSMALLINT		  cbPkCatalogName,
    SQLWCHAR		* szPkSchemaName,
    SQLSMALLINT		  cbPkSchemaName,
    SQLWCHAR		* szPkTableName,
    SQLSMALLINT		  cbPkTableName,
    SQLWCHAR		* szFkCatalogName,
    SQLSMALLINT		  cbFkCatalogName,
    SQLWCHAR		* szFkSchemaName,
    SQLSMALLINT		  cbFkSchemaName,
    SQLWCHAR		* szFkTableName,
    SQLSMALLINT		  cbFkTableName);

SQLRETURN SQL_API SQLNativeSqlW (
    SQLHDBC		  hdbc,
    SQLWCHAR		* szSqlStrIn,
    SQLINTEGER		  cbSqlStrIn,
    SQLWCHAR		* szSqlStr,
    SQLINTEGER		  cbSqlStrMax,
    SQLINTEGER		* pcbSqlStr);

SQLRETURN SQL_API SQLPrimaryKeysW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCatalogName,
    SQLSMALLINT		  cbCatalogName,
    SQLWCHAR		* szSchemaName,
    SQLSMALLINT		  cbSchemaName,
    SQLWCHAR		* szTableName,
    SQLSMALLINT		  cbTableName);

SQLRETURN SQL_API SQLProcedureColumnsW (
    SQLHSTMT		  hstmt,
    SQLWCHAR		* szCatalogName,
    SQLSMALLINT		  cbCatalogName,
    SQLWCHAR		* szSchemaName,
    SQLSMALLINT		  cbSchemaName,
    SQLWCHAR		* szProcName,
    SQLSMALLINT		  cbProcName,
    SQLWCHAR		* szColumnName,