Archives of the TeradataForum

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

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

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