Re: Create table & Create Phisical File

Czarek,

Glad to be of help.

Regards,

Luis Rodriguez

--- rpg400-l-request@xxxxxxxxxxxx wrote:

------------------------------

message: 2
date: Mon, 8 Oct 2007 21:42:39 +0200
from: "Cezary Krzywda" <Cezary.Krzywda@xxxxxxxxxx>
subject: RE: Create table & Create Phisical File


Thank you very much. My program working. I have used
index file like
logical file.

Czarek

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis
Rodriguez
Sent: Monday, October 08, 2007 8:33 PM
To: RpgMidrange
Subject: Re: Create table & Create Phisical File

Czarek,

A SQL index is not usable directly with a SELECT
statement.
AFAIK, SELECT can only reference tables and views (LF
being
a special type of view). If it makes the table or view
access faster, the DB engine will use the index although
you reference only the Table (or view).

That said, you can use a SQL index with any RPG program,
with the proper op codes (CHAIN, SETLL, etc) and it will
work the same as a "traditional" DDS-defined LF. In fact,
a
SQL index has a better performance than a DDS LF.

Hope this helps,

Luis Rodriguez

Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


____________________________________________________________________________________
Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7