RE: SQL Statement length

"As another "fly in the ointment"....we're running V5R4"

So what I have done for my extra-large queries is to load them into a compile time array then read the array into the varying character field then use that carrying char field as would other dynamic statement variables.

In 5.4 format

D QRY_STMT S 100a DIM(100) CTDATA
D STMTSQL S 32740a Varying
D IDX S 10I 0
...
For IDX = 1 to %ELEM( QRY_STMT ) by 1;
STMTSQL += %TRIM( QRY_STMT( IDX ) ) +' ';
Endfor;
...
// Follow normal prep, declare, open, fetch and close procedures.

** - QRY_STMT
select field1, field2, field3, field4
from mytable
where field1 = 'A'





Thanks, Matt