RE: QADBXREF question

rpg400-l-request@xxxxxxxxxxxx wrote:

>  10. Re: QADBXREF question (Dave Thurston)
>
>I wrote a different program that just read the QADBXREF file and printed a
>report.    When I ran the program I got a program error which eventually
>told me the record I was reading had null fields.

Dave:

Sometime years ago, when all the system SQL catalog views were being made 
available, I'd swear I saw some IBM document recommending not to read QADBXREF 
and similar physical files directly, but rather to access the data through the 
views provided by IBM. At the time, the risk was in having locks against the 
files while data management was trying to keep those files maintained.

Enough years and OS/400 versions/releases have gone by that it might not be 
relevant anymore, and it might have just been a CYA warning from IBM back then. 
However, I still leave the base files alone and always use whatever view is 
appropriate... just in case. Some bug could reappear at any time. It just seems 
reasonable.

Tom Liotta

-- 
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com



__________________________________________________________________
Introducing the New Netscape Internet Service. 
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need. 

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp