Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 02 Jun 2000 @ 22:42:38 GMT


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


Subj:   Re: Maintaining a variable in MLoad
 
From:   Eric J. Kohut

Sam,

Probably not what you are looking for since these are a little convoluted, but here are two options:

* First, You might be able to use the ACCEPT option in MLOAD to read the variable into a System Variable and then use the system variable to load the data value wherever you need it.

* Second, You could load the row into a one row, one column table using a bteq script and tell it to load one row from the file. Then you can use an unbounded join to join this row/column to every other row in the file once you've loaded them with a normal utility.


Good Luck,

Eric



     
  <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: 15 Jun 2023