Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 23 Nov 2004 @ 13:50:44 GMT

  <Prev Next>  
Next> Last>>  

Subj:   IMPORT File and BTEQ 'variables'
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 23, 2004 08:48 -->

Hope someone can help out.

I have a one-row input file containing a date, which I need to use in a BTEQ Script repeatedly.

Currently it works OK using .IMPORT, but the problem is I have to repeat the .IMPORT for every EXECUTE macro (of which there are approx 100 in my BTEQ script)

     .IMPORT DATA FILE = MyInputFile;
        USING MyDate
        EXECUTE MyDB.MyMacro(:MyDate);

Is there way to assign the date to a variable and then refer to it elsewhere in the BTEQ script, without having to do the .IMPORT again? I was thinking of loading the date to a table (single row, single column), which I would then refer to in each macro, but that would mean a change to each of the 100 Macro's.

Thanks in advance!

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