Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2003 @ 15:25:00 GMT


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


Subj:   Re: Macro Question
 
From:   Glen Blood

Yes. As long as you run your macro only through bteq. You will have to maintain close control over where this is run.

CREATE MACRO TWO_STEP
(
.set titledashes off;
.export file = a;
SELECT 'SELCT blah blah FROM ' || TRIM(DATABASENAME) || '.' ||
TRIM(TABLENAME) || ';' (title '')
FROM tablelist
ORDER BY 1;
.export reset
.run file = a;
);

You need to remember the blank title and titledashes to get rid of your titles. Alternatively, you can use .run file = a,skip=2, but the progam will error if no rows are returned.

We built Unix scripts to accomplish this.

Glen



     
  <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