Re: Creating a work file with SQL in CL

[Bob.Voltz@xxxxxxxxxx]

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.