/usr/include/sql.h

/*
 *  sql.h
 *
 *  $Id: sql.h,v 1.11 2009/09/09 20:06:24 source Exp $
 *
 *  ODBC defines
 *
 *  The iODBC driver manager.
 *
 *  Copyright (C) 1995 by Ke Jin <kejin@empress.com>
 *  Copyright (C) 1996-2009 by OpenLink Software <iodbc@openlinksw.com>
 *  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 _SQL_H
#define _SQL_H

/*
 *  Set default specification to ODBC 3.51
 */
#ifndef ODBCVER
#define ODBCVER		0x0351
#endif

#ifndef _SQLTYPES_H
#include <sqltypes.h>
#endif

#ifdef __cplusplus
extern "C" {
#endif

/*
 *  Useful Constants
 */
#define SQL_MAX_MESSAGE_LENGTH			512


/*
 *  Handle types
 */
#if (ODBCVER >= 0x0300)
#define SQL_HANDLE_ENV				1
#define SQL_HANDLE_DBC				2
#define SQL_HANDLE_STMT				3
#define SQL_HANDLE_DESC				4
#endif	/* ODBCVER >= 0x0300 */


/*
 *  Function return codes
 */
#define SQL_SUCCESS				0
#define SQL_SUCCESS_WITH_INFO			1
#define SQL_STILL_EXECUTING			2
#define SQL_ERROR				(-1)
#define SQL_INVALID_HANDLE			(-2)
#define SQL_NEED_DATA				99
#if (ODBCVER >= 0x0300)
#define SQL_NO_DATA				100
#endif	/* ODBCVER >= 0x0300 */


/*
 *  Test for SQL_SUCCESS or SQL_SUCCESS_WITH_INFO
 */
#define SQL_SUCCEEDED(rc)			(((rc) & (~1)) == 0)


/*
 *  Special length values
 */
#define SQL_NULL_DATA				(-1)
#define SQL_DATA_AT_EXEC			(-2)


/*
 *  Flags for null-terminated strings
 */
#define SQL_NTS					(-3)
#define SQL_NTSL				(-3L)


/*
 *  Standard SQL datatypes, using ANSI type numbering
 */
#define SQL_UNKNOWN_TYPE			0
#define SQL_CHAR				1
#define SQL_NUMERIC				2
#define SQL_DECIMAL				3
#define SQL_INTEGER				4
#define SQL_SMALLINT				5
#define SQL_FLOAT				6
#define SQL_REAL				7
#define SQL_DOUBLE				8
#if (ODBCVER >= 0x0300)
#define SQL_DATETIME				9
#endif	/* ODBCVER >= 0x0300 */
#define SQL_VARCHAR				12


/*
 *  SQLGetTypeInfo request for all data types
 */
#define SQL_ALL_TYPES				0


/*
 *  Statement attribute values for date/time data types
 */
#if (ODBCVER >= 0x0300)
#define SQL_TYPE_DATE				91
#define SQL_TYPE_TIME				92
#define SQL_TYPE_TIMESTAMP			93
#endif	/* ODBCVER >= 0x0300 */


/*
 *  Date/Time length constants
 */
#if (ODBCVER >= 0x0300)
#define SQL_DATE_LEN				10
#define SQL_TIME_LEN				8	/* add P+1 if prec >0 */
#define SQL_TIMESTAMP_LEN			19	/* add P+1 if prec >0 */
#endif	/* ODBCVER >= 0x0300 */


/*
 *  NULL status constants
 */
#define SQL_NO_NULLS				0
#define SQL_NULLABLE				1
#define SQL_NULLABLE_UNKNOWN			2


/*
 *  NULL Handles
 */
#define SQL_NULL_HENV				0
#define SQL_NULL_HDBC				0
#define SQL_NULL_HSTMT				0
#if (ODBCVER >= 0x0300)
#define SQL_NULL_HDESC				0
#endif	/* ODBCVER >= 0x0300 */


/*
 *  NULL handle for parent argument to SQLAllocHandle when allocating
 *  a SQLHENV
 */
#if (ODBCVER >= 0x0300)
#define SQL_NULL_HANDLE				0L
#endif	/* ODBCVER >= 0x0300 */


/*
 *  CLI option values
 */
#if (ODBCVER >= 0x0300)
#define SQL_FALSE				0
#define SQL_TRUE				1
#endif	/* ODBCVER >= 0x0300 */


/*
 *  Default conversion code for SQLBindCol(), SQLBindParam() and SQLGetData()
 */
#if (ODBCVER >= 0x0300)
#define SQL_DEFAULT				99
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLDataSources/SQLFetchScroll - FetchOrientation
 */
#define SQL_FETCH_NEXT				1
#define SQL_FETCH_FIRST				2


/*
 *  SQLFetchScroll - FetchOrientation
 */
#define SQL_FETCH_LAST				3
#define SQL_FETCH_PRIOR				4
#define SQL_FETCH_ABSOLUTE			5
#define SQL_FETCH_RELATIVE			6


/*
 *  SQLFreeStmt
 */
#define SQL_CLOSE				0
#define SQL_DROP				1
#define SQL_UNBIND				2
#define SQL_RESET_PARAMS			3


/*
 *  SQLGetConnectAttr - connection attributes
 */
#if (ODBCVER >= 0x0300)
#define SQL_ATTR_AUTO_IPD			10001
#define SQL_ATTR_METADATA_ID			10014
#endif	/* ODBCVER >= 0x0300 */


/*
 *   SQLGetData() code indicating that the application row descriptor
 *   specifies the data type
 */
#if (ODBCVER >= 0x0300)
#define SQL_ARD_TYPE				(-99)
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDescField - identifiers of fields in the SQL descriptor
 */
#if (ODBCVER >= 0x0300)
#define SQL_DESC_COUNT				1001
#define SQL_DESC_TYPE				1002
#define SQL_DESC_LENGTH				1003
#define SQL_DESC_OCTET_LENGTH_PTR		1004
#define SQL_DESC_PRECISION			1005
#define SQL_DESC_SCALE				1006
#define SQL_DESC_DATETIME_INTERVAL_CODE		1007
#define SQL_DESC_NULLABLE			1008
#define SQL_DESC_INDICATOR_PTR			1009
#define SQL_DESC_DATA_PTR			1010
#define SQL_DESC_NAME				1011
#define SQL_DESC_UNNAMED			1012
#define SQL_DESC_OCTET_LENGTH			1013
#define SQL_DESC_ALLOC_TYPE			1099
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDescField - SQL_DESC_ALLOC_TYPE
 */
#if (ODBCVER >= 0x0300)
#define SQL_DESC_ALLOC_AUTO			1
#define SQL_DESC_ALLOC_USER			2
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDescField - SQL_DESC_DATETIME_INTERVAL_CODE
 */
#if (ODBCVER >= 0x0300)
#define SQL_CODE_DATE				1
#define SQL_CODE_TIME				2
#define SQL_CODE_TIMESTAMP			3
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDescField - SQL_DESC_UNNAMED
 */
#if (ODBCVER >= 0x0300)
#define SQL_NAMED				0
#define SQL_UNNAMED				1
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDiagField - identifiers of fields in the diagnostics area
 */
#if (ODBCVER >= 0x0300)
#define SQL_DIAG_RETURNCODE			1
#define SQL_DIAG_NUMBER				2
#define SQL_DIAG_ROW_COUNT			3
#define SQL_DIAG_SQLSTATE			4
#define SQL_DIAG_NATIVE				5
#define SQL_DIAG_MESSAGE_TEXT			6
#define SQL_DIAG_DYNAMIC_FUNCTION		7
#define SQL_DIAG_CLASS_ORIGIN			8
#define SQL_DIAG_SUBCLASS_ORIGIN		9
#define SQL_DIAG_CONNECTION_NAME		10
#define SQL_DIAG_SERVER_NAME			11
#define SQL_DIAG_DYNAMIC_FUNCTION_CODE		12
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetDiagField - SQL_DIAG_DYNAMIC_FUNCTION_CODE
 */
#if (ODBCVER >= 0x0300)
#define SQL_DIAG_ALTER_DOMAIN			3
#define SQL_DIAG_ALTER_TABLE			4
#define SQL_DIAG_CALL				7
#define SQL_DIAG_CREATE_ASSERTION		6
#define SQL_DIAG_CREATE_CHARACTER_SET		8
#define SQL_DIAG_CREATE_COLLATION		10
#define SQL_DIAG_CREATE_DOMAIN			23
#define SQL_DIAG_CREATE_INDEX			(-1)
#define SQL_DIAG_CREATE_SCHEMA			64
#define SQL_DIAG_CREATE_TABLE			77
#define SQL_DIAG_CREATE_TRANSLATION		79
#define SQL_DIAG_CREATE_VIEW			84
#define SQL_DIAG_DELETE_WHERE			19
#define	SQL_DIAG_DROP_ASSERTION			24
#define	SQL_DIAG_DROP_CHARACTER_SET		25
#define	SQL_DIAG_DROP_COLLATION			26
#define	SQL_DIAG_DROP_DOMAIN			27
#define SQL_DIAG_DROP_INDEX			(-2)
#define SQL_DIAG_DROP_SCHEMA			31
#define SQL_DIAG_DROP_TABLE			32
#define SQL_DIAG_DROP_TRANSLATION		33
#define SQL_DIAG_DROP_VIEW			36
#define SQL_DIAG_DYNAMIC_DELETE_CURSOR		38
#define SQL_DIAG_DYNAMIC_UPDATE_CURSOR		81
#define SQL_DIAG_GRANT				48
#define SQL_DIAG_INSERT				50
#define SQL_DIAG_REVOKE				59
#define SQL_DIAG_SELECT_CURSOR			85
#define SQL_DIAG_UNKNOWN_STATEMENT		0
#define SQL_DIAG_UPDATE_WHERE			82
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetEnvAttr - environment attribute
 */
#if (ODBCVER >= 0x0300)
#define SQL_ATTR_OUTPUT_NTS			10001
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetFunctions
 */
#define SQL_API_SQLALLOCCONNECT			1
#define SQL_API_SQLALLOCENV			2
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLALLOCHANDLE			1001
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLALLOCSTMT			3
#define SQL_API_SQLBINDCOL			4
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLBINDPARAM			1002
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLCANCEL			5
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLCLOSECURSOR			1003
#define SQL_API_SQLCOLATTRIBUTE			6
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLCOLUMNS			40
#define SQL_API_SQLCONNECT			7
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLCOPYDESC			1004
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLDATASOURCES			57
#define SQL_API_SQLDESCRIBECOL			8
#define SQL_API_SQLDISCONNECT			9
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLENDTRAN			1005
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLERROR			10
#define SQL_API_SQLEXECDIRECT			11
#define SQL_API_SQLEXECUTE			12
#define SQL_API_SQLFETCH			13
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLFETCHSCROLL			1021
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLFREECONNECT			14
#define SQL_API_SQLFREEENV			15
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLFREEHANDLE			1006
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLFREESTMT			16
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLGETCONNECTATTR		1007
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLGETCONNECTOPTION		42
#define SQL_API_SQLGETCURSORNAME		17
#define SQL_API_SQLGETDATA			43
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLGETDESCFIELD			1008
#define SQL_API_SQLGETDESCREC			1009
#define SQL_API_SQLGETDIAGFIELD			1010
#define SQL_API_SQLGETDIAGREC			1011
#define SQL_API_SQLGETENVATTR			1012
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLGETFUNCTIONS			44
#define SQL_API_SQLGETINFO			45
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLGETSTMTATTR			1014
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLGETSTMTOPTION		46
#define SQL_API_SQLGETTYPEINFO			47
#define SQL_API_SQLNUMRESULTCOLS		18
#define SQL_API_SQLPARAMDATA			48
#define SQL_API_SQLPREPARE			19
#define SQL_API_SQLPUTDATA			49
#define SQL_API_SQLROWCOUNT			20
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLSETCONNECTATTR		1016
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLSETCONNECTOPTION		50
#define SQL_API_SQLSETCURSORNAME		21
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLSETDESCFIELD			1017
#define SQL_API_SQLSETDESCREC			1018
#define SQL_API_SQLSETENVATTR			1019
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLSETPARAM			22
#if (ODBCVER >= 0x0300)
#define SQL_API_SQLSETSTMTATTR			1020
#endif	/* ODBCVER >= 0x0300 */
#define SQL_API_SQLSETSTMTOPTION		51
#define SQL_API_SQLSPECIALCOLUMNS		52
#define SQL_API_SQLSTATISTICS			53
#define SQL_API_SQLTABLES			54
#define SQL_API_SQLTRANSACT			23


/*
 *  SQLGetInfo
 */
#if (ODBCVER >= 0x0300)
#define SQL_MAX_DRIVER_CONNECTIONS		0
#define SQL_MAXIMUM_DRIVER_CONNECTIONS		SQL_MAX_DRIVER_CONNECTIONS
#define SQL_MAX_CONCURRENT_ACTIVITIES		1
#define SQL_MAXIMUM_CONCURRENT_ACTIVITIES	SQL_MAX_CONCURRENT_ACTIVITIES
#endif	/* ODBCVER >= 0x0300 */
#define SQL_DATA_SOURCE_NAME			2
#define SQL_FETCH_DIRECTION			8
#define SQL_SERVER_NAME				13
#define SQL_SEARCH_PATTERN_ESCAPE		14
#define SQL_DBMS_NAME				17
#define SQL_DBMS_VER				18
#define SQL_ACCESSIBLE_TABLES			19
#define SQL_ACCESSIBLE_PROCEDURES		20
#define SQL_CURSOR_COMMIT_BEHAVIOR		23
#define SQL_DATA_SOURCE_READ_ONLY		25
#define SQL_DEFAULT_TXN_ISOLATION		26
#define SQL_IDENTIFIER_CASE			28
#define SQL_IDENTIFIER_QUOTE_CHAR		29
#define SQL_MAX_COLUMN_NAME_LEN			30
#define SQL_MAXIMUM_COLUMN_NAME_LENGTH		SQL_MAX_COLUMN_NAME_LEN
#define SQL_MAX_CURSOR_NAME_LEN			31
#define SQL_MAXIMUM_CURSOR_NAME_LENGTH		SQL_MAX_CURSOR_NAME_LEN
#define SQL_MAX_SCHEMA_NAME_LEN			32
#define SQL_MAXIMUM_SCHEMA_NAME_LENGTH		SQL_MAX_SCHEMA_NAME_LEN
#define SQL_MAX_CATALOG_NAME_LEN		34
#define SQL_MAXIMUM_CATALOG_NAME_LENGTH		SQL_MAX_CATALOG_NAME_LEN
#define SQL_MAX_TABLE_NAME_LEN			35
#define SQL_SCROLL_CONCURRENCY			43
#define SQL_TXN_CAPABLE				46
#define SQL_TRANSACTION_CAPABLE			SQL_TXN_CAPABLE
#define SQL_USER_NAME				47
#define SQL_TXN_ISOLATION_OPTION		72
#define SQL_TRANSACTION_ISOLATION_OPTION	SQL_TXN_ISOLATION_OPTION
#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_MAX_COLUMNS_IN_GROUP_BY		97
#define SQL_MAXIMUM_COLUMNS_IN_GROUP_BY		SQL_MAX_COLUMNS_IN_GROUP_BY
#define SQL_MAX_COLUMNS_IN_INDEX		98
#define SQL_MAXIMUM_COLUMNS_IN_INDEX		SQL_MAX_COLUMNS_IN_INDEX
#define SQL_MAX_COLUMNS_IN_ORDER_BY		99
#define SQL_MAXIMUM_COLUMNS_IN_ORDER_BY		SQL_MAX_COLUMNS_IN_ORDER_BY
#define SQL_MAX_COLUMNS_IN_SELECT		100
#define SQL_MAXIMUM_COLUMNS_IN_SELECT		SQL_MAX_COLUMNS_IN_SELECT
#define SQL_MAX_COLUMNS_IN_TABLE		101
#define SQL_MAX_INDEX_SIZE			102
#define SQL_MAXIMUM_INDEX_SIZE			SQL_MAX_INDEX_SIZE
#define SQL_MAX_ROW_SIZE			104
#define SQL_MAXIMUM_ROW_SIZE			SQL_MAX_ROW_SIZE
#define SQL_MAX_STATEMENT_LEN			105
#define SQL_MAXIMUM_STATEMENT_LENGTH		SQL_MAX_STATEMENT_LEN
#define SQL_MAX_TABLES_IN_SELECT		106
#define SQL_MAXIMUM_TABLES_IN_SELECT		SQL_MAX_TABLES_IN_SELECT
#define SQL_MAX_USER_NAME_LEN			107
#define SQL_MAXIMUM_USER_NAME_LENGTH		SQL_MAX_USER_NAME_LEN
#if (ODBCVER >= 0x0300)
#define SQL_OJ_CAPABILITIES			115
#define SQL_OUTER_JOIN_CAPABILITIES		SQL_OJ_CAPABILITIES
#endif	/* ODBCVER >= 0x0300 */

#if (ODBCVER >= 0x0300)
#define SQL_XOPEN_CLI_YEAR			10000
#define SQL_CURSOR_SENSITIVITY			10001
#define SQL_DESCRIBE_PARAMETER			10002
#define SQL_CATALOG_NAME			10003
#define SQL_COLLATION_SEQ			10004
#define SQL_MAX_IDENTIFIER_LEN			10005
#define SQL_MAXIMUM_IDENTIFIER_LENGTH		SQL_MAX_IDENTIFIER_LEN
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_ALTER_TABLE
 */
#if (ODBCVER >= 0x0200)
#define SQL_AT_ADD_COLUMN			0x00000001L
#define SQL_AT_DROP_COLUMN			0x00000002L
#endif	/* ODBCVER >= 0x0300 */

#if (ODBCVER >= 0x0300)
#define SQL_AT_ADD_CONSTRAINT			0x00000008L
/*
 * The following bitmasks are ODBC extensions and defined in sqlext.h:
 *
 * #define SQL_AT_COLUMN_SINGLE				0x00000020L
 * #define SQL_AT_ADD_COLUMN_DEFAULT			0x00000040L
 * #define SQL_AT_ADD_COLUMN_COLLATION			0x00000080L
 * #define SQL_AT_SET_COLUMN_DEFAULT			0x00000100L
 * #define SQL_AT_DROP_COLUMN_DEFAULT			0x00000200L
 * #define SQL_AT_DROP_COLUMN_CASCADE			0x00000400L
 * #define SQL_AT_DROP_COLUMN_RESTRICT			0x00000800L
 * #define SQL_AT_ADD_TABLE_CONSTRAINT			0x00001000L
 * #define SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE		0x00002000L
 * #define SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT	0x00004000L
 * #define SQL_AT_CONSTRAINT_NAME_DEFINITION		0x00008000L
 * #define SQL_AT_CONSTRAINT_INITIALLY_DEFERRED		0x00010000L
 * #define SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE	0x00020000L
 * #define SQL_AT_CONSTRAINT_DEFERRABLE			0x00040000L
 * #define SQL_AT_CONSTRAINT_NON_DEFERRABLE		0x00080000L
 */
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_ASYNC_MODE
 */
#if (ODBCVER >= 0x0300)
#define SQL_AM_NONE				0
#define SQL_AM_CONNECTION			1
#define SQL_AM_STATEMENT			2
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetInfo - SQL_CURSOR_COMMIT_BEHAVIOR
 */
#define SQL_CB_DELETE				0
#define SQL_CB_CLOSE				1
#define SQL_CB_PRESERVE				2


/*
 *  SQLGetInfo - SQL_FETCH_DIRECTION
 */
#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


/*
 *  SQLGetInfo - SQL_GETDATA_EXTENSIONS
 */
#define SQL_GD_ANY_COLUMN			0x00000001L
#define SQL_GD_ANY_ORDER			0x00000002L


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


/*
 *  SQLGetInfo - SQL_NULL_COLLATION
 */
#define SQL_NC_HIGH				0
#define SQL_NC_LOW				1


/*
 *  SQLGetInfo - SQL_OJ_CAPABILITIES
 */
#if (ODBCVER >= 0x0201)
#define SQL_OJ_LEFT				0x00000001L
#define SQL_OJ_RIGHT				0x00000002L
#define SQL_OJ_FULL				0x00000004L
#define SQL_OJ_NESTED				0x00000008L
#define SQL_OJ_NOT_ORDERED			0x00000010L
#define SQL_OJ_INNER				0x00000020L
#define SQL_OJ_ALL_COMPARISON_OPS		0x00000040L
#endif


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


/*
 *  SQLGetInfo - SQL_TXN_CAPABLE
 */
#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


/*
 *  SQLGetInfo - SQL_TXN_ISOLATION_OPTION
 */
#define SQL_TXN_READ_UNCOMMITTED		0x00000001L
#define SQL_TRANSACTION_READ_UNCOMMITTED	SQL_TXN_READ_UNCOMMITTED
#define SQL_TXN_READ_COMMITTED			0x00000002L
#define SQL_TRANSACTION_READ_COMMITTED		SQL_TXN_READ_COMMITTED
#define SQL_TXN_REPEATABLE_READ			0x00000004L
#define SQL_TRANSACTION_REPEATABLE_READ		SQL_TXN_REPEATABLE_READ
#define SQL_TXN_SERIALIZABLE			0x00000008L
#define SQL_TRANSACTION_SERIALIZABLE		SQL_TXN_SERIALIZABLE


/*
 *  SQLGetStmtAttr - statement attributes
 */
#if (ODBCVER >= 0x0300)
#define SQL_ATTR_APP_ROW_DESC			10010
#define SQL_ATTR_APP_PARAM_DESC			10011
#define SQL_ATTR_IMP_ROW_DESC			10012
#define SQL_ATTR_IMP_PARAM_DESC			10013
#define SQL_ATTR_CURSOR_SCROLLABLE		(-1)
#define SQL_ATTR_CURSOR_SENSITIVITY		(-2)
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetStmtAttr - SQL_ATTR_CURSOR_SCROLLABLE
 */
#if (ODBCVER >= 0x0300)
#define SQL_NONSCROLLABLE			0
#define SQL_SCROLLABLE				1
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetStmtAttr - SQL_ATTR_CURSOR_SENSITIVITY
 */
#if (ODBCVER >= 0x0300)
#define SQL_UNSPECIFIED				0
#define SQL_INSENSITIVE				1
#define SQL_SENSITIVE				2
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetTypeInfo - SEARCHABLE
 */
#if (ODBCVER >= 0x0300)
#define SQL_PRED_NONE				0
#define SQL_PRED_CHAR				1
#define SQL_PRED_BASIC				2
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLSpecialColumns - Column scopes
 */
#define SQL_SCOPE_CURROW			0
#define SQL_SCOPE_TRANSACTION			1
#define SQL_SCOPE_SESSION			2


/*
 *  SQLSpecialColumns - PSEUDO_COLUMN
 */
#define SQL_PC_UNKNOWN				0
#if (ODBCVER >= 0x0300)
#define SQL_PC_NON_PSEUDO			1
#endif	/* ODBCVER >= 0x0300 */
#define SQL_PC_PSEUDO				2


/*
 *  SQLSpecialColumns - IdentifierType
 */
#if (ODBCVER >= 0x0300)
#define SQL_ROW_IDENTIFIER			1
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLStatistics - fUnique
 */
#define SQL_INDEX_UNIQUE			0
#define SQL_INDEX_ALL				1


/*
 *  SQLStatistics - TYPE
 */
#define SQL_INDEX_CLUSTERED			1
#define SQL_INDEX_HASHED			2
#define SQL_INDEX_OTHER				3


/*
 *  SQLTransact/SQLEndTran
 */
#define SQL_COMMIT				0
#define SQL_ROLLBACK				1


/*
 *  Function Prototypes
 */
SQLRETURN SQL_API SQLAllocConnect (
    SQLHENV		  EnvironmentHandle,
    SQLHDBC		* ConnectionHandle);

SQLRETURN SQL_API SQLAllocEnv (
    SQLHENV		* EnvironmentHandle);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLAllocHandle (
    SQLSMALLINT		  HandleType,
    SQLHANDLE		  InputHandle,
    SQLHANDLE		* OutputHandle);
#endif	/* ODBCVER >= 0x0300 */

SQLRETURN SQL_API SQLAllocStmt (
    SQLHDBC		  ConnectionHandle,
    SQLHSTMT		* StatementHandle);

SQLRETURN SQL_API SQLBindCol (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  ColumnNumber,
    SQLSMALLINT		  TargetType,
    SQLPOINTER		  TargetValue,
    SQLLEN		  BufferLength,
    SQLLEN		* StrLen_or_Ind);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLBindParam (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  ParameterNumber,
    SQLSMALLINT		  ValueType,
    SQLSMALLINT		  ParameterType,
    SQLULEN		  LengthPrecision,
    SQLSMALLINT		  ParameterScale,
    SQLPOINTER		  ParameterValue,
    SQLLEN		* StrLen_or_Ind);
#endif

SQLRETURN SQL_API SQLCancel (
    SQLHSTMT		  StatementHandle);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLCloseCursor (
    SQLHSTMT		  StatementHandle);

/*
 *  Using SQLLEN * instead of SQLPOINTER for NumericAttribute,
 *  makes the prototype the same as SQLColAttributes (deprecated)
 *  and clearer for 64bit ports
 */
SQLRETURN SQL_API SQLColAttribute (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  ColumnNumber,
    SQLUSMALLINT	  FieldIdentifier,
    SQLPOINTER		  CharacterAttribute,
    SQLSMALLINT		  BufferLength,
    SQLSMALLINT		* StringLength,
    SQLLEN		* NumericAttribute);
#endif

SQLRETURN SQL_API SQLColumns (
    SQLHSTMT		  StatementHandle,
    SQLCHAR		* CatalogName,
    SQLSMALLINT		  NameLength1,
    SQLCHAR		* SchemaName,
    SQLSMALLINT		  NameLength2,
    SQLCHAR		* TableName,
    SQLSMALLINT		  NameLength3,
    SQLCHAR		* ColumnName,
    SQLSMALLINT		  NameLength4);

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

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLCopyDesc (
    SQLHDESC		  SourceDescHandle,
    SQLHDESC		  TargetDescHandle);
#endif

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

SQLRETURN SQL_API SQLDescribeCol (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  ColumnNumber,
    SQLCHAR		* ColumnName,
    SQLSMALLINT		  BufferLength,
    SQLSMALLINT		* NameLength,
    SQLSMALLINT		* DataType,
    SQLULEN		* ColumnSize,
    SQLSMALLINT		* DecimalDigits,
    SQLSMALLINT		* Nullable);

SQLRETURN SQL_API SQLDisconnect (
    SQLHDBC		  ConnectionHandle);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLEndTran (
    SQLSMALLINT		  HandleType,
    SQLHANDLE		  Handle,
    SQLSMALLINT		  CompletionType);
#endif

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

SQLRETURN SQL_API SQLExecDirect (
    SQLHSTMT		  StatementHandle,
    SQLCHAR		* StatementText,
    SQLINTEGER		  TextLength);

SQLRETURN SQL_API SQLExecute (
    SQLHSTMT		  StatementHandle);

SQLRETURN SQL_API SQLFetch (
    SQLHSTMT		  StatementHandle);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLFetchScroll (
    SQLHSTMT		  StatementHandle,
    SQLSMALLINT		  FetchOrientation,
    SQLLEN		  FetchOffset);
#endif

SQLRETURN SQL_API SQLFreeConnect (
    SQLHDBC		  ConnectionHandle);

SQLRETURN SQL_API SQLFreeEnv (
    SQLHENV		  EnvironmentHandle);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLFreeHandle (
    SQLSMALLINT		  HandleType,
    SQLHANDLE		  Handle);
#endif

SQLRETURN SQL_API SQLFreeStmt (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  Option);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLGetConnectAttr (
    SQLHDBC		  ConnectionHandle,
    SQLINTEGER		  Attribute,
    SQLPOINTER		  Value,
    SQLINTEGER		  BufferLength,
    SQLINTEGER		* StringLength);
#endif

SQLRETURN SQL_API SQLGetConnectOption (
    SQLHDBC		  ConnectionHandle,
    SQLUSMALLINT	  Option,
    SQLPOINTER		  Value);

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

SQLRETURN SQL_API SQLGetData (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  ColumnNumber,
    SQLSMALLINT		  TargetType,
    SQLPOINTER		  TargetValue,
    SQLLEN		  BufferLength,
    SQLLEN		* StrLen_or_Ind);

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

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

SQLRETURN SQL_API SQLGetDiagField (
    SQLSMALLINT		  HandleType,
    SQLHANDLE		  Handle,
    SQLSMALLINT		  RecNumber,
    SQLSMALLINT		  DiagIdentifier,
    SQLPOINTER		  DiagInfo,
    SQLSMALLINT		  BufferLength,
    SQLSMALLINT		* StringLength);

SQLRETURN SQL_API SQLGetDiagRec (
    SQLSMALLINT		  HandleType,
    SQLHANDLE		  Handle,
    SQLSMALLINT		  RecNumber,
    SQLCHAR		* Sqlstate,
    SQLINTEGER		* NativeError,
    SQLCHAR		* MessageText,
    SQLSMALLINT		  BufferLength,
    SQLSMALLINT		* TextLength);

SQLRETURN SQL_API SQLGetEnvAttr (
    SQLHENV		  EnvironmentHandle,
    SQLINTEGER		  Attribute,
    SQLPOINTER		  Value,
    SQLINTEGER		  BufferLength,
    SQLINTEGER		* StringLength);
#endif /* ODBCVER >= 0x0300 */

SQLRETURN SQL_API SQLGetFunctions (
    SQLHDBC		ConnectionHandle,
    SQLUSMALLINT	FunctionId,
    SQLUSMALLINT *	Supported);

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

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLGetStmtAttr (
    SQLHSTMT		  StatementHandle,
    SQLINTEGER		  Attribute,
    SQLPOINTER		  Value,
    SQLINTEGER		  BufferLength,
    SQLINTEGER		* StringLength);
#endif /* ODBCVER >= 0x0300 */

SQLRETURN SQL_API SQLGetStmtOption (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  Option,
    SQLPOINTER		  Value);

SQLRETURN SQL_API SQLGetTypeInfo (
    SQLHSTMT		  StatementHandle,
    SQLSMALLINT		  DataType);

SQLRETURN SQL_API SQLNumResultCols (
    SQLHSTMT		  StatementHandle,
    SQLSMALLINT		* ColumnCount);

SQLRETURN SQL_API SQLParamData (
    SQLHSTMT		  StatementHandle,
    SQLPOINTER		* Value);

SQLRETURN SQL_API SQLPrepare (
    SQLHSTMT		  StatementHandle,
    SQLCHAR		* StatementText,
    SQLINTEGER		  TextLength);

SQLRETURN SQL_API SQLPutData (
    SQLHSTMT		  StatementHandle,
    SQLPOINTER		  Data,
    SQLLEN		  StrLen_or_Ind);

SQLRETURN SQL_API SQLRowCount (
    SQLHSTMT		  StatementHandle,
    SQLLEN		* RowCount);

#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLSetConnectAttr (
    SQLHDBC		  ConnectionHandle,
    SQLINTEGER		  Attribute,
    SQLPOINTER		  Value,
    SQLINTEGER		  StringLength);
