LOL Luis - it is hard to be so powerful, isn't it? I see you with your red cape and the big S for Superuser on your chest! Make that lowercase big s for superuser. -------------- Original message -------------- From: Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>
Vern, You are right in stating that it is better to use the views (either IBM's or defined by you). AFAIK, the reason IBM tells you not to use the files directly is not because of performance. If that would be the case, the views would be off-limits too. As I remember, the main reasons giving for not using these files directly are: 1) The files are restricted (security privileges) for use of the Security Officer only. The views don't have this restriction. 2) The format of the files can (and do) change with each release and/or DB2 update, so it is better to have a view with a format that you know. My problem is that I am the Sec officer for our 520, so I tend to overlook this kind of things :-) Regards, Luis Rodriguez --- midrange-l-request@xxxxxxxxxxxx wrote:------------------------------ message: 6 date: Mon, 20 Nov 2006 17:31:06 +0000 from: vhamberg@xxxxxxxxxxx subject: Re: Re: Saving multiple source files to a single save Well, first, because IBM says not to. They say to go through the views in QSYS2. The QADB* files are used by the system so much, I guess. And maybe it is OK to make other views over these files. So if there are other ways to get the same info, I go the other way. Cheers VernLuis Rodriguez IBM Certified Systems Expert eServer i5 iSeries Technical Solutions ________________________________________________________________________________ ____ Sponsored Link Mortgage rates near 39yr lows. $310k for $999/mo. Calculate new payment! www.LowerMyBills.com/lre -- 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.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact