Re: AW: SQL output to csv

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

You can use CREATE ALIAS to point to the member you want and then execute 
your SQL in the source member on the ALIAS instead of the table.  After 
you have done your RUNSQLSTM just DROP ALIAS & then CREATE ALIAS  over the 
next member, rinse & repeat...


Thanks,
Tommy Holden



From:   Pete Helgren <pete@xxxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   12/04/2013 08:55 AM
Subject:        Re: AW: SQL output to csv
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



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.