Archives of the TeradataForum

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

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

<-- 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>		<<First	<Prev	Next>	Last>>