Archives of the TeradataForum

Message Posted: Fri, 04 Jun 1999 @ 13:39:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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).

	<Prev	Next>		<<First	<Prev	Next>	Last>>