 |
 |
Archives of the TeradataForum
Message Posted: Thu, 19 Dec 2002 @ 17:11:16 GMT
| Subj: | | Re: New Years Wish List |
| |
| From: | | Hough, David A |
| | 1. The ability to use SQL to identify what tables, views, macros, etc. are referenced in macros, views, etc. without having to parse
the REQUESTTEXT (which only gets you 90% of the way there). | |
If you're willing to run a few unix commands, the SHOW construct (V2R4) made this a lot easier for individual SQL requests. The
output contains the create text for all referenced & nested objects in a form that's easy to parse with a little awk script. Then you
can load the cross reference data back into a Teradata table if you need to.
Of course, what we really want is a dbc table containing all the references so we don't have to do all the show statements. (Don't
mention MDS. Just don't.)
/dave hough
| |
