1 //Test for table exist in tdb or not
5 #include <SqlOdbcStatement.h>
9 AbsSqlConnection
*con
= createConnection();
10 rv
= con
->connect("root","manager");
12 printf("Connection opened\n");
14 AbsSqlStatement
*stmt
= createStatement();
15 stmt
->setConnection(con
);
17 if(strcmp(getenv("DSN"),"oracle")==0)
18 strcpy(statement
,"CREATE TABLE t1(f1 number(9),f2 number(9),primary key(f1));");
19 else if(strcmp(getenv("DSN"),"db2")==0)
20 strcpy(statement
,"CREATE TABLE t1(f1 INT NOT NULL,f2 INT,primary key(f1))");
22 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 INT,primary key(f1));");
25 rv
= stmt
->prepare(statement
);
26 if(rv
!=OK
) { delete stmt
; delete con
; return 2; }
28 rv
= stmt
->execute(rows
);
29 if(rv
!=OK
) { delete stmt
; delete con
; return 3; }
31 printf("Table t1 CREATED\n");
33 // insert into statement
34 printf("TableExists in Tdb Testing Starts Here\n");
36 SqlOdbcStatement
*oStmt
= (SqlOdbcStatement
*)stmt
;
37 bool tabflag
=oStmt
->isTableExists("t1");
40 printf("Table t1 exists in TDB\n");
42 printf("Table t1 does not exists in TDB\n");
46 strcpy(statement
,"DROP TABLE t1;");
47 if(strcmp(getenv("DSN"),"db2")==0){
48 strcpy(statement
,"DROP TABLE t1");
50 rv
= stmt
->prepare(statement
);
57 rv
= stmt
->execute(rows
);
65 tabflag
=oStmt
->isTableExists("t1");
68 printf("Table t1 exists in TDB\n");
70 printf("Table t1 does not exists in TDB\n");
73 printf("Table droped\n");