Re: Creating a work file with SQL in CL

Hi Bob,

You might also want to check out the faq:

http://faq.midrange.com/index.pl?_highlightWords=runsql&file=322

on how to do this using a source member and the RUNSQLSTM command, and how to create a RUNSQL command to do ad hoc SQL from CL programs.

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

Bob.Voltz@xxxxxxxxxx wrote:

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.


------------------------------------------------------------------------

No virus found in this incoming message.
Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.30/1126 - Release Date: 11/12/2007 12:56 PM