SHOW MACRO/TABLE does not always return full DDL

Database
Fan

SHOW MACRO/TABLE does not always return full DDL

Hi all,

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?

3 REPLIES
Senior Supporter

Re: SHOW MACRO/TABLE does not always return full DDL

Do you connect with ODBC or .net?

In other posts it was suggested to use .net.

Fan

Re: SHOW MACRO/TABLE does not always return full DDL

.net works fine, thank you.

Re: SHOW MACRO/TABLE does not always return full DDL

Hi ,

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.

Thks,

Maze