Summary
ODBC (Open DataBase Connectivity) binding

Metadata

Tags:	database
Authors:	Chris Double, Alexander Ilin

Words

Tuple classes

Class	Superclass	Slots
column	tuple	nullable digits size type name number
field	tuple	value column
odbc-dbc-destructor	alien-destructor	disposed
odbc-env-destructor	alien-destructor	disposed
odbc-error	tuple	message
odbc-invalid-handle-error	tuple	message
odbc-statement-destructor	alien-destructor	disposed
odbc-statement-error	tuple	state native-code message

Symbol words

SQLCHAR

SQLHANDLE

SQLHDBC

SQLHDESC

SQLHENV

SQLHSTMT

SQLHWND

SQLINTEGER

SQLPOINTER

SQLRETURN

SQLSMALLINT

SQLUINTEGER

SQLUSMALLINT

SQL_BIGINT

SQL_BINARY

SQL_BIT

SQL_CHAR

SQL_CIRCULARSTRING

SQL_COMPOUNDCURVE

SQL_CURVEPOLYGON

SQL_DECIMAL

SQL_DOUBLE

SQL_FLOAT

SQL_FULLTEXT

SQL_FULLTEXTKEY

SQL_GEOMETRY

SQL_GEOMETRYCOLLECTION

SQL_GUID

SQL_INTEGER

SQL_INTERVAL_DAY

SQL_INTERVAL_DAY_TO_HOUR

SQL_INTERVAL_DAY_TO_MINUTE

SQL_INTERVAL_DAY_TO_SECOND

SQL_INTERVAL_HOUR

SQL_INTERVAL_HOUR_TO_MINUTE

SQL_INTERVAL_HOUR_TO_SECOND

SQL_INTERVAL_MINUTE

SQL_INTERVAL_MINUTE_TO_SECOND

SQL_INTERVAL_MONTH

SQL_INTERVAL_SECOND

SQL_INTERVAL_YEAR

SQL_INTERVAL_YEAR_TO_MONTH

SQL_LINESTRING

SQL_LONGVARBINARY

SQL_LONGVARCHAR

SQL_MULTILINESTRING

SQL_MULTIPOINT

SQL_MULTIPOLYGON

SQL_NUMERIC

SQL_POINT

SQL_POLYGON

SQL_REAL

SQL_SMALLINT

SQL_TINYINT

SQL_TYPE_DATE

SQL_TYPE_TIME

SQL_TYPE_TIMESTAMP

SQL_TYPE_UNKNOWN

SQL_TYPE_UTCDATETIME

SQL_TYPE_UTCTIME

SQL_UDT

SQL_VARBINARY

SQL_VARCHAR

SQL_WCHAR

SQL_WCHARVAR

SQL_WLONGCHARVAR

SQL_XML

Ordinary words

