Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Jun 1999 @ 09:09:56 GMT

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

Subj:   Re: SHOW MACRO Limitations
From:   Yves Mackels

Yes, there is also a limitation.

Take a look a the "Teradata DBS for UNIX Data Dictionary Reference Teradata RDBMS V2 R2" manual for the DBC.tables view that access the DBC.TVM tables.

In the DBC.TVM table there are two fields called requesttext and statementtext:

requesttext contains the text of the most recent data definition (reflects the definitions specified by the user). createtext contains the data definition after transformation by Teradata.

Finally, the limitation resides in the data type of the createtext statement that I think is used by the show macro statement.

We are running V2R.

in the DBC.TVM table :

     CreateText VARCHAR(20480) NOT CASESPECIFIC FORMAT 'X(255)',

Mackels Yves

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023