1 1. create table T1 with 11 fields.
2 insert some records into it.
3 noOfParamFields() should return 11.
4 getParamFldInfo() for all fields and print the field info.
5 select * from T1; (sqlapi/Parameter/paratest1.c to be modified for varchar field)
7 2. create table T1 with 11 fields.
8 insert some records into it.
9 select * from T1 with where clause; (sqlapi/Parameter/paratest2.c to be modified for varchar field)
11 3. create table T1 with 11 fields.
12 insert some records into it.
13 delete records from T1 with where clause
14 select * from T1; (sqlapi/Parameter/paratest3.c to be modified for varchar field)
16 4. create table T1 with 11 fields.
17 insert some records into it.
18 update T1 WITH ALL PARAMETERS.
19 noOfParamFields() should return 11.
20 select * from T1; (sqlapi/Parameter/paratest4.c to be modified for varchar field)
22 5. create table T1 with 11 fields.
23 insert some records into it with null values
24 delete records from T1 with where clause.
26 for the below 3 line (sqlapi/Parameter/paratest5.c and to be modified for varchar field)
27 update records into some value using where with is null, is not null.
28 delete some records using where with is null, is not null.
31 6. create table T1 with 11 fields.
32 insert some records into it.
33 update T1 with some Null values in the parameter.
34 noOfParamFields() should return 11.
35 select * from T1; (sqlapi/Parameter/paratest6.c to be modified for varchar field)
37 7. select tuple with WHERE clause having param for some fields
38 Create a table having f1 date, f2 tnt and f3 string
40 Execute SELECT * FROM T1 WHERE f1='Date Value' AND f2=? AND f3=?; (sqlapi/Parameter/paratest7date.c)
42 8. select tuple with WHERE clause having param for some fields
43 Create a table having f1 date, f2 tnt and f3 string
45 Execute SELECT * FROM T1 WHERE f1='now' AND f2=? AND f3=?; (sqlapi/Parameter/paratest7now.c)
47 9. Primary key foreign key test (insert , update, delete ) using parameterised statement for all. (new script to be written)
49 10. Insert,update,delete records of copied table, should be passed using parameterised statement. (new script to be written)
51 11. All Predicate test for all all datatypes using parameterised statement on select statement. (new script to be written)
53 12. Aggregate with having using parameterised statement. (new script to be written)