Archives of the TeradataForum

Message Posted: Mon, 16 Apr 2007 @ 18:22:07 GMT

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

This will work providing the number of characters in your macro text doesn't exceed the length of the varchar in field requesttext on table dbc.tvm (12500 on our system, I don;t know if this differs across releases). Unfortunately, we have a business macro (and a host of TCRM macros) in excess of 12500 characters and the only accurate way I have found to do impact analysis is to analyse the results of the SHOW MACRO statement.

see

     sel databasename, tablename,characters(trim(requesttext))
     from dbc.tables
     where tablekind='m'
     order by 3 desc

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