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 tricky.
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: 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. > --
-- http://www.fastmail.fm - mmm... Fastmail... _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.