1 /* prepare,execute,prepare....,
2 * second prepare should pass.
9 AbsSqlConnection
*con
= createConnection();
10 rv
= con
->connect("root","manager");
13 AbsSqlStatement
*stmt
= createStatement();
14 stmt
->setConnection(con
);
17 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 CHAR(20));");
18 if(strcmp(getenv("DSN"),"db2")==0)
19 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 CHAR(20))");
22 rv
= stmt
->prepare(statement
);
29 printf("Prepared the statement\n");
31 rv
= stmt
->execute(rows
);
38 printf("Execute the statement\n");
43 strcpy(statement
,"DROP TABLE t1;");
44 if(strcmp(getenv("DSN"),"db2")==0)
45 strcpy(statement
,"DROP TABLE t1");
46 rv
= stmt
->prepare(statement
);
49 printf("Test script failed\n");
53 printf("Test script passed\n");