Archives of the TeradataForum
Message Posted: Mon, 12 Jan 2004 @ 19:02:45 GMT
I want to use system environment variables in my multiload script in
import infile Option.
import infile /export/home/user1/file1.dat
if the location of the file "file1.dat" changes I have to edit and change the path from multiload script, instead I want the script to get the path from the system environment variable.
I tried setting up variable on my unix box ; exported the variable and used in mload script but that doesn't work
DATA_DIR=/export/home/user1; export DATA_DIR
import infile $DATA_DIR/file.dat
this doesn't work
I also tried to use accept command to us Environment variable but doesn't work
.accept FROM ENVIRONMENT VARIABLE '$DATA_DIR' ;
.accept FROM ENVIRONMENT VARIABLE $DATA_DIR ;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|