Microsoft Word - FRONT3.DOC
|
|
- このか たておか
- 7 years ago
- Views:
Transcription
1 ODBC Interface Reference
2 disclaimer trademarks PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN AS ISBASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT. PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURPOSE OR ARISING FROM COURCE OF DEALING OR USAGE OF TRADE, AMONG OTHERS. Btrieve and XQL are registered trademarks of Pervasive Software Inc. Scalable SQL, MicroKernel Database Engine, MicroKernel Database Architecture, Navigational Client/Server, Built on Btrieve, Built on Scalable SQL, Xtrieve PLUS, and Client/Server in a box are trademarks of Pervasive Software Inc. Microsoft, MS-DOS, Windows, Windows NT, Win32, Win32s, and Visual Basic are registered trademarks of Microsoft Corporation. Windows 95 is a trademark of Microsoft Corporatoin. NetWare and Novell are registered trademarks of Novell, Inc. NetWare Loadable Module, NLM, Novell DOS, Transaction Tracking System, and TTS are trademarks of Novell, Inc. All company and product names are the trademarks or registered trademarks of their respective companies. Copyright 1998 Pervasive Software Inc. All rights reserved. Reproduction, photocopying, or transmittal of this publication, or portions of this publication, is prohibited without the express prior written consent of the publisher, unless such reproduction, photocopying, or transmittal is part of a Derivative Software Product as defined in the licenses granted in conjunction with the purchase of this publication and associated software. Pervasive Software Inc Capital of Texas Highway Austin, Texas U.S.A. ODBC Interface Reference Manual March 1998
3 ... ix...x 1 ODBC ODBC Interface v Windows NT Windows Microsoft Visual Basic v4.0 Enterprise Edition Scalable SQL v SQLSetPos SQLForeignKeys SQLDescribeParam SQLParamOptions ODBC () SQLMoreResults SQLExtendedFetch OEM SQL ODBC ODBC Interface / ODBC ODBC iii
4 WindowsWindows 95 Windows NT ODBC Interface 1-10 ODBC SQL API ODBC Interface Scalable SQL for Windows Btrieve for Windows Scalable SQL for Windows NT/Windows 95 v3.01 v4.0 Btrieve for Windows NT/Windows ODBC Interface (Windows NTWindows 95 Windows v3.1) ODBC Interface Windows v Windows NT v Windows NT v4.0 Windows BTI.INI ODBC Interface Windows NT Windows Windows v ODBC ODBC SQL SQL ODBC SQL ivodbc Interface Reference Manual
5 SQL Null ODBC AUTOINC NOTE LVAR ODBC SQLGetInfo SQLDriverConnect DDF ODBC () SQLRowCount SQLMoreResults SQLSetPos SQL SQLExtendedFetch OEM A ODBC ODBC Scalable SQL... A-1 SQLSetConnectOption SQLGetConnectOption... A-2 Option 1000: ODBC Interface... A-3... A-3 v
6 ... A-4... A-4 SQLGetConnectOption... A-4... A-5... A-5 Option 1001:... A-5... A-5... A-7... A-7 Option 1002: ID... A-7... A-7 ID... A-7... A-8 Option 1003: (Windows v3.1 )... A-8... A-8... A-9... A-10 SQLSetConnectOption... A A A-10 Option 1004:... A A A A-12 Option 1005:... A A A A-13 Option 1006:... A A A A-15 Option 1007:... A A-15 viodbc Interface Reference Manual
7 ... A A-16 B...B-1 SQL.H SQLEXT.H...B-1 ODBC.LIB...B-2 ODBC32.LIB...B-2 C/C++...B-2 C/C++...B-3...B-3 B-1C (ODBCSAMP.C)...B-4 vii
8 1-1Scalable SQL Scalable SQL Scalable SQL/Btrieve ODBC SQLGetInfo SQLDriverConnect A-1C... A-2 A-2SQLSetConnectOption SQLGetConnectOption... A-2 A-3Option 1000 SQLSetConnectOption... A-4 A-4Option 1001 SQLGetConnectOption... A-5 A-5SQLGetConnectOption Version... A-6 A-6Option 1002 SQLGetConnectOption... A-7 A-7Option 1003 SQLSetConnectOption... A-8 A-8SQLSetConnectOption Callback... A-9 A-9Option 1004 SQLGetConnectOption... A-11 A-10SQLGetConnectOption Convert... A-11 A-11Option 1005 SQLGetConnectOption... A-13 A-12SQLGetConnectOption Mask Validation A-13 A-13Option 1006 SQLGetConnectOption... A-14 viiiodbc Interface Reference Manual
9 A-14SQLGetConnectOption Default Mask Retrieval... A-14 A-15Option 1007 SQLGetConnectOption... A-15 A-16SQLGetConnectOption Value Validation... A-16 ix
10 Scalable SQL Btrieve API ODBC Interface ODBC API (Open Database Connectivity Applications Programming Interface) 1 ODBC Scalable SQL Btrieve API ODBC Interface ODBC API (Open Database Connectivity Applications Programming Interface) ODBC Interface 2 ODBC SQL ODBC (Open Database Connectivity) SQL 3 ODBC ODBC Interface ODBC API AODBC ODBC Interface ODBC API Scalable SQL Btrieve B ODBC API ODBC Interface C xi
11 MYPROGmyprog Myprog [ ] [logname] < > /D=<5 6 7> variable filename... [parameter...] (...) ::= ::= a::=b a b xiiodbc Interface Reference Manual
12 1 ODBC Btrieve Scalable SQL API (Applications Programming Interface) ODBC Interface ODBC (Open Database Connectivity) API ODBC Interface v2.0 ODBC ODBC Interface ODBC ODBC Interface ODBC ODBC ODBC Interface v2.0 ODBC Interface 2.0 Windows NT Windows Microsoft Visual Basic v4.0 Enterprise Edition Scalable SQL v4.0 SQLSetPos SQLForeignKeys ODBC 1-1
13 SQLDescribeParam SQLParamOptions ODBC () SQLMoreResults SQLExtendedFetch OEM SQL Windows NT Windows ODBC Interface v1.0 for Windows 95 Windows NT 16 Windows NT Thunking ODBC Interface v Windows 95 Windows NT (Windows NT v3.51 v4.0) ODBC Interface v2.0 ODBC () 1 ODBC Interface ( 1 ODBC ) ODBC Interface 1-2ODBC Interface Reference Manual
14 ODBC API 1 ODBC Interface v2.0 Microsoft Access Visual Basic Visual FoxProBorland DelphiReportSmith Powersoft PowerBuilder ODBC ODBC Interface v1.0 ODBC Interface v2.0 Microsoft Foundation Classes (MFC) v3.0 Microsoft Visual C++ v4.0 C ODBC Microsoft Visual Basic v4.0 Enterprise Edition Microsoft Visual Basic v4.0 Enterprise Edition ODBC Interface Visual Basic RDO (Remote Data Objects) RDC (Remote Data Control) Visual Basic Jet (Joint Engine Technology) Jet RDC RDO Jet RDO DBMS / RDO Scalable SQL v3.01 v4.0 Btrieve Scalable SQL ODBC 1-3
15 Scalable SQL v4.0 Scalable SQL v4.0 ODBC Interface v2.0 Scalable SQL v4.0 ODBC Interface v2.0 INTEGER(8) UNSIGNED(1, 2, 4, 8) CURRENCY TIMESTAMP 2 ODBC SQL Scalable SQL v4.0 SQLSetPos SQLSetPos SQLSetPos SQLSetPos 3 ODBC 1-4ODBC Interface Reference Manual
16 3 ODBC SQLForeignKeys (Referential Integrity) SQLForeignKeys SQLForeignKeys SQLDescribeParam SQLDescribeParam SQLDescribeParam SQL SQLDescribeParam (ODBC ) SQLParamOptions ODBC Interface v2.0 SQLParamOptions ODBC 2 SQLBindParameter 3 ODBC ODBC () ODBC (Scalable SQL ) ODBC ODBC 1-5
17 SELECT 3 ODBC SQLMoreResults SQLMoreResults SQLMoreResults SELECT UPDATEINSERT DELETE SQLExtendedFetch ODBC Interface SQL_FETCH_RELATIVE SQL_FETCH_ ABSOLUTE SQLExtendedFetch OEM ODBC Interface DLL ANSI OEM SQLSetConnectOption SQL SQL SELECT SELECT... FOR UPDATE OF <columns> SQLExtendedFetch SQLSetPos UPDATE... WHERE CURRENT OF <cursor-name> DELETE... WHERE CURRENT OF <cursor-name> 1-6ODBC Interface Reference Manual
18 ODBC ODBC (Open Database Connectivity) Microsoft SAG CLI (SQL Access Groups Call Level Interface) ODBC SAG CLIX/Open ANSI SQL-92 ODBC Microsoft ODBC 2.0 SDK (Microsoft Press) ODBC ODBC SQL ODBC Interface / ODBC Interface 2 / ODBC ODBC Interface / 2 Microsoft WindowsWindows 95Windows NT Windows NT NetWare MicroKernel Database 2 SQL ODBC Interface MicroKernel Database ODBC Interface Scalable SQL / ODBC Interface Scalable SQL SQL ODBC Interface CPU ODBC 1-7
19 Scalable SQL ODBC Interface MicroKernel Database SQL Btrieve MicroKernel Database Scalable SQL 1-2 Scalable SQL 1-8ODBC Interface Reference Manual
20 ODBC Microsoft WindowsWindows 95 Windows NT MicroKernel Database ODBC Interface MicroKernel Database / MicroKernel MicroKernel Database ODBC 1-9
21 WindowsWindows 95 Windows NT ODBC Interface ODBC Interface v2.0 for Windows NT/Windows 95 (W32BTINT.DLL) Windows NT/Windows 95 Windows NT Windows 95 ODBC ODBC32.DLL 16 ODBC Thunking 16 Windows ODBC Interface v2.0 for Windows (WINBTINT.DLL) Windows ODBC ODBC.DLL ODBC ODBC API SQL ODBC ODBC ODBC SQL ODBC SQL ODBC Interface SQL ODBC SQL SQL ODBC Interface MicroKernel Database Microsoft DBMS ODBC ODBC SQL ODBC Interface SQL ODBC SQL ODBC Interface SQL 1-10ODBC Interface Reference Manual
22 API SQL ODBC Interface SQL ODBC 1 API 2 2 SQLColumnPrivileges SQLDataSources SQLExtendedFetch (firstnextlastprevious ) SQLMoreResults SQLNativeSql SQLNumParams SQLParamOptions SQLPrimaryKeys SQLTablePrivileges SQLSetScrollOptions SQLSetPos SQLDescribeParam SQLForeignKeys (RI) 2 SQLBrowseConnect SQLProcedures SQLProcedureColumns ODBC 1-11
23 ODBC Interface v2.0 ODBC Interface ODBC Interface CPU ODBC Interface v2.0 for Windows 8MB RAM (12MB RAM ) ODBC Interface v2.0 for Windows NT/Windows 95 16MB RAM (20MB RAM ) 5MB ODBC Interface v2.0 for Windows PC-DOS MS-DOS v5.0 Windows v3.1 /Scalable SQL Scalable SQL v3.01 v4.0 Btrieve Btrieve v6.15 Scalable SQL for Windows v3.01 v4.0 Btrieve for Windows v6.15 ODBC Interface v2.0 for Windows NT/Windows 95 Windows NT v3.51 v4.0 Windows 95 /Scalable SQL Scalable SQL v3.01 v4.0 Btrieve Btrieve v ODBC Interface Reference Manual
24 Scalable SQL for Windows NT/Windows 95 v3.01 v4.0 Btrieve for Windows NT/Windows 95 v6.15 Scalable SQL for Windows Btrieve for Windows ODBC Interface for Windows Scalable SQL for Windows v3.01 v4.0 Btrieve for Windows v6.15 Scalable SQL Btrieve Scalable SQL ODBC Interface ODBC Scalable SQL Btrieve ODBC Interface ODBC ODBC Interface v2.0 MicroKernel Database Scalable SQL for Windows NT/Windows 95 v4.0 Btrieve for Windows NT/Windows 95 ODBC Interface v2.0 for Windows NT/Windows 95 Btrieve for Windows NT/Windows 95 v6.15 Scalable SQL for Windows NT/Windows 95 v4.0 Btrieve for Windows NT/Windows 95 Scalable SQL v4.0 ODBC Interface ODBC ODBC Interface v2.0 MicroKernel Database /ODBC Interface ODBC 1-13
25 ODBC Interface Scalable SQL for Windows Windows v3.1windows 95 Windows NT Scalable SQL Btrieve (SQLScope Scalable SQL v4.0 Monitor ) ODBC Interface ODBC Interface ODBC Interface ODBC MicroKernel Database (Windows NTWindows 95 Windows v3.1) 16 Windows ODBC Interface for Windows BTI.INI (Pervasive Software ) ODBCINST.INI ( ODBC ) ODBC.INI () Windows 95 Windows NT ODBC Scalable SQL for Windows NT/Windows 95 v3.01 v4.0 Btrieve for Windows NT/Windows 95 v6.15 Scalable SQL Btrieve 1-14ODBC Interface Reference Manual
26 ODBC Interface ODBC Interface Windows v3.1 ODBC Interface Scalable SQL Btrieve ( BTI) Windows SYSTEM 1. Scalable SQL Btrieve 2. Disk 1 3. [] - [] [] - [ ] X: setup X 4. [OK] ODBC Interface Windows NT v3.51 ODBC Interface Scalable SQL Btrieve ( BTI) Windows SYSTEM 1. Scalable SQL Btrieve 2. Disk 1 ODBC 1-15
27 3. [] - [] [] - [ ] 4. X: setup X 5. [OK] ODBC Interface Windows NT v4.0 Windows 95 ODBC Interface Scalable SQL Btrieve ( Program Files BTI Win32) Windows SYSTEM 1. Scalable SQL Btrieve 2. Disk 1 3. [] - [] 4. X: setup X 5. [OK] ODBC Interface BTI.INI Windows BTI.INI BTI.INI 1-16ODBC Interface Reference Manual
28 () [Scalable SQL Engine] max expression length=4096 external sort path=<default Windows directory> Microsoft Access ODBC Interface 849 Scalable SQL Setup Max Expression Length [Btrieve Client] trnfile=<default Windows directory> [Scalable SQL] local=yes requester=no allow Callbacks=Yes tasks 5 5 [Scalable SQL] tasks=5 logins 3 3 [Scalable SQL] logins=3 BTI.INI DBNAMES.CFG DBNAMES.CFG Windows Scalable SQL Scalable SQL for NetWare v3.01 NetWare SQLTables NetWare Scalable SQL Setup Maximum Message Length Scalable SQL for NetWare v4.0 Scalable SQL Setup Communications Buffer Size 32KB ODBC 1-17
29 Windows v3.1 ODBC Interface CTL3DV2.DLL Windows SYSTEM DLL Windows (Microsoft Office ) [] [] [Pervasive Software ODBC Interface] [OK] [Pervasive Software ODBC Interface] (Windows ) [Pervasive Software ODBC Interface for Windows NT/Windows 95] ODBC Interface Windows SYSTEM ODBC ODBC Interface Pervasive Software WIN BIN WindowsSYSTEM PATH AUTOEXEC.BAT PATH ODBC Interface PATH ODBC [Pervasive Software Database] [ODBC Interface Help] / Scalable SQL Scalable SQL Scalable SQL ODBC Interface MicroKernel Database ODBC Interface Reference Manual
30 ODBC Interface ODBC Interface Windows NT Windows 95 Windows NT Windows 95 ODBC Interface v ODBC Interface 2. [Pervasive Software Database] 3. Windows ODBC Interface : a. Windows NT v4.0 Windows 95 REGEDIT Windows NT v3.51 REGEDT32 b. HKEY_LOCAL_MACHINE LOCALMACHINE () c. SOFTWARE ODBC ODBCINST.INI [] - [] [ ] - [] d. ODBC Drivers ODBC 1-19
31 e. Pervasive Software ODBC-32 f. Pervasive Software ODBC-32 Pervasive Software OEM to ANSI g. REGEDIT REGEDT32 4. ODBC Administrator [] [Pervasive Software ODBC-32] 5. SOFTWARE/ODBC/ODBCINST.INI ODBC Windows v3.1 Windows v3.1 ODBC Interface v [Pervasive Software Database] ODBC Administrator 2. [] [] 3. [ ODBC ] [Pervasive Software ODBC Interface for Windows] ODBC Interface MicroKernel Database ODBC 1-20ODBC Interface Reference Manual
32 .DDF.DDF ODBC ODBC Interface [] (') 1. [Pervasive Software Database] 2. Windows v3.1 [ODBC Administrator] Windows NT Windows 95 [32bit ODBC Administrator] 3. [] [] 4. [] [ ODBC ] [Pervasive Software ODBC Interface] [OK] 5. [ODBC Interface] [OK] (.DDF ) ODBC 1-21
33 1. [Pervasive Software Database] 2. Windows v3.1 [ODBC Administrator] Windows NT Windows 95 [32bit ODBC Administrator] 3. [] [] [] 4. [ODBC Interface] [OK] 1. [Pervasive Software Database] 2. Windows v3.1 [ODBC Administrator] Windows NT Windows 95 [32bit ODBC Administrator] 3. [] [] [] 4. [] ODBC ODBC ODBC ODBC Interface Scalable SQL Scalable SQL Scalable SQL Scalable SQL 1-22ODBC Interface Reference Manual
34 Scalable SQL ODBC Interface Scalable SQL v3.01 Scalable SQL Btrieve ODBC ODBC Microsoft Access Microsoft Office ODBC ODBC 1. [] ( ) 2. [] () [] 3. DDF ( ) [DB ] 4. [OK] ODBC ODBC ODBC 1-23
35 2 ODBC SQL ODBC (Open Database Connectivity) SQL ODBC Interface SQL ODBC C ODBC ODBC Interface SQL SQL ODBC SQL Microsoft ODBC 2.0 SDK SQL ODBC SQL SQL ODBC Interface SQL ODBC SQL SQL ODBC v4.0 Scalable SQL ODBC SQL NOT Scalable SQL NOT ODBC Scalable SQL ODBC SQL 2-1
36 ODBC SQL Microsoft Access SELECT DISTINCTROW ODBC Scalable SQL DISTINCTROW DISTINCT SQL ODBC Scalable SQL SQL SQL SQL ODBC Interface ODBC Scalable SQL Scalable SQL Scalable SQL ODBC SQL ODBC Interface SQL ODBC SQL Scalable SQL Btrieve ODBC Interface SQL 2 CREATE TABLE T1 (Key INT(4), Memorandum NOTE(1000)) CREATE TABLE T2 (Key INT(4), Earned^value INT(4)) SELECT SELECT * FROM T1, T2 WHERE T1.Key = T2.Key 2-2ODBC Interface Reference Manual
37 T1 NOTE NOTE SELECT * FROM T2, T1 WHERE T1.Key = T2.Key (*) SELECT T1.Key, Earned^value, Memorandum FROM T1, T2 WHERE T1.Key = T2.Key ODBC SQL ODBC Interface DDF CREATE INDEX ODBC Interface SQL DROP INDEX Patients.FirstLast SQL DROP INDEX FirstLast Btrieve v6.15 DROP INDEX ODBC SQL 2-3
38 2-1 / CONCAT LCASE LEFT LENGTH LTRIM RIGHT RTRIM SUBSTRING UCASE ROUND TRUNCATE CURDATE CURTIME DAYOFMONTH DAYOFWEEK HOUR MINUTE MONTH SECOND YEAR NOW (Scalable SQL v4.0 ) LENGTH SUBSTRING NUMERIC DECIMAL SQL SQL ODBC SQL Microsoft ODBC 2.0 SDK ODBC SELECT {fn LCASE(keycol1)} FROM table1 () (_) SET BLANK = '_' SELECT {fn LCASE(first_name)} FROM PATIENTS SET BLANK = '^' 2-4ODBC Interface Reference Manual
39 ODBC Interface Scalable SQL Btrieve ODBC SQL Scalable SQL Btrieve Scalable SQL Btrieve ODBC SQL ODBC Interface SQL Scalable SQL v3.01 UNSIGNED BINARY Btrieve Scalable SQL v4.0 Btrieve Scalable SQL v4.0 v3.01 Null Scalable SQL/Btrieve Null WHERE COL1 IS NULL COL1 Null False Null WHERE HAVING IS NULL IS NOT NULL 2-2 Scalable SQL/Btrieve ODBC Scalable SQL/Btrieve ODBC CREATE TABLE Null AUTOINC(2) SQL_SMALLINT AUTOINC(2) AUTOINC(4) SQL_INTEGER AUTOINC(4) BFLOAT(4) SQL_REAL BFLOAT(4) BFLOAT(8) SQL_DOUBLE BFLOAT(8) BIT SQL_BIT ODBC SQL 2-5
40 Scalable SQL/Btrieve ODBC CREATE TABLE Null CHAR (Btrieve STRING) SQL_CHAR CURRENCY* SQL_BIGINT CURRENCY DATE SQL_DATE DECIMAL SQL_DECIMAL FLOAT(4) SQL_REAL FLOAT(4) FLOAT(8) SQL_FLOAT SQL_DOUBLE FLOAT(8) INT(1) SQL_TINYINT INT(1) INT(2) SQL_SMALLINT INT(2) INT(4) SQL_INTEGER INT(4) INT(8)* SQL_BIGINT INT(8) LOGICAL(1) SQL_BIT LOGICAL(1) LOGICAL(2) SQL_SMALLINT LOGICAL(2) LSTRING SQL_VARCHAR LVAR SQL_LONGVARBINARY MONEY SQL_DECIMAL NOTE SQL_LONGVARCHAR NUMERIC SQL_NUMERIC NUMERICSA (Btrieve NUMERIC SIGNED ASCII) NUMERICSTS (Btrieve NUMERIC SIGNED TRAILING SEPARATE) SQL_NUMERIC SQL_NUMERIC TIME SQL_TIME TIMESTAMP* SQL_TIMESTAMP UNSIGNED(1)* SQL_TINYINT UNSIGNED(1) UNSIGNED(2)* SQL_SMALLINT UNSIGNED(2) UNSIGNED(4)* SQL_INTEGER UNSIGNED(4) UNSIGNED(8)* SQL_BIGINT UNSIGNED(8) ZSTRING SQL_VARCHAR 2-6ODBC Interface Reference Manual
41 (*) Scalable SQL v4.0 Microsoft ODBC 2.0 SDK D ODBC SQL ODBC AUTOINC AUTOINC SQL_INTEGER SQL_SMALLINT AUTOINC INSERT UPDATE Scalable SQL Btrieve Scalable SQL AUTOINC AUTOINC AUTOINC UPDATE NOTE LVAR Scalable SQL Btrieve NOTE LVAR 1 1 CREATE TABLE SELECT ODBC SQL 2-7
42 3 ODBC ODBC Interface ODBC API SQLGetInfo SQLDriverConnect ODBC () SQLSetPos SQL SQLExtendedFetch OEM ODBC API Microsoft ODBC Software Development Kit v2.10 (16 ) v2.5 (32 ) Watcom C/C++Microsoft Visual C++Symantec C++Borland C++ C C++ ODBC Interface for Windows NT/Windows 95 Windows NT Windows 95 ODBC 3-1
43 SQLGetInfo 3-1 finfotype C #define ODBC Interface SQLGetInfo ( 3-1 ) finfotype SQLGetInfo finfotype (SQL_MAX_TABLES _IN_SELECT ) finfotype Microsoft ODBC 2.0 SDK (Microsoft Press) 3-1 SQLGetInfo finfotype (#define) SQL_ACTIVE_CONNECTIONS SQL_ACTIVE_STATEMENTS SQL_DATA_SOURCE_NAME SQL_DRIVER_HDBC SQL_DRIVER_HENV SQL_DRIVER_HSTMT SQL_DRIVER_NAME SQL_DRIVER_VER SQL_FETCH_DIRECTION SQL_ODBC_API_CONFORMANCE SQL_ODBC_VER SQL_ROW_UPDATES Scalable SQL Setup 0 ODBC Interface for Windows "WINBTINT.DLL" ODBC Interface for Windows NT/Windows 95 "W32BTINT.DLL" SQL_FD_FETCH_NEXT SQL_FD_FETCH_FIRST SQL_FD_FETCH_LAST SQL_FD_FETCH_PRIOR SQL_FD_FETCH_ABSOLUTE SQL_FD_FETCH_RELATIVE SQL_FD_FETCH_BOOKMARK 1 SQL_OAC_LEVEL1 N 3-2ODBC Interface Reference Manual
44 finfotype (#define) SQL_ODBC_SAG_CLI_CONFORMANCE SAG SQL_OSCC_COMPLIANT SQL_SERVER_NAME SQL_SEARCH_PATTERN_ESCAPE SQL_ODBC_SQL_CONFORMANCE SQL_DATABASE_NAME SQL_DBMS_NAME SQL_DBMS_VER SQL_ACCESSIBLE_TABLES SQL_ACCESSIBLE_PROCEDURES SQL_PROCEDURES SQL_CONCAT_NULL_BEHAVIOR SQL SQL_OSC_CORE DBMS " " Scalable SQL N N Y NULL SQL_CB_NULL SQL_CURSOR_COMMIT_BEHAVIOR SQL_CB_PRESERVE SQL_CURSOR_ROLLBACK_BEHAVIOR SQL_CB_PRESERVE SQL_DATA_SOURCE_READ_ONLY SQL_DEFAULT_TXN_ISOLATION N ODBC Interface for Windows Scalable SQL Setup ODBC Interface for Windows NT/Windows 95 BTI.INI [Scalable SQL Engine] "isolation level" "cs" SQL_TXN_REPEATABLE_READ "ex" (exclusive) SQL_TXN _SERIALIZABLE SQL_EXPRESSIONS_IN_ORDERBY SQL_IDENTIFIER_CASE N SQL_IC_MIXED SQL_IDENTIFIER_QUOTE_CHAR (") SQL_MAX_COLUMN_NAME_LEN 20 SQL_MAX_CURSOR_NAME_LEN 18 SQL_MAX_OWNER_NAME_LEN 0 ODBC 3-3
45 finfotype (#define) SQL_MAX_PROCEDURE_NAME_LEN 30 SQL_MAX_QUALIFIER_NAME_LEN (Qualifier) 0 SQL_MAX_TABLE_NAME_LEN 20 SQL_MULT_RESULT_SETS SQL_MULTIPLE_ACTIVE_TXN SQL_OUTER_JOINS SQL_OWNER_TERM SQL_PROCEDURE_TERM Y Y Y "Stored Statements" SQL_QUALIFIER_NAME_SEPARATOR "." SQL_QUALIFIER_TERM SQL_SCROLL_CONCURRENCY SQL_SCROLL_OPTIONS SQL_TABLE_TERM SQL_TXN_CAPABLE SQL_USER_NAME SQL_SCCO_OPT_ROWVER SQL_SCCO_OPT_VALUES SQL_SCCO_READ_ONLY SQL_SCCO_LOCK SQL_SO_KEYSET_DRIVEN SQL_SO_DYNAMIC SQL_SO_FORWARD_ONLY "Table" DML SQL_TC_DML SQL_CONVERT_FUNCTIONS 0 SQL_NUMERIC_FUNCTIONS SQL_STRING_FUNCTIONS SQL_FN_NUM_ROUND SQL_FN_NUM_TRUNCATE SQL_FN_STR_CONCAT SQL_FN_STR_LEFT SQL_FN_STR_LTRIM SQL_FN_STR_LENGTH SQL_FN_STR_LCASE SQL_FN_STR_RIGHT SQL_FN_STR_RTRIM SQL_FN_STR_SUBSTRING SQL_FN_STR_UCASE SQL_SYSTEM_FUNCTIONS 0 3-4ODBC Interface Reference Manual
46 finfotype (#define) SQL_TIMEDATE_FUNCTIONS SQL_FN_TD_CURTIME SQL_FN_TD_HOUR SQL_FN_TD_MINUTE SQL_FN_TD_SECOND SQL_FN_TD_DAYOFWEEK SQL_FN_TD_CURDATE SQL_FN_TD_MONTH SQL_FN_TD_DAYOFMONTH SQL_FN_TD_YEAR SQL_CONVERT_BIGINT 0 SQL_CONVERT_BINARY 0 Scalable SQL 4 SQL_FN_TD_NOW SQL_CONVERT_BIT 0 SQL_CONVERT_CHAR 0 SQL_CONVERT_DATE 0 SQL_CONVERT_DECIMAL 0 SQL_CONVERT_DOUBLE 0 SQL_CONVERT_FLOAT 0 SQL_CONVERT_INTEGER 0 SQL_CONVERT_LONGVARCHAR 0 SQL_CONVERT_NUMERIC 0 SQL_CONVERT_REAL 0 SQL_CONVERT_SMALLINT 0 SQL_CONVERT_TIME 0 SQL_CONVERT_TIMESTAMP 0 SQL_CONVERT_TINYINT 0 SQL_CONVERT_VARBINARY 0 SQL_CONVERT_VARCHAR 0 SQL_CONVERT_LONGVARBINARY 0 SQL_TXN_ISOLATION_OPTION SQL_ODBC_SQL_OPT_IEF SQL_CORRELATION_NAME SQL_NON_NULLABLE_COLUMNS SQL_TXN_READ_COMMITTED SQL_TXN_SERIALIZABLE Y SQL_CN_ANY SQL_NNC_NULL ODBC 3-5
47 finfotype (#define) SQL_DRIVER_ODBC_VER SQL_LOCK_TYPES SQL_POS_OPERATIONS SQL_POSITIONED_STATEMENTS SQL_GETDATA_EXTENSIONS SQL_BOOKMARK_PERSISTENCE SQL_SPEC_STRING SQL_LCK_NO_CHANGE SQL_LCK_EXCLUSIVE SQL_LCK_UNLOCK SQL_POS_POSITION SQL_POS_REFRESHSQL_POS_UPDATE SQL_POS_DELETESQL_POS_ADD SQL_PS_POSITIONED_DELETE SQL_PS_POSITIONED_UPDATE SQL_PS_SELECT_FOR_UPDATE SQL_GD_ANY_COLUMN SQL_GD_ANY_ORDERSQL_GD_BLOCK SQL_BP_CLOSESQL_BP_DROP SQL_BP_SCROLL SQL_BP_TRANSACTION SQL_BP_UPDATE SQL_BP_OTHER_HSTMT SQL_STATIC_SENSITIVITY 0 SQL_FILE_USAGE SQL_NULL_COLLATION SQL_ALTER_TABLE SQL_COLUMN_ALIAS SQL_GROUP_BY SQL_KEYWORDS SQL_ORDER_BY_COLUMNS_IN_SE LECT SQL_FILE_NOT_SUPPORTED SQL_NC_LOW SQL_AT_ADD_COLUMN SQL_AT_DROP_COLUMN N SQL_GB_GROUP_BY_EQUALS_SELECT SQL Y SQL_OWNER_USAGE 0 SQL_QUALIFIER_USAGE 0 SQL_QUOTED_IDENTIFIER_CASE SQL_SPECIAL_CHARACTERS SQL_SUBQUERIES SQL_UNION SQL_IC_MIXED #$^ SQL_SQ_CORRELATED_SUBQUERIES SQL_U_UNION SQL_U_UNION_ALL 3-6ODBC Interface Reference Manual
48 finfotype (#define) SQL_MAX_COLUMNS_IN_GROUP_ BY SQL_MAX_COLUMNS_IN_INDEX SQL_MAX_COLUMNS_IN_ORDER_ BY SQL_MAX_COLUMNS_IN_SELECT SQL_MAX_COLUMNS_IN_TABLE SQL_MAX_INDEX_SIZE 255 SQL_MAX_ROW_SIZE_INCLUDES_ LONG N SQL_MAX_ROW_SIZE 4088 SQL_MAX_STATEMENT_LEN SQL_MAX_TABLES_IN_SELECT Scalable SQL v Scalable SQL v SQL_MAX_USER_NAME_LEN 30 SQL_MAX_CHAR_LITERAL_LEN 255 SQL_TIMEDATE_ADD_INTERVALS 0 SQL_TIMEDATE_DIFF_INTERVALS 0 SQL_NEED_LONG_DATA_LEN N SQL_MAX_BINARY_LITERAL_LEN 255 SQL_LIKE_ESCAPE_CLAUSE Y SQL_QUALIFIER_LOCATION 0 ODBC 3-7
49 SQLDriverConnect DDF ODBC Interface Scalable SQL Btrieve SQLDriverConnect DDF SQLDriverConnect (=) (;) ODBC Interface SQLDriverConnect DSN DB DDFPATH DATAPATH UID PWD () Scalable SQL Scalable SQL ( ) Scalable SQL ( ) ID 3-8ODBC Interface Reference Manual
50 ODBC Interface Smith IDSesame Patients ( 'Patients') ( (@) XQLLogin ) DDF DSN=Patients;DB=@PATIENTS;UID=Smith;PWD=Sesame ODBC Interface Smith IDSesame Patients (ODBC Interface for Windows C: BTI WIN DEMODATA ODBC Interface for Windows NT/Windows 95 C: Program Files BTI WIN32 DEMODATA ) ODBC Interface for Windows DSN=Patients;DDFPATH=C: BTI WIN DEMODATA; UID=Smith;PWD=Sesame ODBC Interface for Windows NT/Windows 95 DSN=Patients;DDFPATH=C: Program Files BTI WIN32 DEMODATA;UID=Smith;PWD=Sesame Windows NT Windows 95 ODBC 3-9
51 ODBC () ODBC Interface ODBC (Scalable SQL ) ODBC SELECT SELECT SELECTINSERTUPDATE DELETE SQL SELECT SQLRowCount SQLMoreResults INSERTUPDATE DELETE ODBC Interface SQL SELECT INSERTUPDATE DELETE SELECT SELECT SQLExecute SQLExecDirect SQL_SUCCESS 1. SQLRowCount 2. SQLRowCount SQLNumResultCols 3-10ODBC Interface Reference Manual
52 3. SQLRowCount SQLNumResultCols 4. ODBC ( SQLDescribeColSQLBindCol SQLFetch) 5. SQLMoreResults 6. SQLMoreResults SQL_NO_DATA_FOUND 7. SQLMoreResults SQL_SUCCESS 1 8. SQLMoreResults SQL_ERROR SQLRowCount SQLMoreResults ODBC Interface SQL INSERT 1 ODBC 3-11
53 1. SQLParamOptions ( ) 2. (SQLBindParameter rgbvalue ) (SQLBindParameter pcbvalue ) 3. SQLBindParameter 4. pcbvalue 5. SQLExecDirect (SQLPrepare SQLExecute) SQLParamOptions rgbvalue pcbvalue SQLBindParameter SQLExecDirect SQLExecute 3-12ODBC Interface Reference Manual
54 Data-at-execution 64KB (16 ODBC Interface ) Microsoft ODBC 2.0 SDK (Microsoft Press) 22 SQLParamOptions SQLSetPos ODBC Interface SQLSetPos SQLSetPos MINMAXSUMAVG SQLExtendedFetch SQLSetPos Microsoft ODBC 2.0 SDK (Microsoft Press) 22 ODBC SQLSetPos 32 ODBC 3-13
55 ODBC Interface 1 close SQL_BOOKMARK SQLGetStmtOption 3-14ODBC Interface Reference Manual
56 SQLExtendedFetch Microsoft ODBC 2.0 SDK (Microsoft Press) 22 ODBC SQLExtendedFetch SQL ODBC Interface SQL UPDATE DELETE SQL SQL SELECT SELECT [ALL DISTINCT] select-list FROM table-name FOR UPDATE OF [column-name [, column-name]...] FOR UPDATE OF SELECT SQLSetConnectOption SQL_CURSOR_DYNAMIC (Concurrency) SQL_CONCUR_ROWVER SQLExtendedFetch SQL_POSITION SQLSetPos ODBC 3-15
57 SQLGetCursorName SQLSetCursorName SQL (SQLPrepare SQLExecute ) (SQLExecDirect ) DELETE FROM table-name WHERE CURRENT OF cursor-name UPDATE table-name SET column-identifier = {constant-value dynamic-parameter} [, column-identifier = {constant-value dynamic-parameter}]... WHERE CURRENT OF cursor-name SELECT... FOR UPDATE OF SELECT... FOR UPDATE OF 1 MINMAXSUMAVG UPDATE SET SELECT Data-at-execution SQL Microsoft ODBC 2.0 SDK (Microsoft Press) 22 ODBC SQLSetPos 3-16ODBC Interface Reference Manual
58 SQLExtendedFetch ODBC Interface v2.0 SQLExtendedFetch SQL_FETCH_RELATIVE SQL_FETCH_ABSOLUTE SELECT SELECT ( ) OEM DOS Windows OEM ODBC Interface v2.0 DLL OEM Windows v3.1windows 95 Windows NT ANSI DLL DLL ODBC Administrator SQLDriverConnect [OEM/ANSI ] ODBC 3-17
59 A ODBC ODBC Interface ODBC API Scalable SQL Btrieve ID (Windows v3.1 ) ODBC Scalable SQL Scalable SQL API ODBC API XQLCallback XQLVersion ODBC Btrieve ODBC API SQLGetConnectOption SQLSetConnectOption ODBC Interface ID (Windows v3.1 ) AODBC A-1
60 A-1 C A-1 ODBC C ODBC HDBC RETCODE UDWORD UWORD C long integer long (32-bit) integer long integer short (16-bit) integer SQLSetConnectOption SQLGetConnectOption A-2 SQLSetConnectOption SQLGetConnectOption A-2 SQLSetConnectOption SQLGetConnectOption ODBC foption ODBC Interface SQLSetConnectOption 1000 SQLGetConnectOption 1001 ID SQLGetConnectOption 1002 (Windows v3.1 ) SQLSetConnectOption 1003 SQLGetConnectOption 1004 SQLGetConnectOption 1005 SQLGetConnectOption 1006 SQLGetConnectOption 1007 A-2ODBC Interface Reference Manual
61 SQLGetConnectOption C/C++ RETCODE SQLGetConnectOption( hdbc, foption, pvparam ) HDBC hdbc; UWORD foption; UDWORD pvparam; SQLSetConnectOption C/C++ RETCODE SQLSetConnectOption( hdbc, foption, vparam ) HDBC hdbc; UWORD foption; UDWORD vparam; Option 1000: ODBC Interface Scalable SQL Btrieve SQLSetConnectOption SQL A-3 SQLSetConnectOption AODBC A-3
62 A-3 Option 1000 SQLSetConnectOption hdbc SQLAllocConnect foption (1000) vparam Null ( ) SQLSetConnect Option UDWORD Scalable SQL Btrieve ODBC A-3 SQLSetConnectOption ( ID )SQLSetConnectOption SQLGetConnectOption SQLGetConnectOption ODBC ( UDWORD ) A-4ODBC Interface Reference Manual
63 SQLGetConnectOption SQL API SQLGetConnectOption ODBC SQLError ID SQLGetConnectOption Option 1001: Scalable SQL A-4 SQLGetConnectOption A-4 Option 1001 SQLGetConnectOption hdbc SQLAllocConnect foption (1001) vparam UDWORD AODBC A-5
64 A-5 A-5 SQLGetConnectOption Version 4 : XVER : XVER XVER 4 Scalable SQL ID ( 2 ) ID 3 Null "@" server volume: Netware NWSV Scalable SQL for Netware (Server Edition) RQST Scalable SQL Requester WIN3 Scalable SQL for Windows A-6ODBC Interface Reference Manual
65 A-5 SQLGetConnect Option SQLGetConnectOption Option 1002: ID ODBC ID ID A-6 ID SQLGetConnectOption A-6 Option 1002 SQLGetConnectOption hdbc SQLAllocConnect foption (1002) vparam ID short integer UDWORD ID vparam short integer SQLGetConnect Option ID ( ) AODBC A-7
66 (Scalable SQL Btrieve ) SQLGetConnectOption Option 1003: (Windows v3.1 ) ODBC Interface for Windows Btrieve MicroKernel ODBC Interface for Windows NT / Windows 95 A-7 SQLSetConnectOption A-7 Option 1003 SQLSetConnectOption hdbc SQLAllocConnect foption (1003) vparam UDWORD A-8ODBC Interface Reference Manual
67 A-8 A-8 SQLSetConnectOption Callback 2 : : (4 ) 0 ( ) (4 ) 0 () 1 0 Scalable SQL Programmer's Manual XQLCallback Btrieve Programmer's Manual AODBC A-9
68 SQLSetConnectOption SQLSetConnectOption SQLSetConnectOption ODBC ( UDWORD ) SQLSetConnectOption SQL API SQLSetConnectOption ODBC SQLError ( ID ) SQLSetConnectOption Option 1004: ASCII A-10ODBC Interface Reference Manual
69 A-9 SQLGetConnectOption A-9 Option 1004 SQLGetConnectOption hdbc SQLAllocConnect foption (1004) vparam UDWORD A-10 A-10 SQLGetConnectOption Convert 2 : ASCII 0ASCII DECIMALMONEYNUMERICNUMERICSA NUMERICSTS 0 2 ( 0 ) ( 1 ) 4 ( 0 ) ASCII ( 1 ) AODBC A-11
70 4 4 0 ASCII : : 2-1 A-10 SQLGetConnectOption SQLGetConnectOption Option 1005: A-11 SQLGetConnectOption A-12ODBC Interface Reference Manual
71 A-11 Option 1005 SQLGetConnectOption hdbc SQLAllocConnect foption (1005) vparam UDWORD A-12 A-12 SQLGetConnectOption Mask Validation SQLGetConnectOption SQL_SUCCESS SQLGetConnectOption AODBC A-13
72 Option 1006: A-13 SQLGetConnectOption A-13 Option 1006 SQLGetConnectOption hdbc SQLAllocConnect foption (1006) vparam UDWORD A-14 A-14 SQLGetConnectOption Default Mask Retrieval A-14ODBC Interface Reference Manual
73 A-14 SQLGetConnect Option SQLGetConnectOption Option 1007: A-15 SQLGetConnectOption A-15 Option 1007 SQLGetConnectOption hdbc SQLAllocConnect foption (1007) vparam UDWORD AODBC A-15
74 A-16 A-16 SQLGetConnectOption Value Validation 4 short integer (2 ) 4 : : A-16 SQLGetConnect Option SQLGetConnectOption SQLError A-16ODBC Interface Reference Manual
75 B ODBC API ODBC Interface C C/C++ C/C ODBC.LIB ODBC32.LIB SQL.H SQLEXT.H Microsoft ODBC Software Development Kit (ODBC SDK) Microsoft Developer Network Microsoft Visual C++ Windows C/C++ ODBC API B-1
76 ODBC.LIB Microsoft ODBC SDK Windows C/C++ 16 ODBC ODBC.DLL ODBC32.LIB Microsoft ODBC SDK Windows C/C++ 32 ODBC ODBC32.DLL C/C++ ODBCSAMP.C (Microsoft Visual C++ QuickWin Borland C++ EasyWin ) 3. ODBCSAMP.C Windows Microsoft Visual C++ v1.52 (16 )v4.0 (32 ) Watcom C v10.5 (16 32 ) make Samples B-2ODBC Interface Reference Manual
77 README C/C++ ODBC ODBC.LIB ODBC32.LIB ODBC SQLAllocEnv SQLAllocConnect SQLConnect SQLAllocStmt SQLSetStmtOption SQLExecDirect SQLNumResultCols SQLDescribeCol SQLBindCol SQLExtendedFetch SQLError SQLFreeStmt SQLDisconnect SQLFreeConnect SQLFreeEnv ODBC ODBC ODBC SQL SQL ODBC ODBC ODBC ODBC B-3
78 B-1 C (ODBCSAMP.C) /************************************************************************* ** ** Copyright Btrieve Technologies, Inc. All Rights Reserved ** *************************************************************************/ /************************************************************************* ODBCSAMP.C This program demonstrates the C/C++ ODBC interface for Scalable SQL and Btrieve under MS Windows. It uses ODBC functions to fetch records from the 'dental' database that is included with this product. IMPORTANT: Be sure to set up a data source mapped to this database; the data source name must match with the name used in the SQLConnect call. See 'IMPORTANT', below. The ODBC Software Development Kit is required for developing ODBC-enabled applications. It can be obtained from Microsoft as part of the Developer Network subscription service. The necessary components are also shipped as part of the Visual C++ product (v1.5 or greater). *************************************************************************/ #include <windows.h> #include <stdlib.h> #include <stdio.h> #include <string.h> /************************************************************************* The following files are found in the ODBC SDK, a Microsoft product. *************************************************************************/ #include <sql.h> /* ODBC SQL function prototypes, part 1 */ #include <sqlext.h> /* ODBC SQL function prototypes, part 2 */ /************************************************************************* The following pragmas allow Watcom's linker to link with the 32-bit library found in the ODBC SDK. *************************************************************************/ #if defined( WATCOMC ) && defined( BTI_WIN_32 ) #pragma aux SQLError "*"; #pragma aux SQLAllocEnv "*"; #pragma aux SQLAllocConnect "*"; #pragma aux SQLConnect "*"; #pragma aux SQLAllocStmt "*"; #pragma aux SQLSetStmtOption "*"; #pragma aux SQLExecDirect "*"; #pragma aux SQLBindCol "*"; #pragma aux SQLNumResultCols "*"; #pragma aux SQLDescribeCol "*"; #pragma aux SQLFetch "*"; #pragma aux SQLExtendedFetch "*"; #pragma aux SQLFreeStmt "*"; B-4ODBC Interface Reference Manual
79 B-1 () C (ODBCSAMP.C) #pragma aux SQLDisconnect "*"; #pragma aux SQLFreeConnect "*"; #pragma aux SQLFreeEnv "*"; #endif /************************************************************************* Constants *************************************************************************/ // ** IMPORTANT ** // You must have a data source called "BTI_ODBC_SAMPLEDB" configured for this // sample to work. #define BTI_SAMPLE_DATA_SOURCE "BTI_ODBC_SAMPLEDB" #define DOCTOR_LEN 12 #define DOCTOR_COL 1 #define PHONE_LEN 12 #define PHONE_COL 2 #define FIRST_LAST_LEN 33 #define FIRST_LAST_COL 3 #define ROWSET_SIZE 10 #define MAX_FIELD_LENGTH 44 typedef struct ColDescs { UCHAR szcolname[ MAX_FIELD_LENGTH + 1 ]; SWORD pcbcolname; SWORD fsqltype; UDWORD pcbcoldef; SWORD pibscale; SWORD pfnullable; } ColStruct; /************************************************************************* generic error handler *************************************************************************/ void CheckError( RETCODE status, HENV henv, HDBC hdbc, HSTMT hstmt ) { RETCODE errstat = SQL_SUCCESS ; char szsqlstate[ 8 ]; LONG fnativeerror = 0; static char szerrormsg[ 256 ]; short cberrormsg = 0; /* return directly if no error has occurred. */ if ( status == SQL_SUCCESS ) ; else if ( status == SQL_ERROR status == SQL_SUCCESS_WITH_INFO ) B-5
80 B-1 () C (ODBCSAMP.C) { szerrormsg[ 0 ] = 0; szsqlstate[ 0 ] = 0; /* if an error or SQL_SUCCESS-with-info occurs, there may be multiple messages associated with the problem; retrieve and print them all. */ while ( errstat == SQL_SUCCESS ) { errstat = SQLError( henv, hdbc, hstmt, szsqlstate, &fnativeerror, szerrormsg, sizeof(szerrormsg), &cberrormsg ); printf( "*** Status: %s nsqlstate: %s nmessage: " "%s nnative Error: %ld n n", status == SQL_ERROR? "Error" : "SQL_SUCCESS with info", szsqlstate, szerrormsg, fnativeerror ); } // end while loop } // end else if ( status == SQL_ERROR status == SQL_SUCCESS_WITH_INFO ) else printf( " nerror status = %ld n", status ); } // end CheckError /************************************************************************* main *************************************************************************/ void main( void ) { char userid [] = ""; char password[] = ""; char header [] = " DOCTOR PHONE NUMBER PATIENT"; ColStruct * colbuf = NULL; SWORD colposition = 0; UWORD fetchoption = 0; UDWORD recordindex = 0; B-6ODBC Interface Reference Manual
81 B-1 () C (ODBCSAMP.C) char statement[ 300 ]; RETCODE status = SQL_SUCCESS; SDWORD statlen = 0; UCHAR szdoctor[ ROWSET_SIZE ][ DOCTOR_LEN + 1 ]; SDWORD cbdoctor[ ROWSET_SIZE ]; UCHAR szphone[ ROWSET_SIZE ][ PHONE_LEN + 1 ]; SDWORD cbphone[ ROWSET_SIZE ]; UCHAR szfirst_last[ ROWSET_SIZE ][ FIRST_LAST_LEN + 1 ]; SDWORD cbfirst_last[ ROWSET_SIZE ]; UDWORD bufferlength = 0; SWORD numresultcols = 0; UDWORD rowlen = 0; UDWORD rowsfetched = 0; UWORD rowstatus[ ROWSET_SIZE ]; /* ODBC variables. */ HENV henv = SQL_NULL_HENV; HDBC hdbc = SQL_NULL_HDBC; HSTMT hstmt = SQL_NULL_HSTMT; printf( "SQL-Level Functions Sample Program Started n" ); /* do ODBC standard setup */ status = SQLAllocEnv( &henv ); CheckError( status, henv, hdbc, hstmt ); status = SQLAllocConnect( henv, &hdbc ); CheckError( status, henv, hdbc, hstmt ); /* login to ODBC data source */ /* Dictionary and data files are in the working directory. */ status = SQLConnect( hdbc, (UCHAR FAR *)BTI_SAMPLE_DATA_SOURCE, strlen( BTI_SAMPLE_DATA_SOURCE ), userid, SQL_NTS, password, SQL_NTS ); CheckError( status, henv, hdbc, hstmt ); /* ODBC driver sets blank character to underscore during connect */ if ( status!= SQL_SUCCESS && status!= SQL_SUCCESS_WITH_INFO ) printf( "SQLConnect failed n" ); /* allocate an ODBC statement */ if ( status == SQL_SUCCESS ) { status = SQLAllocStmt( hdbc, (HSTMT FAR *)&hstmt ); CheckError( status, henv, hdbc, hstmt ); if ( status!= SQL_SUCCESS ) B-7
82 B-1 () C (ODBCSAMP.C) printf( "SQLAllocStmt failed, status: %d n", status ); } // end if ( status == SQL_SUCCESS ) /* set appropriate statement options for a read-only block cursor. */ SQLSetStmtOption( hstmt, SQL_CONCURRENCY, SQL_CONCUR_READ_ONLY ); SQLSetStmtOption( hstmt, SQL_CURSOR_TYPE, SQL_CURSOR_DYNAMIC ); SQLSetStmtOption( hstmt, SQL_ROWSET_SIZE, ROWSET_SIZE ); /* execute SQL select statement */ if ( status == SQL_SUCCESS ) { strcpy( statement, "SELECT Doctor, Phone, First^Name * Last^Name FROM Patients, Appointments WHERE Patients.ID = Appointments.ID"); statlen = strlen( statement ); printf( "%s n", statement ); status = SQLExecDirect( hstmt, statement, statlen ); CheckError( status, henv, hdbc, hstmt ); if ( status!= SQL_SUCCESS ) printf( "SQLExecDirect failed, status: %d n", status ); } // end if ( status == SQL_SUCCESS ) /* allocate a buffer big enough to hold the rowset */ if ( status == SQL_SUCCESS ) { rowlen = 0; status = SQLNumResultCols( hstmt, &numresultcols ); CheckError( status, henv, hdbc, hstmt ); if ( status == SQL_SUCCESS ) colbuf = malloc( numresultcols * sizeof ( ColStruct )); if ( colbuf == NULL ) { printf( "Memory allocation failed n" ); status = SQL_ERROR; } // end if ( colbuf == NULL ) /* get column description info into colbuf */ for ( colposition = 0; (colposition < numresultcols) && (status == SQL_SUCCESS); colposition++ ) { colbuf[ colposition ].pcbcolname = MAX_FIELD_LENGTH; status = SQLDescribeCol( hstmt, colposition + 1, (UCHAR FAR *)&colbuf[ colposition ].szcolname, MAX_FIELD_LENGTH, &colbuf[ colposition ].pcbcolname, &colbuf[ colposition ].fsqltype, &colbuf[ colposition ].pcbcoldef, B-8ODBC Interface Reference Manual
83 B-1 () C (ODBCSAMP.C) &colbuf[ colposition ].pibscale, &colbuf[ colposition ].pfnullable ); } // end for ( colposition = 0;... } // end if ( status == SQL_SUCCESS ) /* bind columns */ if ( status == SQL_SUCCESS ) { status = SQLBindCol( hstmt, DOCTOR_COL, colbuf[ DOCTOR_COL - 1 ].fsqltype, szdoctor, DOCTOR_LEN + 1, cbdoctor ); } if ( status == SQL_SUCCESS ) { status = SQLBindCol( hstmt, PHONE_COL, colbuf[ PHONE_COL - 1 ].fsqltype, szphone, PHONE_LEN + 1, cbphone ); } if ( status == SQL_SUCCESS ) { status = SQLBindCol( hstmt, FIRST_LAST_COL, colbuf[ FIRST_LAST_COL - 1 ].fsqltype, szfirst_last, FIRST_LAST_LEN + 1, cbfirst_last ); } /* FETCH UP TO 10 RECORDS WITH A SINGLE SQLExtendedFetch() CALL */ if ( status == SQL_SUCCESS ) { printf( " n%s n", header ); fetchoption = SQL_FETCH_FIRST; while ( status == SQL_SUCCESS ) { /* Get buffers full of records. */ status = SQLExtendedFetch( hstmt, fetchoption, 1, &rowsfetched, rowstatus ); B-9
84 B-1 () C (ODBCSAMP.C) if (( status!= SQL_SUCCESS ) && ( status!= SQL_NO_DATA_FOUND )) { CheckError( status, henv, hdbc, hstmt ); printf ("SQLExtendedFetch failed, status: %d n", status); break; } /* Display the records in the column buffers, one record per line. */ for ( recordindex = 0; ((recordindex < rowsfetched) && ((status == SQL_SUCCESS) (status == SQL_SUCCESS_WITH_INFO))); recordindex++ ) { printf( " %-13.13s%-18.18s%s n", szdoctor[ recordindex ], szphone[ recordindex ], szfirst_last[ recordindex ]); } fetchoption = SQL_FETCH_NEXT; } // end while ( status == SQL_SUCCESS ) } // if ( status == SQL_SUCCESS ) SQLFreeStmt( hstmt, SQL_CLOSE ); SQLDisconnect( hdbc ); SQLFreeConnect( hdbc ); SQLFreeEnv( henv ); if (colbuf!= NULL) free( colbuf ); exit( 0 ); } // end main B-10ODBC Interface Reference Manual
85 32 ODBC B-2 Access 1-3 ANSI SQL ANSI 1-6 API 1-11 ASCII A-10 AUTOINC 2-7 Borland 1-3 BTI.INI Btrieve 1-13 C/C++ B CREATE TABLE NOTE LVAR 2-7 CURRENCY 1-4 Data-at-execution DDF DELETE... WHERE CURRENT OF1-6 Delphi 1-3 INSERT AUTOINC 2-7 INTEGER(8)1-4 INTEGER 1-4 LVAR 2-7 Microsoft Foundation Classes1-3 Microsoft Visual C++1-3 Microsoft 1-3 NOTE ODBC32.DLL1-10B-2 ODBC Administrator3-17 ODBC API 3-1 ODBC.DLL1-10 ODBC.INI 1-14 ODBCINST.INI 1-14 ODBC Interface 1-15 ODBC Interface 1-14 ODBC v ODBC 1-3 ODBC 1-3 ODBC 1-1 ODBC A-1 OEM 3-17 OEM SAG CLI1-7 Scalable SQL v Scalable SQL 1-13 SELECT NOTE LVAR 2-7 SQL_BOOKMARK3-14 SQL_FETCH_ABSOLUTE1-6 SQL_FETCH_RELATIVE1-6 SQL_INTEGER 2-7 SQL_SMALLINT 2-7 SQLDescribeParam1-5 SQLDriverConnect3-8 1
86 SQLExtendedFetch SQLForeignKeys1-5 SQLGetConnectOption A-2 A-4 SQLGetInfo 3-2 SQLGetStmtOption3-14 SQLMoreResults SQLParamOptions1-5 SQLRowCount3-10 SQLSetConnectOption1-6 A-2 A-2 SQLSetPos SQL 1-4 SQL SQL TIMESTAMP 1-4 UNSIGNED 1-4 UNSIGNED(1, 2, 4, 8)1-4 UPDATE... WHERE CURRENT OF1-6 UPDATE AUTOINC 2-7 Visual Basic 1-3 Visual C++1-3 W32BTINT.DLL1-10 WINBTINT.DLL1-10 Windows Windows Windows NT1-2 Windows NT Windows 1-10 X/Open B-2 B SQL.HB-1 SQLEXT.HB-1 ODBC.LIBB-2 ODBC32.LIBB A IDA-7 /1-7 A-15 A-12 / ODBC Interface Reference Manual
87 1-9 x x A ODBC Interface B-1 DDF 3-9 ODBC B ID ID A ODBC AUTOINC2-7 CURRENCY1-4 INTEGER(8)1-4 LVAR2-7 NOTE2-7 ODBC C A-2 Scalable SQL Btrieve ODBC 2-5 TIMESTAMP1-4 UNSIGNED A A-14 DLL A
88 Btrieve1-13 Scalable SQL x ix x 1-9 A-12 A ODBC Interface Reference Manual
橡j_Oracle_whitepaper.PDF
Pervasive-Oracle 1 1 Pervasive Software Pervasive-Oracle / Pervasive Oracle Pervasive-Oracle ISV Pervasive-Oracle Pervasive.SQL Oracle 2 Pervasive-Oracle Pervasive-Oracle Pervasive.SQL Oracle Open Database
More informationODBC Driver for 4D Server
by ACI Copyright 1993 1997 ACI SA/ACI US, Inc. All rights reserved Ô ÔÕ SQL_DATE SQL_TIMESTAMP SQL_CHAR SQL_VARCHAR SQL_LONGVARCHAR SELECT CLIENTS.ID CLIENTS.String 1 MyString 2
More informationはじめに 本書は GridDB ODBC ドライバを利用して GridDB Advanced Edition のデータベースにアクセスするア プリケーション開発者を対象としています 本書を読むためには 以下の知識が必要になります GridDB Advanced Edition についての基礎知識 W
GMA020D0 GridDB Advanced Edition ODBC ドライバ説明書 Toshiba Solutions Corporation 2016 All Rights Reserved. はじめに 本書は GridDB ODBC ドライバを利用して GridDB Advanced Edition のデータベースにアクセスするア プリケーション開発者を対象としています 本書を読むためには
More information外部SQLソース入門
Introduction to External SQL Sources 外部 SQL ソース入門 3 ESS 3 ESS : 4 ESS : 4 5 ESS 5 Step 1:... 6 Step 2: DSN... 6 Step 3: FileMaker Pro... 6 Step 4: FileMaker Pro 1. 6 Step 5:... 6 Step 6: FileMaker Pro...
More information橡PervasiveSQL2000ReviewersGuide.PDF
Pervasive.SQL 2000 Reviewer s Guide Pervasive.SQL TM 2000 Reviewer s Guide Rev.1 11/99 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere ...3 Pervasive.SQL 2000...4 Pervasive.SQL
More information基本操作ガイド
HT7-0199-000-V.5.0 1. 2. 3. 4. 5. 6. 7. 8. 9. Copyright 2004 CANON INC. ALL RIGHTS RESERVED 1 2 3 1 1 2 3 4 1 2 1 2 3 1 2 3 1 2 3 1 2 3 4 1 2 3 4 1 2 3 4 5 AB AB Step 1 Step
More information操作ガイド(本体操作編)
J-1 QT5-0681-V02 1 m a b c d e f l kj i h g a b c d e f g h i j k l m n n o o s p q r p q r s w t u v x y z t u v w x y z a bc d e f g q p o n m l k j i h a b c d e f g h i j k l {}[] {}[] m n
More informationfx-9860G Manager PLUS_J
fx-9860g J fx-9860g Manager PLUS http://edu.casio.jp k 1 k III 2 3 1. 2. 4 3. 4. 5 1. 2. 3. 4. 5. 1. 6 7 k 8 k 9 k 10 k 11 k k k 12 k k k 1 2 3 4 5 6 1 2 3 4 5 6 13 k 1 2 3 1 2 3 1 2 3 1 2 3 14 k a j.+-(),m1
More information操作ガイド(本体操作編)
J QT5-0571-V03 1 ...5...10...11...11...11...12...12...15...21...21...22...25...27...28...33...37...40...47...48...54...60...64...64...68...69...70...70...71...72...73...74...75...76...77 2 ...79...79...80...81...82...83...95...98
More informationFileMaker ODBC and JDBC Guide
FileMaker 13 ODBC JDBC 2004-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,
More information橡アップグレードB6.15.doc
Pervasive.SQL 2000 White Paper Btrieve TM 6.15 Pervasive.SQL TM 7 Pervasive.SQL TM 2000 White Paper Rev.1 11/1999 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere ...3...3...3...4...5...5...5
More informationZinstall WinWin 日本語ユーザーズガイド
Zinstall WinWin User Guide Thank you for purchasing Zinstall WinWin. If you have any questions, issues or problems, please contact us: Toll-free phone: (877) 444-1588 International callers: +1-877-444-1588
More informationFileMaker 15 ODBC と JDBC ガイド
FileMaker 15 ODBC JDBC 2004-2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
More informationFileMaker 16 ODBC と JDBC ガイド
FileMaker 16 ODBC JDBC 2004-2017 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker
More informationインターネット接続ガイド v110
1 2 1 2 3 3 4 5 6 4 7 8 5 1 2 3 6 4 5 6 7 7 8 8 9 9 10 11 12 10 13 14 11 1 2 12 3 4 13 5 6 7 8 14 1 2 3 4 < > 15 5 6 16 7 8 9 10 17 18 1 2 3 19 1 2 3 4 20 U.R.G., Pro Audio & Digital Musical Instrument
More informationエレクトーンのお客様向けiPhone/iPad接続マニュアル
/ JA 1 2 3 4 USB TO DEVICE USB TO DEVICE USB TO DEVICE 5 USB TO HOST USB TO HOST USB TO HOST i-ux1 6 7 i-ux1 USB TO HOST i-mx1 OUT IN IN OUT OUT IN OUT IN i-mx1 OUT IN IN OUT OUT IN OUT IN USB TO DEVICE
More informationSonicWALL SSL-VPN 4000 導入ガイド
COMPREHENSIVE INTERNET SECURITY SonicWALL セキュリティ装置 SonicWALL SSL-VPN 4000 導入ガイド 1 2 3 4 5 6 7 8 9-1 2 - 3 1 4 - 5 2 1. 2. 3 6 3 1. 2. 3. 4. 5. - 7 4 4 8 1. 2. 3. 4. 1. 2. 3. 4. 5. - 9 6. 7. 1. 2. 3. 1.
More information基本操作ガイド
HT7-0022-000-V.4.0 Copyright 2004 CANON INC. ALL RIGHTS RESERVED 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 4 1 1 2 3 4 5 1 2 1 2 3 1 2 3 1 2 3 1 2 3 4 1 2 3 4 1 2 3 4 5 6 1 2 3 4 5 6 7 1 2 3 4
More informationOracleコール・インタフェース for Windows スタート・ガイド リリース8.1.6
Oracle for Windows 8.1.6 2000 4 : J01324-01 Oracle for Windows 8.1.6 : J01324-01 Oracle Call Interface Getting Started, Release 8.1.6 for Windows A73022-01 Eric Belden Joseph Garcia Lisa Giambruno Michael
More informationuntitled
Unify NXJ Release 12 2002-2008 Unify Corporation All rights reserved. Sacramento California, USA No part of this tutorial may be reproduced, transmitted, transcribed, stored in a retrieval system, or translated
More informationChapter 1 1-1 2
Chapter 1 1-1 2 create table ( date, weather ); create table ( date, ); 1 weather, 2 weather, 3 weather, : : 31 weather -- 1 -- 2 -- 3 -- 31 create table ( date, ); weather[] -- 3 Chapter 1 weather[] create
More informationScanFront300/300P セットアップガイド
libtiff Copyright (c) 1988-1996 Sam Leffler Copyright (c) 1991-1996 Silicon Graphics, Inc. Permission to use, copy, modify, distribute, and sell this software and its documentation for any purpose is hereby
More informationWQD770W WQD770W WQD770W WQD770W WQD770W 5 2 1 4 3 WQD8438 WQD770W 1 2 3 5 4 6 7 8 10 12 11 14 13 9 15 16 17 19 20 20 18 21 22 22 24 25 23 2 1 3 1 2 2 3 1 4 1 2 3 2 1 1 2 5 6 3 4 1 2 5 4 6 3 7 8 10 11
More informationiPhone/iPad接続マニュアル
/ JA 2 3 USB 4 USB USB i-ux1 USB i-ux1 5 6 i-mx1 THRU i-mx1 THRU 7 USB THRU 1 2 3 4 1 2 3 4 5 8 1 1 9 2 1 2 10 1 2 2 6 7 11 1 2 3 4 5 6 7 8 12 1 2 3 4 5 6 13 14 15 WPA Supplicant Copyright 2003-2009, Jouni
More informationFileMaker ODBC と JDBC ガイド
FileMaker ODBC JDBC 2004-2019 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker CloudFileMaker Go FileMaker, Inc. FileMaker
More informationWYE771W取扱説明書
WYE771W WYE771W 2 3 4 5 6 MEMO 7 8 9 10 UNLOCK RESET/ STOPALARM EMERG. TALK FIRE CONFIRM MENU OFF POWER 11 UNLOCK RESET/ STOPALARM EMERG. TALK FIRE CONFIRM MENU OFF POWER 12 POWER EMERG. RESET/ STOPALARM
More informationuntitled
SUBJECT: Applied Biosystems Data Collection Software v2.0 v3.0 Windows 2000 OS : 30 45 Cancel Data Collection - Applied Biosystems Sequencing Analysis Software v5.2 - Applied Biosystems SeqScape Software
More information1,.,,,., RDBM, SQL. OSS,, SQL,,.
1,.,,,., RDBM, SQL. OSS,, SQL,,. 3 10 10 OSS RDBMS SQL 11 10.1 OSS RDBMS............................ 11 10.1.1 PostgreSQL................................. 11 10.1.2 MySQL...................................
More informationIM 21B04C50-01
User s Manual Blank Page Media No. (CD) 5th Edition : Sep. 2009 (YK) All Rights Reserved. Copyright 2001, Yokogawa Electric Corporation Yokogawa Electric Corporation Software License Agreement This
More information2
NSCP-W61 08545-00U60 2 3 4 5 6 7 8 9 10 11 12 1 2 13 7 3 4 8 9 5 6 10 7 14 11 15 12 13 16 17 14 15 1 5 2 3 6 4 16 17 18 19 2 1 20 1 21 2 1 2 1 22 23 1 2 3 24 1 2 1 2 3 3 25 1 2 3 4 1 2 26 3 4 27 1 1 28
More informationActual ESS Adapterの使用について
Actual ESS Adapter SQL External SQL Source FileMaker SQL ESS SQL FileMaker FileMaker SQL FileMaker FileMaker ESS SQL SQL FileMaker ODBC SQL FileMaker Microsoft SQL Server MySQL Oracle 3 ODBC Mac OS X Actual
More information管理者不要で TCO に優れたデータベース PSQL v11 株式会社エージーテック 2013 年 9 月 30 日
管理者不要で TCO に優れたデータベース PSQL v11 株式会社エージーテック 2013 年 9 月 30 日 免責事項株式会社エージーテックは本書の使用を 利用者またはその会社に対して 現状のまま でのみ許諾するものです 株式会社エージーテックは いかなる場合にも本書に記載された内容に関するその他の一切の保証を 明示的にも黙示的にも行いません 本書の内容は予告なく変更される場合があります 商標
More informationMIDI_IO.book
MIDI I/O t Copyright This guide is copyrighted 2002 by Digidesign, a division of Avid Technology, Inc. (hereafter Digidesign ), with all rights reserved. Under copyright laws, this guide may not be duplicated
More informationnew_logo.eps
Oracle for Windows NT and Windows 95/98 8.1.5 1999 5 : A62908-1 Oracle for Windows NT and Windows 95/98 8.1.5 : A62908-1 1 1999 5 1 Oracle Call Interface Getting Started Release 8.1.5 for Windows NT and
More informationIntroduction Purpose This training course demonstrates the use of the High-performance Embedded Workshop (HEW), a key tool for developing software for
Introduction Purpose This training course demonstrates the use of the High-performance Embedded Workshop (HEW), a key tool for developing software for embedded systems that use microcontrollers (MCUs)
More informationDDK-7 取扱説明書 v1.10
DDK-7 v. JA 2 ()B-9 /4 ()B-9 2/4 3 4 ()B-9 3/4 ()B-9 4/4 5 6 7 "Mobile Wnn" OMRON SOFTWARE Co., Ltd. 999 All Rights Reserved. 8 CONTENTS 2 3 4 5 6 7 8 9 0 2 3 4 3 4 5 6 2 3 0 4 5 6 7 8 9 0 2 D. 2 3 4 5
More informationベース0516.indd
QlikView QlikView 2012 2 qlikview.com Business Discovery QlikTech QlikView QlikView QlikView QlikView 1 QlikView Server QlikTech QlikView Scaling Up vs. Scaling Out in a QlikView Environment 2 QlikView
More information意外と簡単!?
!?Access Oracle Oracle Migration Workbench MS-Access Oracle Creation Date: Oct 01, 2004 Last Update: Mar 08, 2005 Version: 1.1 !? Oracle Database 10g / GUI!? / Standard Edition!? /!?!? Oracle Database
More informationVE-GP32DL_DW_ZA
VE-GP32DL VE-GP32DW 1 2 3 4 5 6 1 2 3 4 1 1 2 3 2 3 1 1 2 2 2006 Copyrights VisionInc. @. _ & $ % + = ^ @. _ & $ % + = ^ D11 D12 D21
More informationFileMaker ODBC and JDBC Guide
FileMaker 14 ODBC JDBC 2004-2015 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
More informationTH-47LFX60 / TH-47LFX6N
TH-47LFX60J TH-47LFX6NJ 1 2 3 4 - + - + DVI-D IN PC IN SERIAL IN AUDIO IN (DVI-D / PC) LAN, DIGITAL LINK AV IN AUDIO OUT 1 11 2 12 3 13 4 14 5 6 15 7 16 8 17 9 18 10 19 19 3 1 18 4 2 HDMI AV OUT
More informationScanFront 220/220P 取扱説明書
libtiff Copyright (c) 1988-1996 Sam Leffler Copyright (c) 1991-1996 Silicon Graphics, Inc. Permission to use, copy, modify, distribute, and sell this software and its documentation for any purpose is hereby
More informationScanFront 220/220P セットアップガイド
libtiff Copyright (c) 1988-1996 Sam Leffler Copyright (c) 1991-1996 Silicon Graphics, Inc. Permission to use, copy, modify, distribute, and sell this software and its documentation for any purpose is hereby
More informationストラドプロシージャの呼び出し方
Release10.5 Oracle DataServer Informix MS SQL NXJ SQL JDBC Java JDBC NXJ : NXJ JDBC / NXJ EXEC SQL [USING CONNECTION ] CALL [.][.] ([])
More informationMOTIF XF 取扱説明書
MUSIC PRODUCTION SYNTHESIZER JA 2 (7)-1 1/3 3 (7)-1 2/3 4 (7)-1 3/3 5 http://www.adobe.com/jp/products/reader/ 6 NOTE http://japan.steinberg.net/ http://japan.steinberg.net/ 7 8 9 A-1 B-1 C0 D0 E0 F0 G0
More informationTH-65LFE7J TH-50LFE7J TH-42LFE7J - + - + PC IN DVI-D IN IR IN/OUT CHARGE OUT SERIAL IN LAN AUDIO IN (DVI-D / PC) AUDIO OUT AV IN (HDMI 1 HDMI 2) 19 3 1 1 11 2 12 3 13 4 14 5 6 15 7 16 8 17 9 18 10
More information1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058
1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058 2 Excel 1 SQL 1 SQL Server sp_executesql Oracle SQL
More information~~~~~~~~~~~~~~~~~~ wait Call CPU time 1, latch: library cache 7, latch: library cache lock 4, job scheduler co
072 DB Magazine 2007 September ~~~~~~~~~~~~~~~~~~ wait Call CPU time 1,055 34.7 latch: library cache 7,278 750 103 24.7 latch: library cache lock 4,194 465 111 15.3 job scheduler coordinator slave wait
More informationES-D400/ES-D200
NPD4564-00 ...4...7 EPSON Scan... 7...11 PDF...12 / EPSON Scan...14 EPSON Scan...14 EPSON Scan...15 EPSON Scan...15 EPSON Scan...16 Epson Event Manager...17 Epson Event Manager...17 Epson Event Manager...17
More informationprogram.dvi
2001.06.19 1 programming semi ver.1.0 2001.06.19 1 GA SA 2 A 2.1 valuename = value value name = valuename # ; Fig. 1 #-----GA parameter popsize = 200 mutation rate = 0.01 crossover rate = 1.0 generation
More informationWindows版SASシステム 6.12TS020 使用上の注意点
使用上の注意点 (Alert Notes) ご使用前に必ずお読みください Windows 版 SAS システムリリース 6.12 TS045 DBCS2818 1. 導入時の注意点 1.1 SAS CD ROM CD ROM (X:CD ROM ) Error: X: CDR101: Not ready X (A), (R), (F)? CD ROM CD ROM MSCDEX.EXE CD ROM
More informationSoftware Tag Implementation in Adobe Products
2011 Adobe Systems Incorporated. All rights reserved. Software Tagging in Adobe Products Tech Note Adobe, the Adobe logo, and Creative Suite are either registered trademarks or trademarks of Adobe Systems
More informationEPSON ES-D200 パソコンでのスキャンガイド
NPD4271-00 ...4...7 EPSON Scan... 7...11 PDF...12 / EPSON Scan...13 EPSON Scan...13 EPSON Scan...14 EPSON Scan...14 EPSON Scan...15 Epson Event Manager...16 Epson Event Manager...16 Epson Event Manager...16
More informationRX600 & RX200シリーズ アプリケーションノート RX用仮想EEPROM
R01AN0724JU0170 Rev.1.70 MCU EEPROM RX MCU 1 RX MCU EEPROM VEE VEE API MCU MCU API RX621 RX62N RX62T RX62G RX630 RX631 RX63N RX63T RX210 R01AN0724JU0170 Rev.1.70 Page 1 of 33 1.... 3 1.1... 3 1.2... 3
More informationEPSON Easy Interactive Tools Ver.4.2 Operation Guide
Easy Interactive Tools Ver.4.2 Easy Interactive Tools Ver.4.2 Easy Interactive Tools Easy Interactive Tools Easy Interactive Pen s p.12 s p.12 s p.11 s p.18 s p.20 s p.29 Easy Interactive Tools PowerPoint
More informationOracle8 Workgroup Server for Windows NTインストレーション・ガイド,リリース8.0.6
Oracle8 Workgroup Server for Windows NT 8.0.6 2000 5 : J00213-01 Oracle8 Workgroup Server for Windows NT, 8.0.6 : J00213-01 Oracle8 Release 8.0.6 for Windows NT A69969-01 Copyright 1999, 2000, Oracle Corporation.
More informationHAR-LH500
4-249-904-01(1) HAR-LH500 2003 Sony Corporation 2 3 4 Flow-Down License Terms This product contains technology and data from Gracenote, Inc. of Berkeley, California ( Gracenote ). The technology from Gracenote
More information取説_VE-PV11L(応用編)
* 0 # VE-PV11L VE-PVC11L VE-PS109N 1 2 3 4 5 6 7 8 9 C H H H C H H H C C CAUTION:These telephones are for use in Japan only. They cannot be used in other countries because of differences in voltages, telephone
More information操作ガイド(本体操作編)
J QT7-0030-V04 1 ...5...10...11...11...11...12...12...15...21...23...25...29...32...38...43...44...50...52...55...55...59...60...61...61...62...63...64...65...66...67...69...69...70...71...72...73...84
More information/ SCHEDULE /06/07(Tue) / Basic of Programming /06/09(Thu) / Fundamental structures /06/14(Tue) / Memory Management /06/1
I117 II I117 PROGRAMMING PRACTICE II 2 MEMORY MANAGEMENT 2 Research Center for Advanced Computing Infrastructure (RCACI) / Yasuhiro Ohara yasu@jaist.ac.jp / SCHEDULE 1. 2011/06/07(Tue) / Basic of Programming
More informationVE-GD21DL_DW_ZB
V E-G D21D L V E-G D21D W 1 2 3 4 1 2 1 2 1 2 2 1 2 3 1 2 3 1 2 3 1 4 4 2 3 5 5 1 2 3 4 1 2 3 1 2 3 4 1 2 3 2006 Copyrights VisionInc. @. _ & $ % + = ^ 2011
More informationNetVehicle GX5取扱説明書 基本編
-GX5 1 2 3 4 5 6 7 8 # @(#)COPYRIGHT 8.2 (Berkeley) 3/21/94 All of the documentation and software included in the 4.4BSD and 4.4BSD-Lite Releases is copyrighted by The Regents of the University of California.
More informationCopyright 2001, 1999, 1997, 1995, 1993, 1991, 1990 by The McGraw-Hill Companies, Inc. All rights reserved. Printed in the United States of America. Except as permitted under the United States Copyright
More informationTOOLS for UR44 Release Notes for Windows
TOOLS for UR44 V2.1.2 for Windows Release Notes TOOLS for UR44 V2.1.2 for Windows consists of the following programs. - V1.9.9 - Steinberg UR44 Applications V2.1.1 - Basic FX Suite V1.0.1 Steinberg UR44
More informationES-D400/ES-D350
NPD4650-00 ...4 EPSON Scan... 4 Document Capture Pro Windows... 7 EPSON Scan...10 EPSON Scan...10...14 PDF...15 / EPSON Scan...17 EPSON Scan...17 EPSON Scan...18 EPSON Scan...18 Document Capture Pro Windows...19
More informationC H H H C H H H C C CUTION:These telephones are for use in Japan only. They cannot be used in other countries because of differences in voltages, tele
VE-PV01LVE-PVW01LVE-PVC01L 1 4 7 2 3 5 6 8 9 * 0 # C H H H C H H H C C CUTION:These telephones are for use in Japan only. They cannot be used in other countries because of differences in voltages, telephone
More informationGT-X830
NPD5108-00 ...5... 5... 6... 8...11 EPSON Scan...11 PDF...16 OCR...16...17...17...20 /...20...20...22...23...23...24...25...25...26...27 PDF...30...31 / EPSON Scan...34 EPSON Scan...34 EPSON Scan...36
More informationDS-30
NPD4633-00 JA ...6... 6... 6... 6... 6... 7... 7... 7... 7... 8... 8...9...10...11...11...13 Document Capture Pro Windows...13 EPSON Scan Mac OS X...14 SharePoint Windows...16 Windows...16...17 Document
More informationSystemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows
Systemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows Systemwalker IT Service Management Systemwalker Centric Manager IT Service
More information名称未設定
Parallels Desktop 4.0 for Mac ( 4.0.3810 ) Read Me : 1. Parallels Desktop 2. 3. 4. 5. 6. Parallels Desktop 7. Parallels Desktop 4.0 for Mac 8. Parallels Desktop 9. Parallels Desktop 10. 11. 12. 1. Parallels
More informationGP05取説.indb
E -G V P 05D L V E -G P 05D W Ni-MH + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 1 + 2 + 3 + 4 + 5 + 6 1 2 3 4 5 6 + + + 1 + + + + + + + + + + + + + + + + + + 1 A B C + D + E
More informationX-Form Plug-in Guide
X-Form Plug-in Version 7.2 Copyright 2006 Digidesign, a division of Avid Technology, Inc. All rights reserved. This guide may not be duplicated in whole or in part without the express written consent of
More informationPX-403A
NPD4403-00 ...6... 6...10 Mac OS X...11 Mac OS X v10.5.x v10.6.x...11 Mac OS X v10.4.x...15...18...19...19...21...22!ex...22 /...23 P.I.F. PRINT Image Framer...23...24...27...27...28...28...28...32 Web...32...32...35...35...35...37...37...37...39...39...40...43...46
More informationネットワークビデオレコーダー VK-64/VK-16/VK-Lite v2.2 セットアップガイド
VK-64/VK-16/VK-Lite Ver. 2.2 VK-64 v2.2 VK-16 v2.2 ( VK-64/VK-16) VK-Lite v2.2 ( VK-Lite) VK-64/VK-16 VK-Lite 2 1. 2. 3. 4. 2. 3. ( ) ( ) canon.jp/webview Canon Canon Microsoft Windows Microsoft Internet
More informationXpand! Plug-In Guide
Xpand! Version 1.0 Copyright 2006 Digidesign, a division of Avid Technology, Inc. All rights reserved. This guide may not be duplicated in whole or in part without the express written consent of Digidesign.
More informationべリンガーB-CONTROL
B-CONTROL B-CONTROL B-CONTROL NATIVE INSTRUMENTS as well as the name of companies, institutions or publications pictured or mentioned and their respective logos are registered trademarks of their respective
More information6 4 4 9RERE6RE 5 5 6 7 8 9 4 5 6 4 4 5 6 8 4 46 5 7 54 58 60 6 69 7 8 0 9 9 79 0 4 0 0 4 4 60 6 9 4 6 46 5 4 4 5 4 4 7 44 44 6 44 8 44 46 44 44 4 44 0 4 4 5 4 8 6 0 4 0 4 4 5 45 4 5 50 4 58 60 57 54
More informationIntroduction Purpose The course describes library configuration and usage in the High Performance Embedded Workshop (HEW), which speeds development of
Introduction Purpose The course describes library configuration and usage in the High Performance Embedded Workshop (HEW), which speeds development of software for embedded systems. Objectives Learn the
More informationFaronics Core User Guide
1 2 : 2017 2 1999-2017 Faronics Corporation. All rights reserved. Faronics Deep Freeze Faronics Core Console Faronics Anti-Executable Faronics Device Filter Faronics Power Save Faronics Insight Faronics
More informationP DBPARTNER 3.0 Driver OSWindows 95Windows 98Windows MeWindows NTWindows ( ) ActiveX Microsoft Corp. GIF CompuServe In
DBPARTNER 3.0 Driver 3020-6-073-10 P-2663-5614 DBPARTNER 3.0 Driver 01-02 OSWindows 95Windows 98Windows MeWindows NTWindows 2000 1 (3020-6-073) ActiveX Microsoft Corp. GIF CompuServe Inc. Microsoft Microsoft
More informationPFQX2227_ZA
V E -G P 05D B Ni-MH 1 2 3 4 5 6 1 2 3 4 5 6 A B C D E F 1 2 A B C 1 2 3 2 0 7 9 4 6 6 4 7 9 1 2 3 # 6 6 2 D11 D12 D21 D22 19 # # # # Ni-MH Ω Ω
More information展開とプロビジョニングの概念
ADOBE CREATIVE SUITE 5 2010 Adobe Systems Incorporated and its licensors. All rights reserved. Adobe Creative Suite Deployment and Provisioning Concepts This guide is licensed for use under the terms of
More informationKeySQL R5.1 Release Note
KeySQL for Microsoft Windows 5.1 2005 10 : B19176-02 Copyright 2005, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 5.1 : B19176-02 Copyright 2005,
More informationPSQL_ODBC_Guide.book
PSQL v12 ODBC Guide Using ODBC with PSQL 免責事項 Actian Corporation は 本ソフトウェアおよびドキュメントの使用を 利用者またはその会社に対して 現状のまま で かつ同梱の使用許諾契約書に記載の契約条件によってのみ許諾するものです Actian Corporation は いかなる場合にも本ソフトウェアおよび本マニュアルに記載された内容に関するその他の一切の保証を
More informationEPSON PX-503A ユーザーズガイド
NPD4296-00 ...6... 6...10 Mac OS X...11 Mac OS X v10.5.x v10.6.x...11 Mac OS X v10.4.x...15...18...19...19...21...22...23!ex...23 /...24 P.I.F. PRINT Image Framer...24...25...28...28...29...29...30...33
More informationDDR3 SDRAMメモリ・インタフェースのレベリング手法の活用
WP-01034-1.0/JP DLL (PVT compensation) 90 PLL PVT compensated FPGA fabric 90 Stratix III I/O block Read Dynamic OC T FPGA Write Memory Run Time Configurable Run Time Configurable Set at Compile dq0 dq1
More informationIntroduction Purpose This training course describes the configuration and session features of the High-performance Embedded Workshop (HEW), a key tool
Introduction Purpose This training course describes the configuration and session features of the High-performance Embedded Workshop (HEW), a key tool for developing software for embedded systems that
More informationP3FY-A JP.PDF
P3FY-A002-03 SCSI GP5-148 GP5-148(AcceleRAID 352) 1 1.1 2001 11 OS ( OS ) 4GByte 2 2.1 EzAssist RAID EzAssist Configure RAID Drive Automatic ( )Assisted( ) Custom ( ) 2.2 2000 7 EzAssist Perform Administration
More information橡P3FY-A015-01_A.PDF
P3FY-A015-01 U.S. GOVERNMENT RESTRICTED RIGHTS LEGEND The Software and documentation were developed at private expense and are provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by the Government
More informationGT-X980
NPD5061-00 JA ...6...10...10...11...13...15...20...21...21...22 /...23 PDF...27 PDF...31 /...35...38...43...46 EPSON Scan...49...49...49...50 EPSON Scan...51...51...52...52...53 2 Windows...53 Mac OS X...53...53...53...54...56...56...58...59...60...60...61...62...63
More information取扱説明書_KX-PW100CL
See pages 236 238 for English Guide. KX-PW100CL Ni-MH KX-PW100CL-W KX-FKN100-W 1 2 NTT NTT 1 4 3 4 5 6
More informationPX-504A
NPD4537-00 ...6... 6... 9 Mac OS X...10 Mac OS X v10.5.x v10.6.x...10 Mac OS X v10.4.11...13...15...16...16...18...19...20!ex...20 /...21 P.I.F. PRINT Image Framer...21...22...26...26...27...27...27...31
More informationはじめに
IT 1 NPO (IPEC) 55.7 29.5 Web TOEIC Nice to meet you. How are you doing? 1 type (2002 5 )66 15 1 IT Java (IZUMA, Tsuyuki) James Robinson James James James Oh, YOU are Tsuyuki! Finally, huh? What's going
More informationN manual_JP.PDF
NEC Express5800 - 1 - N8103-73 ESMPRO/ServerManagerServerAgent Power Console Plus Express5800 EXPRESSBUILDER Version 3.077-N(1) Version 3.078a-N 1): - 2 - Windows NT 4.0 Microsoft Windows NT Server 4.0
More information6 4 45 7ZS 5 59 7 8 94 05 4 5 6 4 5 5 6 8 8 40 45 48 56 60 64 66 66 68 7 78 80 8 7 8 0 0 0 90 0 57 64 69 66 66 69 0 4 4 4 4 4 0 7 48 5 4 4 5 4 4 4 7 46 46 6 46 8 46 48 46 46 4 46 46 4 4 5 4 6 4 9 9 0
More informationfiš„v3.dvi
(2001) 49 2 261 275 Web 1 1 2001 2 21 2001 4 26 Windows OS Web Windows OS, DELPHI, 1. Windows OS. DELPHI Web DELPHI ALGOL PASCAL VISUAL BASIC C++ JAVA DELPHI Windows OS Linux OS KyLix Mac OS (ver 10) JAVA
More informationPX-434A/PX-404A
NPD4534-00 ...6... 6...10 Mac OS X...11 Mac OS X v10.5.x v10.6.x...11 Mac OS X v10.4.11...15...18...19...19...21...22!ex...22 /...23 P.I.F. PRINT Image Framer...23...24...26...27...27...28...28...31 Web...31...31...35...35...35...37...37...37...39...39...40...43...48
More information! " # $ % & ' ( ) +, -. / 0 1 2 3 4 5 6 7 8 9 : ; < = >? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ ] ^ _ ` a b c d e f h i j k l m n o p q r s t u v w x y z { } ~ This product is
More informationVer.1 Copyright 2008 Copyright 1995-2008 Trend Micro Incorporated. All Rights Reserved. 2008 3 - 1. 2. 3. 4. 11 5. 1 1 ウイルス / スパイウェア対策 Web 不正侵入対策 / ネットワーク管理 1 フィッシング詐欺 / 迷惑メール対策 Web Web 2 セキュリティ対策ツールが利用できるようになるまでの流れ
More informationMicrosoft Word - D JP.docx
Application Service Gateway Thunder/AX Series vthunder ライセンスキー インストール 手順 1 1.... 3 2. vthunder... 3 3. ACOS... 3 4. ID... 5 5.... 8 6.... 8 61... 8 62 GUI... 10 2 1. 概要 2. vthunder へのアクセス 方法 SSHHTTPSvThunder
More information