odbc vocabulary
Factor handbook ยป Vocabulary index


Summary
ODBC (Open DataBase Connectivity) binding

Metadata
Tags:database
Authors:Chris Double, Alexander Ilin


Words

Tuple classes
ClassSuperclassSlots
column tuplenullable digits size type name number
field tuplevalue column
odbc-dbc-destructor alien-destructordisposed
odbc-env-destructor alien-destructordisposed
odbc-error tuplemessage
odbc-invalid-handle-error tuplemessage
odbc-statement-destructor alien-destructordisposed
odbc-statement-error tuplestate 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
WordStack 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
WordStack 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
VocabularySummary
odbc.64
odbc.private