1 /* prepare,execute,free,prepare, second prepare should pass.
8 AbsSqlConnection
*con
= createConnection();
9 rv
= con
->connect("root","manager");
12 AbsSqlStatement
*stmt
= createStatement();
13 stmt
->setConnection(con
);
16 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 CHAR(20));");
17 if(strcmp(getenv("DSN"),"db2")==0)
18 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 CHAR(20))");
21 rv
= stmt
->prepare(statement
);
28 printf("Prepare the Statement\n");
29 rv
= stmt
->execute(rows
);
36 printf("Execute the Statement\n");
39 printf("free all the resources\n");
42 strcpy(statement
,"DROP TABLE t1;");
43 if(strcmp(getenv("DSN"),"db2")==0)
44 strcpy(statement
,"DROP TABLE t1");
45 rv
= stmt
->prepare(statement
);
48 printf("Test script failed\n");
53 printf("Again prepare passed\n");
56 rv
= stmt
->execute(rows
);
57 if(rv
==OK
)printf("Table dropped successfully\n");