RE: SFL Load - SQL vs. LF

["Mohammad, Tanveer" <TMohammad@xxxxxxxxxxx>]

Is there anyone who can explain this? Data Validation code!  Or point to
the original article? 

Thanks 
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
Sent: Wednesday, September 07, 2005 4:22 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SFL Load - SQL vs. LF

IBM has changed the data management rules for files created via DDL,
which
effective improves DB thruput for all applications using the file.
Performance gains come from where IBM has chosen to implement the data
validation code.  Under DDS rules, data is validated when it is read
from
the disk, where DDL moves the validation to DB writes and updates.

The theory is that a typical application will read data much more than
it
writes data.  If we validate on write, then we've reduced IO overhead.

iSeriesNetwork had an article about this.....

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



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of James H H Lampert
Sent: Wednesday, September 07, 2005 1:09 PM
To: Midrange Systems Technical Discussion
Subject: Re: SFL Load - SQL vs. LF


Billy Rowe <billyrowe@xxxxxxx> wrote:
> No matter which presentation method you decide to you, 
> definitely create the tables/indexes/views with SQL.

Why?

--
JHHL
(who is much more fluent in DDS and OPNQRYF than with SQL)