RE: Create DDL from exiting PF&LFs

Joe, Jon,

thanks for comments.

I did some tests, trying to get performance boost from SQL created files ...

No success as yet (I was experimented with the file with decimal and character 
fields, 5 millions records, unique index of decimal field, RPG program setll 
and read 100 record starting from random key x 100k = 10 millions reading in 
total).

There are a couple of good points:
1. write and update operations don't slow down.
2. the file created with the same structure (using Ted Holts tool) has the same 
member's identification level (no recompilation needed for RPG programs)

>From the other side, for our bosses IBM has a reputation as a hairiest level 
>of IT consultant, so I just have implement it.

Dmitri Efimov






-----Mensaje original-----
De: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]En nombre de Jon Paris
Enviado el: Domingo, 03 de Julio de 2005 01:16 p.m.
Para: midrange-l@xxxxxxxxxxxx
Asunto: RE: Create DDL from exiting PF&LFs


Thanks for the reference Joe.

It is an interesting article and answers a number of questions relating to
some of the rumors floating around that I hadn't had time to check out.

  >> The old-style DDS files do the checking on the read.

This is the only problem I have with the piece.  As far as I know the DB
does not do any checking.  The application itself simply "blows up" when
attempting to use the bad data.  That's why COBOL apps don't suffer as badly
as RPG from DD errors - if they don't touch the field they don't blow up.
RPG on the other hand moves every field from the buffer to its storage
location.  It is that move that causes the explosion on the read.

I do agree though that having it done on the write is great - wonder what
error RPG signals if the data is bad?  I'll write a test case sometime when
I have 5.


Jon Paris
Partner400

www.Partner400.com
www.RPGWorld.com


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


Aviso Banco Wiese Sudameris

Este mensaje es privado y confidencial y solamente para la
persona a la que va dirigido. Esta sujeto a los terminos que
aparecen en  http://www.bws.com.pe/aviso.shtml los cuales
forman parte de su contenido.