Archives of the TeradataForum

Message Posted: Tue, 10 Oct 2006 @ 12:51:44 GMT

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

Thank you Simon.

But I am getting error like "3784 the number of digits specified must be between 1 and 18", If decimal(20,2).

Hi All,

I have modified query like :

     Select Substr(TableData,3,45)  a
            , Trim(trailing ',' From Trim(Cast(Substr(TableData,48,20)as decimal (18,1)))) b
            ,Trim(trailing ',' From Trim(Cast(Substr(TableData,68,20) As decimal (18,1)))) C
     From prododss.GTSTableData
     Where TableCode = '00842'
     ;

Its working perfectly. But If I am excuting like :

     Select Substr(TableData,3,45)  a
          , Trim(trailing ',' From   Trim(Cast(Substr(TableData,48,20)as decimal (17,2)))) b
          ,Trim(trailing ',' From   Trim(Cast(Substr(TableData,68,20) As decimal (17,2)))) C
     From prododss.GTSTableData
     Where TableCode = '00842'
     ;

Its not working why ?. If there is any other way by which we can get the same.

Regards,

Rao

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