Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Feb 2003 @ 21:30:52 GMT


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


Subj:   Re: MLOAD Changes from 07.05.00 to 07.06.00
 
From:   John Adams

Hi, Debbie,

Here's the diff--its the first code that failed:

135,139c136,144
< WHERE CUST_ID = substring ('00000000000' from 1 for 11 - char_length (:F_CUST_ID)) || :F_CUST_ID (char(11));

< INSERT db.tbl
---
> WHERE CUST_ID =
> ( case when char_length (:F_SERVICE_ID) = 11
>       then :F_SERVICE_ID
>    else
>  substring ('00000000000' from 1 for 11 - char_length(:F_SERVICE_ID)) || :F_SERVICE_ID
>      end (char(11)))
> ;

> INSERT db.tbl

Thanks,

John A



     
  <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