RE: Howto use fields "by name"

["Lokesh Gupta" <Lokesh.Gupta@xxxxxxxxxx>]

And it will not only check for the key constraints but also build the access 
paths for all the indexes and this can make the INSERT slow... untill unless 
they are *DLY .... 

________________________________

From: rpg400-l-bounces@xxxxxxxxxxxx on behalf of Steve Landess
Sent: Fri 6/11/2004 4:29 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Howto use fields "by name"



Antonio wrote:
> I'm afraid that's not the case, since ALL sentences are just INSERTs, so
> I don't thing an index or view or whatever will do any good to its
> performance. Or, maybe, am I wrong?

Antonio -
The DB2/400 file manager still has to check all of the the unique keys over
the file to determine if you are violating any key constraints before
actually inserting the record.

So I would say it is possible that the answer to your question is yes, you
are wrong...

Steve Landess
Austin, Texas
(512) 423-0935
--
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.