I'm receiving this error... yet the program compiles (not sure if it works yet)
SQL0206 10 3984 Position 56 Column or global variable PGMNAME not found
The SQL Insert statement it's referencing is in a subprocedure. The PGMNAME field is defined in the D-specs of the main program as part of the SDS.
I am really trying to use SQL more for IO... but stuff like this can cause a person to regress to native IO.
SQL0206 10 3984 Position 56 Column or global variable PGMNAME not found
The SQL Insert statement it's referencing is in a subprocedure. The PGMNAME field is defined in the D-specs of the main program as part of the SDS.
Code:
Exec Sql Insert into OEBOXCBX(bxridc, bxcom#, bxord#, bxrel#, bxbid#, bxbox#, bxprt#, bxqty#, bxent#, bxsfx#, bxpckr) Values('BX', :inCom#, :inOrd#, :inRel#, :xd.sscc, :wkbox#, :xd.part, :xd.qty, psent#, pssfx#, pgmname);
Comment