Archives of the TeradataForum

Message Posted: Tue, 26 Nov 2002 @ 13:53:23 GMT

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

Hi all,

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

TEXT1,TEXT2,TEXT3,TEXT4,TEXT5

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.

THANX

Mayur

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