Archives of the TeradataForum
Message Posted: Tue, 23 Nov 2004 @ 13:50:44 GMT
<-- 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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|