Archives of the TeradataForum
Message Posted: Tue, 26 Nov 2002 @ 13:53:23 GMT
I need help on writing mload script to load text file in teradata table.
There would be flat files in the folder
e.g. LRFILE1, LRFILE2, LRFILE3
say each of this file has five records
I want to create a array of these filenames and run a loop till all data from all files have been extracted. I want to populate text (each line) of the file along with filename in teradata table.
So my table will have two columns filename and detail
when I run sql select filename,detail from mytable it should have following
LRFILE1 TEXT1 LRFILE1 TEXT2 LRFILE1 TEXT3 LRFILE1 TEXT4 LRFILE1 TEXT5 LRFILE2 TEXT1 LRFILE2 TEXT2 LRFILE2 TEXT3 LRFILE2 TEXT4 LRFILE2 TEXT5 LRFILE3 TEXT1 LRFILE3 TEXT2 LRFILE3 TEXT3 LRFILE3 TEXT4 LRFILE3 TEXT5
These files will be NT based. So I want to do in DOS batch file
I appeciate your help and willingness to help teradata novice like me.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|