Word	Stack effect
(odbc-get-all-rows)	( statement -- )
<column>	( nullable digits size type name number -- column )
<field>	( value column -- field )
<odbc-dbc-destructor>	( env -- tuple )
<odbc-env-destructor>	( env -- tuple )
<odbc-statement-destructor>	( env -- tuple )
SQL-OV-ODBC2	( -- number )
SQL-OV-ODBC3	( -- number )
SQLAllocConnect	( environmentHandle connectionHandlePtr -- SQLRETURN )
SQLAllocEnv	( environmentHandlePtr -- SQLRETURN )
SQLAllocHandle	( handleType inputHandle outputHandlePtr -- SQLRETURN )
SQLAllocStmt	( connectionHandle statementHandlePtr -- SQLRETURN )
SQLBindCol	( statementHandle columnNumber targetType targetValuePtr bufferLength strlen_or_indPtr -- SQLRETURN )
SQLBindParam	( statementHandle parameterNumber valueType parameterType lengthPrecision parameterScale parameterValuePtr indPtr -- SQLRETURN )
SQLBindParameter	( statementHandle parameterNumber inputOutputType valueType parameterType columnSize decimalDigits parameterValuePtr bufferLength indPtr -- SQLRETURN )
SQLBrowseConnect	( connectionHandle inConnectionString stringLength outConnectionString bufferLength stringLength2Ptr -- SQLRETURN )
SQLBulkOperations	( statementHandle operation -- SQLRETURN )
SQLCancel	( statementHandle -- SQLRETURN )
SQLCloseCursor	( statementHandle -- SQLRETURN )
SQLColAttribute	( statementHandle columnNumber fieldIdentifier characterAttributePtr bufferLength stringLengthPtr numericAttributePtr -- SQLRETURN )
SQLColAttributes	( statementHandle columnNumber fieldIdentifier characterAttributePtr bufferLength stringLengthPtr numericAttributePtr -- SQLRETURN )
SQLColumnPrivileges	( statementHandle catalogName nameLength1 schemaName nameLength2 tableName nameLength3 columnName nameLength4 -- SQLRETURN )
SQLColumns	( statementHandle catalogName nameLength1 schemaName nameLength2 tableName nameLength3 columnName nameLength4 -- SQLRETURN )
SQLConnect	( connectionHandle serverName nameLength1 userName nameLength2 authentication nameLength3 -- SQLRETURN )
SQLCopyDesc	( sourceDescHandle targetDescHandle -- SQLRETURN )
SQLDataSources	( environmentHandle direction serverName bufferLength1 nameLength1Ptr description bufferLength2 nameLength2Ptr -- SQLRETURN )
SQLDescribeCol	( statementHandle columnNumber columnName bufferLength nameLengthPtr dataTypePtr columnSizePtr decimalDigitsPtr nullablePtr -- SQLRETURN )
SQLDescribeParam	( statementHandle parameterNumber dataTypePtr parameterSizePtr decimalDigitsPtr nullablePtr -- SQLRETURN )
SQLDisconnect	( connectionHandle -- SQLRETURN )
SQLDriverConnect	( connectionHandle windowHandle inConnectionString stringLength outConnectionString bufferLength stringLength2Ptr driverCompletion -- SQLRETURN )
SQLEndTran	( handleType handle completionType -- SQLRETURN )
SQLError	( environmentHandle connectionHandle statementHandle sqlState nativeErrorPtr messageText bufferLength textLengthPtr -- SQLRETURN )
SQLExecDirect	( statementHandle statementText textLength -- SQLRETURN )
SQLExecute	( statementHandle -- SQLRETURN )
SQLExtendedFetch	( statementHandle fetchType fetchOffset rowCountPtr rowStatusArray -- SQLRETURN )
SQLFetch	( statementHandle -- SQLRETURN )
SQLFetchScroll	( statementHandle fetchOrientation fetchOffset -- SQLRETURN )
SQLForeignKeys	( statementHandle pkCatalogName nameLength1 pkSchemaName nameLength2 pkTableName nameLength3 fkCatalogName nameLength4 fkSchemaName nameLength5 fkTableName nameLength6 -- SQLRETURN )
SQLFreeConnect	( connectionHandle -- SQLRETURN )
SQLFreeEnv	( environmentHandle -- SQLRETURN )
SQLFreeHandle	( handleType handle -- SQLRETURN )
SQLFreeStmt	( statementHandle option -- SQLRETURN )
SQLGetConnectAttr	( connectionHandle attribute valuePtr bufferLength stringLengthPtr -- SQLRETURN )
SQLGetConnectOption	( connectionHandle option valuePtr -- SQLRETURN )
SQLGetCursorName	( statementHandle cursorName bufferLength nameLengthPtr -- SQLRETURN )
SQLGetData	( statementHandle columnNumber targetType targetValuePtr bufferLength strlen_or_indPtr -- SQLRETURN )
SQLGetDescField	( descriptorHandle recNumber fieldIdentifier valuePtr bufferLength stringLengthPtr -- SQLRETURN )
SQLGetDescRec	( descriptorHandle recNumber name bufferLength stringLengthPtr typePtr subTypePtr lengthPtr precisionPtr scalePtr nullablePtr -- SQLRETURN )
SQLGetDiagField	( handleType handle recNumber diagIdentifier diagInfoPtr bufferLength stringLengthPtr -- SQLRETURN )
SQLGetDiagRec	( HandleType Handle RecNumber SQLState NativeErrorPtr MessageText BufferLength TextLengthPtr -- SQLRETURN )
SQLGetEnvAttr	( environmentHandle attribute valuePtr bufferLength stringLengthPtr -- SQLRETURN )
SQLGetFunctions	( connectionHandle functionId supportedPtr -- SQLRETURN )
SQLGetInfo	( connectionHandle infoType infoValuePtr bufferLength stringLengthPtr -- SQLRETURN )
SQLGetStmtAttr	( statementHandle attribute valuePtr bufferLength stringLengthPtr -- SQLRETURN )
SQLGetStmtOption	( statementHandle option valuePtr -- SQLRETURN )
SQLGetTypeInfo	( statementHandle dataType -- SQLRETURN )
SQLMoreResults	( statementHandle -- SQLRETURN )
SQLNativeSql	( connectionHandle inStatementText textLength1 outStatementText bufferLength textLength2Ptr -- SQLRETURN )
SQLNumParams	( statementHandle parameterCountPtr -- SQLRETURN )
SQLNumResultCols	( statementHandle columnCountPtr -- SQLRETURN )
SQLParamData	( statementHandle valuePtrPtr -- SQLRETURN )
SQLParamOptions	( statementHandle rowCount rowsProcessedPtr -- SQLRETURN )
SQLPrepare	( statementHandle statementText length -- SQLRETURN )
SQLPrimaryKeys	( statementHandle catalogName nameLength1 schemaName nameLength2 tableName nameLength3 -- SQLRETURN )
SQLProcedureColumns	( statementHandle catalogName nameLength1 schemaName nameLength2 procName nameLength3 columnName nameLength4 -- SQLRETURN )
SQLProcedures	( statementHandle catalogName nameLength1 schemaName nameLength2 procName nameLength3 -- SQLRETURN )
SQLPutData	( statementHandle dataPtr stringLength -- SQLRETURN )
SQLRowCount	( statementHandle rowCountPtr -- SQLRETURN )
SQLSetConnectAttr	( connectionHandle attribute valuePtr stringLength -- SQLRETURN )
SQLSetConnectOption	( connectionHandle option value -- SQLRETURN )
SQLSetCursorName	( statementHandle cursorName nameLength -- SQLRETURN )
SQLSetDescField	( descriptorHandle recNumber fieldIdentifier valuePtr bufferLength -- SQLRETURN )
SQLSetDescRec	( descriptorHandle recNumber type subType length precision scale dataPtr stringLengthPtr indicatorPtr -- SQLRETURN )
SQLSetEnvAttr	( environmentHandle attribute valuePtr stringLength -- SQLRETURN )
SQLSetParam	( statementHandle parameterNumber valueType parameterType lengthPrecision parameterScale parameterValuePtr indPtr -- SQLRETURN )
SQLSetPos	( statementHandle rowNumber operation lockType -- SQLRETURN )
SQLSetScrollOptions	( statementHandle concurrency rowNumber cacheSize -- SQLRETURN )
SQLSetStmtAttr	( statementHandle attribute valuePtr stringLength -- SQLRETURN )
SQLSetStmtOption	( statementHandle option value -- SQLRETURN )
SQLSpecialColumns	( statementHandle identifierType catalogName nameLength1 schemaName nameLength2 tableName nameLength3 scope nullable -- SQLRETURN )
SQLStatistics	( statementHandle catalogName nameLength1 schemaName nameLength2 tableName nameLength3 unique reserved -- SQLRETURN )
SQLTablePrivileges	( statementHandle catalogName nameLength1 schemaName nameLength2 tableName nameLength3 -- SQLRETURN )
SQLTables	( statementHandle catalogName nameLength1 schemaName nameLength2 tableName nameLength3 tableType nameLength4 -- SQLRETURN )
SQL_ATTR_CONNECTION_TIMEOUT	( -- value )
SQL_ATTR_ODBC_VERSION	( -- value )
SQL_ATTR_QUERY_TIMEOUT	( -- value )
SQL_CLOSE	( -- value )
SQL_COMMIT	( -- value )
SQL_C_DEFAULT	( -- value )
SQL_DRIVER_NOPROMPT	( -- value )
SQL_DRIVER_PROMPT	( -- value )
SQL_DROP	( -- value )
SQL_ERROR	( -- value )
SQL_FETCH_ABSOLUTE	( -- value )
SQL_FETCH_BOOKMARK	( -- value )
SQL_FETCH_FIRST	( -- value )
SQL_FETCH_LAST	( -- value )
SQL_FETCH_NEXT	( -- value )
SQL_FETCH_PRIOR	( -- value )
SQL_FETCH_RELATIVE	( -- value )
SQL_HANDLE_DBC	( -- value )
SQL_HANDLE_DESC	( -- value )
SQL_HANDLE_ENV	( -- value )
SQL_HANDLE_STMT	( -- value )
SQL_INVALID_HANDLE	( -- value )
SQL_MAX_MESSAGE_LENGTH	( -- value )
SQL_NO_DATA	( -- value )
SQL_NO_DATA_FOUND	( -- value )
SQL_NTS	( -- value )
SQL_NULL_HANDLE	( -- value )
SQL_RESET_PARAMS	( -- value )
SQL_ROLLBACK	( -- value )
SQL_SQLSTATE_SIZE	( -- value )
SQL_SUCCESS	( -- value )
SQL_SUCCESS_WITH_INFO	( -- value )
SQL_UNBIND	( -- value )
alloc-dbc-handle	( env -- handle )
alloc-env-handle	( -- handle )
alloc-handle	( type parent -- handle )
alloc-stmt-handle	( dbc -- handle )
check-odbc	( retcode message -- )
check-statement	( retcode hstmt -- )
convert-sql-type	( number -- symbol )
dereference-type-pointer	( byte-array column -- object )
odbc-connect	( env dsn -- dbc )
odbc-describe-column	( statement columnNumber -- column )
odbc-disconnect	( dbc -- )
odbc-error	( message -- * )
odbc-execute	( statement -- )
odbc-free-env	( henv -- )
odbc-free-statement	( statement -- )
odbc-get-all-rows	( statement -- seq )
odbc-get-field	( statement column! -- field )
odbc-get-row-fields	( statement -- seq )
odbc-init	( -- env )
odbc-invalid-handle-error	( message -- * )
odbc-next-row	( statement -- bool )
odbc-number-of-columns	( statement -- number )
odbc-prepare	( dbc string -- statement )
odbc-queries	( dsn strings -- results )
odbc-query	( dsn string -- result )
odbc-statement-error	( state native-code message -- * )
set-odbc-version	( env-handle -- )
succeeded?	( n -- bool )
temp-string	( length -- byte-array length )
throw-diag-odbc-error	( handle-type hstmt -- * )
throw-env-error	( henv -- obj )
throw-statement-error	( hstmt -- * )

Class predicate words

Word	Stack effect
column?	( object -- ? )
field?	( object -- ? )
odbc-dbc-destructor?	( object -- ? )
odbc-env-destructor?	( object -- ? )
odbc-error?	( object -- ? )
odbc-invalid-handle-error?	( object -- ? )
odbc-statement-destructor?	( object -- ? )
odbc-statement-error?	( object -- ? )

Files


Metadata files


Children

Vocabulary	Summary
odbc.64
odbc.private