Archives of the TeradataForum

Message Posted: Tue, 28 Jan 2003 @ 18:09:07 GMT

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

Hi,

This question is regarding passing input data files to mload script externally ..

let me explain clearly.... suppose i want to load a list of data files into single table using mload.... all the data files are in same format....

for example in a directory i have a list of input data files like

     1.dat
     2.dat
     3.dat
     4.dat etc.......

no of files in a directory will be changed...not fixed.....

I want load all these files into single table using mload... i want to run mload utility from perl script.... like get each file from a directory and run mload script on that file

how to pass "1.dat" to externally to mload script instead hard coding like follwoing

--------------
.import infile 1.dat
        layout mylayout
        format text
        apply myinsert ;
--------------------------

I appreciate u r help....

NOTE : platform is windows 2000

Thanx

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