MLOAD Commad line options

[mvnrk]

Can we pass IMPORT INFILE file name with path as command line parameter while loading data using mload under Unix environment?


Thanks in Advance

 

[dnoeth]

AFAIK no, but you can read it from a flat file or an environment variable using ACCEPT:

.ACCEPT tablename FROM FILE ...;
...
.IMPORT INFILE &tablename ...

Dieter

 

[mvnrk]

Hi

Thanks for your reply. I have used
.ACCEPT var1 FROM FILE /data/sam_030811.txt ;
.IMPORT INFILE &var1

It is giving error
0025 .ACCEPT var1 FROM FILE /data/sam_030811.txt ;
**** 11:33:16 UTY4811 # of Variables is less than # of data provided.
0026 .IMPORT INFILE &var1


Any clue on this.

 

[dnoeth]

Check the "Teradata RDBMS Messages" manual:

"Explanation: All variables in .ACCEPT command
have been satisfied and there is more data expecting
assignment to (a) variable(s)."

There is more than one tablename in sam_030811.txt.
It should be just a single line of ASCII text with a string in single quotes, e.g. 'mytablename'

Dieter