|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.