Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Finding out the table in Macros
From:   Howard Bradley

  Hi, try to use this  

> select * > from dbc.tables > where requesttext like '% MONTHLY_BILLING%' > and tablekind = 'M'
  It will bring you all the macros that includes MONTHLY_BILLING.  

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.


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

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