Archives of the TeradataForum

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

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

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>>