Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


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.

see

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


     
  <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: 28 Jun 2020