RE: Even more embedded SQL....

What about using many subfiles each based on a different logical?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, August 03, 2006 9:53 AM
To: RPG programming on the AS400 / iSeries
Cc: RPG programming on the AS400 / iSeries;
rpg400-l-bounces@xxxxxxxxxxxx
Subject: Even more embedded SQL....


 

 

 

 

 

  Hi All,

  I have been given a project that requires the need to display, within
a subfile, the data from 2 
  separate files with the ability to sort that data from any number of
different columns. So I     
  thought to myself, this smacks of embedded SQL and Dynamic Sorting
Subfiles. The unfortunate     
  thing is that the data I have to display is over 15,000 records long
(and growing) so if anyone  
  can help me, I am looking for an example of embedded SQL and Dynamic
Sorting Subfiles - Page at  
  a time (with the ability to position to a particular piece of data)"

  Some title for an article huh? If anyone has an example of what is
required, or could point me   
  in some direction, I would be very grateful.

 

 

 







Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx