Archives of the TeradataForum
Message Posted: Mon, 09 Dec 2002 @ 20:59:59 GMT
Based on our requirments I have to run three scripts to load data in three tables Each of first two tables gets data from respective text file as input. But the third table will get data from multiple text files. Layout of each text file will be the same only file names are different. In my mload script I have to use ACCEPT command for input filename which am substituting in my script. That is the reason I had to write foxpro program to run third script in a loop till it loads data from all text files.
the syntex I had to use is RUN MLOAD < script>output.log. The problem I am having is that it reuns only one script file and it fails to run other.
I appriciate any help on this
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|