RE: Subfile loading time tips needed

Steve,

If you're asking if you can use embedded SQL in your ILE RPG program, then
yes, this is possible.  You can find documentation on this in the iSeries
Information Center, or in many online forums, including the Midrange-L
archives.  

More to the point, does your iSeries have the IBM SQL licensed program
loaded?  To see, use DSPSFWRSC to view a list of installed products.  You'll
need to look for one (actually, two entries in this list) with text similar
to this:

"DB2 Query Manager and SQL Development Kit for AS/400"

If that product is loaded, then you can use embedded SQL in your RPG source
code.

If not, then you could use SQL CLI in your RPG source to utilize SQL.  This
one is quite a lot of work to learn....

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of steema@xxxxxxxxxxxxx
Sent: Wednesday, January 04, 2006 7:17 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Subfile loading time tips needed


IOW, I would like to use the SQL unique attribute for this file, as this
would cut down on the # of recs to read.
Can this be done w/ in the RPG ?
> HI I have a subfile that I am building in full, bec. there are some
> related factors between records. If there is for example, a BOL number,
> this same BOL could appear later on, and it is desired to have it grouped
> together, in the subfile. But this way, takes some time. There is a
> definete pause of a few seconds, for each load, for each F12, etc...
>
> Perhaps I am lacking some understanding of subfiles so as to speed this
> up?
>
> Steve
> --
> 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.
>
>