#endif /* ODBCVER >= 0x0300 */

SQLRETURN SQL_API SQLSetConnectOption (
    SQLHDBC		  ConnectionHandle,
    SQLUSMALLINT	  Option,
    SQLULEN		  Value);

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

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

SQLRETURN SQL_API SQLSetDescRec (
    SQLHDESC		  DescriptorHandle,
    SQLSMALLINT		  RecNumber,
    SQLSMALLINT		  Type,
    SQLSMALLINT		  SubType,
    SQLLEN		  Length,
    SQLSMALLINT		  Precision,
    SQLSMALLINT		  Scale,
    SQLPOINTER		  Data,
    SQLLEN		* StringLength,
    SQLLEN		* Indicator);

SQLRETURN SQL_API SQLSetEnvAttr (
    SQLHENV		  EnvironmentHandle,
    SQLINTEGER		  Attribute,
    SQLPOINTER		  Value,
    SQLINTEGER		  StringLength);
#endif /* ODBCVER >= 0x0300 */


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLSetStmtAttr (
    SQLHSTMT		  StatementHandle,
    SQLINTEGER		  Attribute,
    SQLPOINTER		  Value,
    SQLINTEGER		  StringLength);
#endif

SQLRETURN SQL_API SQLSetStmtOption (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  Option,
    SQLULEN		  Value);

