in some cases when I run SHOW MACRO some_macro or SHOW TABLE some_table I do not get the full DDL, only first few lines. This happens on two separate PC's, tested with SQL Assistant and Nexus Query Chameleon. As DDL is always truncated at the same place I first thought this is related to teradata driver (13.10.00.02 windows version - TDATA32.DLL). The only configuration setting I have found is "Maximum Response Buffer Size" (8192 by default) but increasing this value doe not have any effect.
Running this query gives me the same truncated result:
select * from dbc.tables where databasename = 'db_name' and tablename='macro_name'
Any ideas what can cause such behavior?
im still not getting the complete definition even after using Teradata.net connector in Teradata 14.1
Please help me with some way to extract the complete macro definition.