 |
 |
Archives of the TeradataForum
Message Posted: Fri, 23 Mar 2001 @ 16:37:52 GMT
Subj: | | Re: Displaying view/macro text from the database |
|
From: | | David Wellman |
Karen,
I think you'll find that Arthur is right.
Ultimately the size of the macro/view is limited to 26000 bytes which is the size of the CreateText column in dbc.tvm. However, if your
views/macros are working correctly then that must hold all of the definition. If a SHOW command doesn't give you everything - this comes
from RequestText which is only 25000 bytes - you could try selecting the data directly from CreateText. You'll probably want to remove some
of the extra info that gets put into there, but it might help you.
Dave
| |