Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2009 @ 13:23:30 GMT

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

Subj:   Re: Multiload SQL and Case statement
From:   Geoffrey Rommel

Apparently the incoming field is supposed to contain month and day in 'mmdd' form. If so, split it into two fields:

     .field  usage_mm    * char(2);
     .field  usage_dd    * char(2);

Now you might be able to check for invalid values in the .field commands:

     .field  usage_mm    * char(2) nullif usage_mm < '01' or usage_mm  > '12';
     .field  usage_dd    * char(2) nullif usage_dd < '01' or usage_dd  > '31';

You say the records are being dropped. I take that to mean that they are going to one of the error tables. Which error table are they going to, and what is the error code?

  <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