Thanks, Chuck...
I'm kinda new here and I didn't realize that "EXECUTE" was SEQUEL specific.
I've never worked with SEQUEL before, I was just looking at an example that
someone else wrote.
To solve my problem, I wrote an RPG program with embedded SQL to create my
work file.
Thanks to all who responded.
bv
CRPence
<crp@xxxxxxxxxxxx
.ibm.com> To
Sent by: midrange-l@xxxxxxxxxxxx
midrange-l-bounce cc
s@xxxxxxxxxxxx
Subject
Re: Creating a work file with SQL
11/12/2007 01:19 in CL
PM
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
The OP stated SQL versus SEQUEL, but presumably the SEQUEL/EXECUTE
command is being used. The *MSGF QSYS/QQRYMSG is for the 5722QU1 Query
for iSeries product [aka Query/400], which is a report writer only, and
does not support SQL [syntax]. The *MSGF SEQUEL/DBIOMSG shows QRY2211
as "Parameter required for OUTFILE, TOFLR, or TOSTMF", so apparently
somewhere after the closing apostrophe and parenthesis for "blah,
blah...", there should be an OUTFILE(specified)
Regards, Chuck
--
All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor views of my
employer
rob@xxxxxxxxx wrote:
Bob.Voltz@xxxxxxxxxx wrote:
Could someone give me an example of creating an empty file with SQL
in a CL program?
Something like: EXECUTE SQL('CREATE TABLE QTEMP/WORKFILE blah,
blah, blah.....
I keep getting a QRY2211 error no matter what i try....
WRKMSGD MSGID(QRY2211) MSGF(QQRYMSG) <<SNIP>>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com
