Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 15 Feb 2002 @ 13:45:12 GMT


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


Subj:   Re: Probably an Easy MultiLoad Question
 
From:   Geoffrey Rommel

I just tested the following approach, and it worked.

[the usual MultiLoad stuff here...]
      .FIELD IN_field1                       * CHAR( 4);
      .FIELD IN_sign_field                   * char(1);
          /* Not to be confused with Seinfeld */
      .FIELD IN_field2                       * CHAR( 4);
[... more stuff ...]
.DML LABEL INSERTS;
INSERT into work_tbls.wgrtest03
(
    seq_no
   ,field1
   ,field2
) VALUES (
    :IN_seq_no
   ,:IN_field1
   ,case
      when :IN_sign_field = '-'  then :IN_field2 * -1
      else   :IN_field2
    end
 );

--wgr



     
  <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