Re: FWD: AS400 "Object Xref" File? Thanks!

[thomas@xxxxxxxxxxx]

Peter:

On Wed, 28 November 2001, Peter_Vidal@pall.com wrote:

>   I think that instead of having a file like QADBXREF,
> IBM should have a ONE-VERTEBRA-COLUMN FILE with all the basic OBJECTS
> information on the AS400 and this should include the pertinent and basic
> information, depending on the object type.

First, would you please explain "a ONE-VERTEBRA-COLUMN FILE"? I'm clearly out 
of touch with modern DBA terminology.

However, I'm not sure I'd like my AS/400 spending the time required to keep an 
object-xref file current. Every time an object was created, deleted and 
possibly changed, the xref table would need to be updated as well; and objects 
come and go a lot.

OTOH, the UDF suggestion in another post was a great idea; and it's something 
IBM could (should?) supply, perhaps as a QUSRTOOL so source would be available 
as an example. Hmmm... no, they'd probably send it as C++ and nobody could use 
it. As a UDF, there'd be no physical table maintenance and returned values 
would always be current.

Tom Liotta

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


___________________________________________________
The ALL NEW CS2000 from CompuServe
 Better!  Faster! More Powerful!
 250 FREE hours! Sign-on Now!
 http://www.compuserve.com/trycsrv/cs2000/webmail/