[Data Source Name]
DSN=xxx;UID=lxxx;PWD=xxx

#[SQLFetch and SQLExtendedFetch Test]
DROP TABLE ODBCAPITEST1
CREATE TABLE ODBCAPITEST1 (COLA INT, COLB VARCHAR(30))
INSERT INTO ODBCAPITEST1 VALUES(21, 'String-2')
INSERT INTO ODBCAPITEST1 VALUES(27, 'String-5')
INSERT INTO ODBCAPITEST1 VALUES(50, 'String-3')
INSERT INTO ODBCAPITEST1 VALUES(46, 'String-1')
INSERT INTO ODBCAPITEST1 VALUES(19, 'String-4')
SELECT * FROM ODBCAPITEST1 ORDER BY COLB

[Bulk Insert Test]
DROP TABLE BULKTEST1
CREATE TABLE BULKTEST1 (COLA INT, COLB INT)
INSERT INTO BULKTEST1 VALUES (123, 456)
DROP TABLE BULKTEST2
CREATE TABLE BULKTEST2 (COLA INT, COLB INT)
SELECT * FROM BULKTEST1
INSERT INTO BULKTEST2 VALUES (?,?)
SELECT * FROM BULKTEST2

#[Max Row Count Test]
*RowCount = 3
DROP TABLE ODBCAPITEST2
CREATE TABLE ODBCAPITEST2 (COLA INT, COLB VARCHAR(30))
INSERT INTO ODBCAPITEST2 VALUES (23, 'String-5')
INSERT INTO ODBCAPITEST2 VALUES (37, 'String-3')
INSERT INTO ODBCAPITEST2 VALUES (45, 'String-1')
INSERT INTO ODBCAPITEST2 VALUES (10, 'String-2')
INSERT INTO ODBCAPITEST2 VALUES (29, 'String-4')
SELECT * FROM ODBCAPITEST2 ORDER BY COLA

#[SQLTransact Test]
Drop Table ODBCAPITEST3
CREATE TABLE ODBCAPITEST3 (COLA INT, COLB VARCHAR(50))
INSERT INTO ODBCAPITEST3 VALUES (1, 'DEFaaaaa')
INSERT INTO ODBCAPITEST3 VALUES (2, 'DEFaaaaaaaaaa')
Select * from ODBCAPITEST3

#[SQL Catalog Test]
TableQualifier = 
TableOwner = 
*TableName = LU_YEAR
*ColumnName = YEAR_ID

#[SQL Comment Test]
Y

#[Latin Characters Test]
DROP TABLE TEST_LATIN1
CREATE TABLE TEST_LATIN1(COLA int, COLB varchar(50))
INSERT INTO TEST_LATIN1 VALUES (1, '!"#$%&()*+,-./01234')
INSERT INTO TEST_LATIN1 VALUES (2, '56789:;<=>?@ABCDEFGH')
INSERT INTO TEST_LATIN1 VALUES (3, 'IJKLMNOPQRSTUVWXYZ[\')
INSERT INTO TEST_LATIN1 VALUES (4, ']^_`abcdefghijklmnop')
INSERT INTO TEST_LATIN1 VALUES (5, 'qrstuvwxyz{|}~--')
SELECT * FROM TEST_LATIN1 ORDER BY COLA

#[Unicode Test]
DROP TABLE TESTWCHAR
CREATE TABLE TESTWCHAR (COLA varchar(25))
TestFile = ORACLE_ISO15.txt

#[Query Timeout Test]
*SetTime = 1
Drop Table ODBCAPITEST4
CREATE TABLE ODBCAPITEST4 (COLA INT)
Insert into ODBCAPITEST4 Select MAX(A.ORDER_ID) FROM LU_ORDER A, LU_ORDER B WHERE A.CUSTOMER_ID<>B.CUSTOMER_ID

#[SQLCancel Test]
Drop Table ODBCAPITEST5
CREATE TABLE ODBCAPITEST5 (COLA INT)
Insert into ODBCAPITEST5 Select MAX(A.ORDER_ID) from LU_ORDER A, LU_ORDER C, LU_ORDER B, LU_ORDER D, LU_ORDER E, LU_ORDER F, LU_ORDER G WHERE A.CUSTOMER_ID<>B.CUSTOMER_ID AND A.CUSTOMER_ID<>C.CUSTOMER_ID AND D.CUSTOMER_ID=C.CUSTOMER_ID AND B.CUSTOMER_ID<>E.CUSTOMER_ID AND A.CUSTOMER_ID<>E.CUSTOMER_ID AND F.CUSTOMER_ID<>G.CUSTOMER_ID

#[SQL Limits Test]
Y

#[Delete From Test]
Y

#[Test for Oracle Only]
Y
NOTE: 1. Date Format Test:Please manually update the registry value (IgnoreODBCTimeStampLiteral = 1) for the driver DSN; 2. TQMS 236556 Test: Please create DSN:ts-oracle10g, uid/pwd: siva/siva, add the following strings to the data source in the registry (hkey_local_machine\software\odbc\odbc.ini\<specific dsn>) and set the value to 1: ColumnSizeAsCharacter and ColumnsAsChar


#[Test for DB2UDB Only]
Y
NOTE: Please create DSN:tsdb22, uid/pwd: ts5nov9/ts5nov9, db: aurep, port: 50015, server: tsdb22

#[Miscellaneous Test]
<Test 1>
drop table test1
create table test1 (col int)
insert into test1 values (1)
select * from test1

<Test 2>
drop table test2
create table test2 (col int)
insert into test2 values (1)
select * from test2