1+++++ Test for prepnormal +++++
2insert into test values(:ivar1,:ivar2)
31 2
4+++++ Test for execute immediate +++++
5execute immediate "insert into test values(1,2)"
61 2
7+++++ Test for PREPARE ident FROM CString +++++
8prepare ident_name from "insert into test values(?,?)"
9execute ident_name using :ivar1,:ivar2
101 2
11+++++ Test for PREPARE char_variable_normal_name FROM char_variable +++++
12prepare :v_normal_name from :v_query
13execute :v_normal_name using :ivar1,:ivar2
141 2
15+++++ Test for PREPARE char_variable_inc_dq_name FROM char_variable +++++
16prepare :v_include_dq_name from :v_query
17execute :v_include_dq_name using :ivar1,:ivar2
181 2
19+++++ Test for PREPARE char_variable_inc_ws_name FROM char_variable +++++
20prepare :v_include_ws_name from :v_query
21execute :v_include_ws_name using :ivar1,:ivar2
221 2
23+++++ Test for PREPARE CString_inc_ws_name FROM char_variable +++++
24prepare "include_ _name" from :v_query
25exec sql execute "include_ _name" using :ivar1,:ivar2
261 2
27+++++ Test for PREPARE CString_normal_name FROM char_variable +++++
28prepare "norma_name" from :v_query
29exec sql execute "normal_name" using :ivar1,:ivar2
301 2
31+++++ Test for PREPARE ident(typelist) AS +++++
32prepare ident_name(int,int) as insert into test values($1,$2)
33execute ident_name(:ivar1,:ivar2)
341 2
35+++++ Test for PREPARE CString_normal_name(typelist) AS +++++
36prepare "normal_name"(int,int) as insert into test values($1,$2)
37execute "normal_name"(:ivar1,:ivar2)
381 2
39+++++ Test for PREPARE CString_include_ws_name(typelist) AS +++++
40prepare "include_ _name"(int,int) as insert into test values($1,$2)
41execute "include_ _name"(:ivar1,:ivar2)
421 2
43+++++ Test for PREPARE char_variable_normal_name(typelist) AS +++++
44prepare :v_normal_name(int,int) as insert into test values($1,$2)
45execute :v_normal_name(:ivar1,:ivar2)
461 2
47+++++ Test for PREPARE char_variable_include_ws_name(typelist) AS +++++
48prepare :v_include_ws_name(int,int) as insert into test values($1,$2)
49execute :v_include_ws_name(:ivar1,:ivar2)
501 2
51+++++ Test for EXECUTE :v_normal_name(const,const) +++++
52prepare :v_normal_name from :v_query
53execute :v_normal_name(1,2)
541 2
55+++++ Test for EXECUTE :v_normal_name(expr,expr) +++++
56prepare :v_normal_name from :v_query
57execute :v_normal_name(0+1,1+1)
581 2
59+++++ Test for combination PREPARE FROM and EXECUTE ident(typelist) +++++
60prepare ident_name from :v_query
61execute ident_name(:ivar1,:ivar2)
621 2
63+++++ Test for combination PREPARE FROM and EXECUTE CString_include_ws_name(typelist) +++++
64prepare "include_ _name" from :v_query
65execute "include_ _name"(:ivar1,:ivar2)
661 2
67