Archives of the TeradataForum

Message Posted: Fri, 20 Apr 2007 @ 11:03:15 GMT

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

Hi,

I have a small query in .import script

I have file name with standard name and variable name i.e data_feed_file_&DATE.txt

Hear I'm accepting data as a variable and try to build the string in .IMPORT

     .IMPORT INFILE &DATA_DIR./ data_feed_file_&DATE.txt

     18:00:42 UTY0014 Bad keyword in the IMPORT command at position 83:
     Expected "LAYOUT" but found "&{DATE}.txt".

Thanks for ur help.

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