Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 09 Dec 2002 @ 20:59:59 GMT


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


Subj:   Has anybody run mload script thru' FoxPro program ??
 
From:   Mayur Parikh

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

THANX

Mayur



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016