db2, sqlrpgle program, difficulties with sintax sql
Posted on 2011-03-07
I'm programming with sqlrpgle,
I have some syntax problem..
look at this:
c *entry plist
c parm fromart 13
c parm toart 13
c+ with tmp as
c+ ( select * from qs36f/artordimp
c+ where i$pn between :fromart and :toart)
C+ create table qs36f/ordcli as
C+ with data
C SETON LR
How to use "with" statment and "create_table" in the same program?
I decide to use "with statment" only beacuse the compiler says
that I cannot use parameters in "create table" statment,
How to make this program work?