SQLRETURN SQL_API SQLSpecialColumns (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  IdentifierType,
    SQLCHAR		* CatalogName,
    SQLSMALLINT		  NameLength1,
    SQLCHAR		* SchemaName,
    SQLSMALLINT		  NameLength2,
    SQLCHAR		* TableName,
    SQLSMALLINT		  NameLength3,
    SQLUSMALLINT	  Scope,
    SQLUSMALLINT	  Nullable);

SQLRETURN SQL_API SQLStatistics (
    SQLHSTMT		  StatementHandle,
    SQLCHAR		* CatalogName,
    SQLSMALLINT		  NameLength1,
    SQLCHAR		* SchemaName,
    SQLSMALLINT		  NameLength2,
    SQLCHAR		* TableName,
    SQLSMALLINT		  NameLength3,
    SQLUSMALLINT	  Unique,
    SQLUSMALLINT	  Reserved);

SQLRETURN SQL_API SQLTables (
    SQLHSTMT		  StatementHandle,
    SQLCHAR		* CatalogName,
    SQLSMALLINT		  NameLength1,
    SQLCHAR		* SchemaName,
    SQLSMALLINT		  NameLength2,
    SQLCHAR		* TableName,
    SQLSMALLINT		  NameLength3,
    SQLCHAR		* TableType,
    SQLSMALLINT		  NameLength4);

SQLRETURN SQL_API SQLTransact (
    SQLHENV		  EnvironmentHandle,
    SQLHDBC		  ConnectionHandle,
    SQLUSMALLINT	  CompletionType);


/*
 *  Depreciated ODBC 1.0 function - Use SQLBindParameter
 */
SQLRETURN SQL_API SQLSetParam (
    SQLHSTMT		  StatementHandle,
    SQLUSMALLINT	  ParameterNumber,
    SQLSMALLINT		  ValueType,
    SQLSMALLINT		  ParameterType,
    SQLULEN		  LengthPrecision,
    SQLSMALLINT		  ParameterScale,
    SQLPOINTER		  ParameterValue,
    SQLLEN		* StrLen_or_Ind);

#ifdef __cplusplus
}
#endif

#endif	 /* _SQL_H */
libiodbc2-dev 3.52.7-3.1 / usr / include / sql.h
