Archives of the TeradataForum
Message Posted: Tue, 22 Oct 2002 @ 19:20:39 GMT
1) To get the names of all files (text files) from the folder
2) Then in a loop run MLOAD to load text data into tables so I load every text files in tables. One table for each text file and table name would be exactly the file name of that text file.
I know I can do it in UNIX script but in that case I have to transfer all received text files from NT box to UNIX box. I want to eliminate that process, if possible.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|