Re: Multiple file entries for the same file

[rob@xxxxxxxxx]

What keys, if any are on the file?

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




CarollaT@xxxxxxxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/19/2003 12:36 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Fax to

Subject
Re: Multiple file entries for the same file






<clip>
Is this the result you are looking for?
</clip>

That is a workable solution.  The problem is that, if the file is already
open, how to open it again to populate the temporary SQL file?  I want to 
be
looking for these renewed contract records while I am stepping through the
same file, looking for the expired ones. 

We don't have the SQL lic pgms, but I can use CWBUNDBS.EXE to create the
tables, and then use RPG to populate them.  The issue is that this would
need to be done for each dataset library, and my idea was to really
streamline the process without having to create too many copies of the 
data.


Thanks just the same! 

Tony Carolla
MedAmerica Billing Services, Inc. 
_______________________________________________
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.