Re: AW: SQL output to csv

[Pete Helgren <pete@xxxxxxxxxx>]

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.