Archives of the TeradataForum
Message Posted: Fri, 04 Jun 1999 @ 13:39:55 GMT
| Subj: | | Re: SHOW MACRO Limitations |
| |
| From: | | John Hall |
Yes, there is a limitation to how much of a macro (or view) will be shown - Yves is right about the underlying cause. It's a
pain, isn't it? When I've been faced with this in the past, I've bought some benefit by removing things like leading blanks and
using aliases as much as I can.
With V2R3, the definition for CREATETEXT has changed from VARCHAR(20480) to VARCHAR(26000) - this should help somewhat.
You are correct about the fact that a HELP DATABASE DBC does not show the full contents of database DBC. I don't think that any
of the system tables are shown - just the VIEWs and MACROs. However, if you logon as DBC and do the HELP DATABASE DBC, then you'll
see everything. I believe that it has always worked this way. I've never heard a reason for why it was implemented like this. I
suspect that the intention is to force people to use the system VIEWs instead of the tables (after all, only the VIEWs are covered in
the Data Dictionary manual).
| 
