Re: Creating a work file with SQL in CL

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

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
>