RE: Simple Display file problem

Note that this entire article is about exactly what Joe was talking
about.

--Instead of using DDS to define your physical files, you should be
using SQL DDL.

--Create appropriate SQL indexes

--recreate DDS keyed logicals needed by RPG programs so that the keyed
logical shares the 64k access path from one of the SQL indexes.

--all of the above can be done without needed to recompile your current
RPG apps.

--You can continue to use native RPG I/O with an SQL DDL defined
database and see significant improvements over a DDS defined database.

--The article says nothing about native RPG I/O vs. SQL I/O.




HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx 
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Wednesday, September 20, 2006 9:00 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Simple Display file problem

<snip>

This has some interesting details.....
http://www-03.ibm.com/servers/eserver/iseries/db2/pdf/Performa
nce_DDS_SQ
L.pdf#search=%22iseries%20ddl%20vs%20dds%20performance%22
</snip>

 

I think this article says it all or at least a hell of lot better than
me. This is one of the articles from IBM on SQL and DDS that were
originally published in Iseries Network. Thanks.

 

 

-- 
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.