Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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,


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