Re: SQL from CL program

["Mike Naughton" <mnaughton@xxxxxxxxxxxx>]

I think this question belongs more properly on the Midrange-L list, but
here goes:

you can use the INSERT INTO clause to place the results of a SQL select
into a file (may or may not be the same file as the SELECT is over), but
remember:

1) it must have been created first (can't create a new file on the fly)

2) either a) it must be journalled, or b) you must turn off commitment
control

Also, you can place several SQL statements (to be run sequentially) in the
member referenced by RUNSQLSTM -- just be sure each one is terminated by a
semi-colon (;).

hth

rpg400-l@midrange.com writes:
>I am calling SQL statement from CL program and it is working fine but I
>want
>to write SQL generated result in the file. Is there way to do it? Please
>help.
>
>
>Amir Raza Khan


Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com