AW: SQL output to csv

[Pete Helgren <pete@xxxxxxxxxx>]

Birgitta,

Does it support MONMSG?  I can work around some of the overrides, etc in 
the SQL script but MONMSG is a cheap way of ignoring errors. I am seeing 
either that MONMSG is not supported or an error that the parameter MSGID 
is invalid in the script I am attempting. Perhaps an example where 
MONMSG is used?

Pete Helgren
www.petesworkshop.com
GIAC Secure Software Programmer-Java

On 12/4/2013 9:06 AM, Birgitta Hauser wrote:
> Hi Pete,
>
> It is possible to perform any CL command (that does not need an output
> screen).
> So it is possible executing an OVRDBF command just before the SELECT
> command.
> You simply have to prefix the CL command with CL: and end it with semi colon
> (;), It is even possible prompting the CL command with the F4 function key.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
>
> -----Ursprüngliche Nachricht-----
> Von: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Pete Helgren
> Gesendet: Wednesday, 04.12 2013 15:54
> An: Midrange Systems Technical Discussion
> Betreff: Re: AW: SQL output to csv
>
> Birgitta and Rob,
>
> I haven't used either fat or thin client of iNav do SQL'ish things before.
> Is there a way to set overrides for file members using that interface?
> RUNSQLSTM could be run after the file overrides are set but again it would
> be at least a two stepper: Create the file and then copy it to the IFS.
>
> I'll take a look at iNav and see about the file member stuff as well.
>
> Thanks!
>
> Pete Helgren
> www.petesworkshop.com
> GIAC Secure Software Programmer-Java
>
> On 12/4/2013 7:54 AM, Birgitta Hauser wrote:
> > Hi Pete,
> >
> > If it's only a one shot, you may use IBM i Navigator - Database - Run
> > an SQL Script.
> > Open Options and select Allow Save Results
> >
> > Then execute your queries, position on the result, right click and
> > SAVE RESULTS.
> >
> > Mit freundlichen Grüßen / Best regards
> >
> > Birgitta Hauser
> >
> > "Shoot for the moon, even if you miss, you'll land among the stars."
> > (Les
> > Brown)
> > "If you think education is expensive, try ignorance." (Derek Bok)
> > "What is worse than training your staff and losing them? Not training
> > them and keeping them!"
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Pete Helgren
> > Gesendet: Wednesday, 04.12 2013 14:45
> > An: Midrange Systems Technical Discussion
> > Betreff: SQL output to csv
> >
> > I need to extract data from a few tables and create a csv file.  I
> > sorted out the SQL to select the data but the only way I can think of
> > getting csv output is to create a table and then use an insert
> > statement to write the data into the table and then use cpytoimpf to
> > create the csv.  Making things more interesting is that the source files
> are multi-membered.
> > Any shortcuts here?  I can override the files used as input and wrap
> > the whole thing in a CL command but if someone knows of a better way,
> > I am all ears. Running IBM i 7.1 if it makes a difference.
> >
> > --
> > Pete Helgren
> > www.petesworkshop.com
> > GIAC Secure Software Programmer-Java
> >
> > --
> > 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.
> --
> 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.