Re: keys on 2 joined files?

[rob@xxxxxxxxx]

When I get a minute I'll ship you a sample.  Right now the job calleth.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




WyvernGod@xxxxxxx
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/18/2003 10:22 AM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     rpg400-l@xxxxxxxxxxxx
        cc: 
        Fax to: 
        Subject:        Re: keys on 2 joined files?


In a message dated 3/18/2003 10:06:12 AM US Eastern Standard Time, 
rob@xxxxxxxxx writes:

> You do know how to process a cursor with imbedded SQL, eh? 
> If not, samples are available upon request.
> 

In all honesty no I don't.  My situation is this.  I have had a 2 week 
course 
on as/400 operations and a 12 week couse in COBAL/400 and 12 weeks in 
RPG/400 
IV   and 1 year on the job here Problem is.. I'm working at a company with 

only RPG III so i'm pretty stuck with limited resources here.. I dont even 

think they have SQL/400 ,but they might cause i can access STRSQL and i 
beleave thats part of sql/400 if im not mistaken.  I think i may have a 
answer to my problem "if all else fails'  they rarely request all sections 
so 
I'm thinking of creating a rpg program that will build an temp extract 
file 
that will hold information to be reported on and have a logical key that 
for 
the name sorting process. that way i wont have to make a modification to 
the 
origanal base program. I guess a preprocessor of sorts.  The origanal 
program 
only takes about 5 seconds to run a normal request.. But i'm always 
willing 
to test out the sql option.  Just need a little background info on how to 
do 
so. 

Thanx,
Chris
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.