| 1 |
+++++ Test for prepnormal +++++ |
| 2 |
insert into test values(:ivar1,:ivar2) |
| 3 |
1 2 |
| 4 |
+++++ Test for execute immediate +++++ |
| 5 |
execute immediate "insert into test values(1,2)" |
| 6 |
1 2 |
| 7 |
+++++ Test for PREPARE ident FROM CString +++++ |
| 8 |
prepare ident_name from "insert into test values(?,?)" |
| 9 |
execute ident_name using :ivar1,:ivar2 |
| 10 |
1 2 |
| 11 |
+++++ Test for PREPARE char_variable_normal_name FROM char_variable +++++ |
| 12 |
prepare :v_normal_name from :v_query |
| 13 |
execute :v_normal_name using :ivar1,:ivar2 |
| 14 |
1 2 |
| 15 |
+++++ Test for PREPARE char_variable_inc_dq_name FROM char_variable +++++ |
| 16 |
prepare :v_include_dq_name from :v_query |
| 17 |
execute :v_include_dq_name using :ivar1,:ivar2 |
| 18 |
1 2 |
| 19 |
+++++ Test for PREPARE char_variable_inc_ws_name FROM char_variable +++++ |
| 20 |
prepare :v_include_ws_name from :v_query |
| 21 |
execute :v_include_ws_name using :ivar1,:ivar2 |
| 22 |
1 2 |
| 23 |
+++++ Test for PREPARE CString_inc_ws_name FROM char_variable +++++ |
| 24 |
prepare "include_ _name" from :v_query |
| 25 |
exec sql execute "include_ _name" using :ivar1,:ivar2 |
| 26 |
1 2 |
| 27 |
+++++ Test for PREPARE CString_normal_name FROM char_variable +++++ |
| 28 |
prepare "norma_name" from :v_query |
| 29 |
exec sql execute "normal_name" using :ivar1,:ivar2 |
| 30 |
1 2 |
| 31 |
+++++ Test for PREPARE ident(typelist) AS +++++ |
| 32 |
prepare ident_name(int,int) as insert into test values($1,$2) |
| 33 |
execute ident_name(:ivar1,:ivar2) |
| 34 |
1 2 |
| 35 |
+++++ Test for PREPARE CString_normal_name(typelist) AS +++++ |
| 36 |
prepare "normal_name"(int,int) as insert into test values($1,$2) |
| 37 |
execute "normal_name"(:ivar1,:ivar2) |
| 38 |
1 2 |
| 39 |
+++++ Test for PREPARE CString_include_ws_name(typelist) AS +++++ |
| 40 |
prepare "include_ _name"(int,int) as insert into test values($1,$2) |
| 41 |
execute "include_ _name"(:ivar1,:ivar2) |
| 42 |
1 2 |
| 43 |
+++++ Test for PREPARE char_variable_normal_name(typelist) AS +++++ |
| 44 |
prepare :v_normal_name(int,int) as insert into test values($1,$2) |
| 45 |
execute :v_normal_name(:ivar1,:ivar2) |
| 46 |
1 2 |
| 47 |
+++++ Test for PREPARE char_variable_include_ws_name(typelist) AS +++++ |
| 48 |
prepare :v_include_ws_name(int,int) as insert into test values($1,$2) |
| 49 |
execute :v_include_ws_name(:ivar1,:ivar2) |
| 50 |
1 2 |
| 51 |
+++++ Test for EXECUTE :v_normal_name(const,const) +++++ |
| 52 |
prepare :v_normal_name from :v_query |
| 53 |
execute :v_normal_name(1,2) |
| 54 |
1 2 |
| 55 |
+++++ Test for EXECUTE :v_normal_name(expr,expr) +++++ |
| 56 |
prepare :v_normal_name from :v_query |
| 57 |
execute :v_normal_name(0+1,1+1) |
| 58 |
1 2 |
| 59 |
+++++ Test for combination PREPARE FROM and EXECUTE ident(typelist) +++++ |
| 60 |
prepare ident_name from :v_query |
| 61 |
execute ident_name(:ivar1,:ivar2) |
| 62 |
1 2 |
| 63 |
+++++ Test for combination PREPARE FROM and EXECUTE CString_include_ws_name(typelist) +++++ |
| 64 |
prepare "include_ _name" from :v_query |
| 65 |
execute "include_ _name"(:ivar1,:ivar2) |
| 66 |
1 2 |