RE: FWD: AS400 "Object Xref" File? Thanks! -- MIDRANGE-L

Tom,

Actually with V5R1 you'll get C++ in the WDS licensed program anyway, but I
get your point. As far as overhead to maintain the file, if you excluded
QTEMP how often are you creating objects? The tables are already maintained
for file (and fields in files) so the occasional program or 50 shouldn't be
that big a problem. Never the less, I agree the UDF would be cool, that's
why I suggested it. If only I had the time to write it I might even donate
it to open source... Hey Brad, feel like writing another tool? <G>

-Walden

------------
Walden H Leverich III
President
Tech Software
(516)627-3800 x11
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com



-----Original Message-----
From: thomas@inorbit.com [mailto:thomas@inorbit.com]
Sent: Wednesday, November 28, 2001 4:50 PM
To: midrange-l@midrange.com
Subject: Re: FWD: AS400 "Object Xref" File? Thanks!


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/




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