You're welcome.  And if you need some tricky logic that's easier for you 
to do in RPG, then use a UDF or a stored procedure.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





michaelr_41@xxxxxxxxxxxxxx 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/19/2004 01:29 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: SQL Vs. RPG Opinions






Thanks to all...

- Michael

On Fri, 19 Mar 2004 13:26:25 -0500, rob@xxxxxxxxx said:
> Depends on who you ask  :-)
> 
> If you can really get your ducks in a row you might even be able to play 

> with stuff like CONNECT TO, etc and update the remote files directly and 

> bypass the comma delimited.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> michaelr_41@xxxxxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 03/19/2004 11:51 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> cc
> 
> 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?
> -- 
> 
>   michaelr_41@xxxxxxxxxxxxxx
> 
> -- 
> http://www.fastmail.fm - One of many happy users:
>   http://www.fastmail.fm/docs/quotes.html
> _______________________________________________
> 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.
> 
-- 
 
  michaelr_41@xxxxxxxxxxxxxx

-- 
http://www.fastmail.fm - IMAP accessible web-mail
_______________________________________________
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.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2022 by midrange.com 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.