It will be something that will execute on a nightly basis. I'll be
refreshing the target database every night. Also, the logic is a bit

On Fri, 19 Mar 2004 11:07:36 -0600, "Elvis Budimlic"
<ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> said:
> If it's a one time shot why write programs?
> I find it much easier to write SQL for this kind of work. It's quick and
> flexible.  
> You can save your SQL statements into a source member and execute them as
> a
> script using RUNSQLSTM later on if the need for this arises again.
> Elvis
> -----Original Message-----
>  Subject: SQL Vs. RPG Opinions
> I have a need to populate many files from an established iSeries
> database. I would normally write some RPG/IV code to get the data I need
> and write to the files - standard stuff. However, these files are going
> to mimic a relational structure on a different system - after I create
> the files, I'll convert them to comma delimited format and send them to
> the target system where they'll be used as input for tables.
> So, I'm really creating tables on my iSeries and sending them to the
> other system. Should I use SQL to do this? I've used SQL to create the
> tables and I could develop the SQL to populate the tables, but I'm
> wondering if it even makes sense to do this. 
> Thoughts?
> _______________________________________________
> 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:
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at

-- - mmm... Fastmail...

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.