Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2005 @ 13:57:59 GMT

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

Hi,

I have noticed some discrepancies between ITEQ and BTEQ(Demo Version).

Following code which is working fine in ITEQ, does not work in BTEQ (Demo Version) and QueryMan.

i.e.

     SELECT
     CASE
        WHEN INDEX(TRIM(AnyCol), ' ') GT 1 THEN 0
        ELSE
        CASE
           WHEN
                  SUBSTR(AnyCol,1,1) IN
     ('','0','1','2','3','4','5','6','7','8','9')
              AND SUBSTR(AnyCol,2,1) IN
     ('','0','1','2','3','4','5','6','7','8','9')
              AND SUBSTR(AnyCol,3,1) IN
     ('','0','1','2','3','4','5','6','7','8','9')
              AND SUBSTR(AnyCol,4,1) IN
     ('','0','1','2','3','4','5','6','7','8','9')
           THEN CAST(AnyCol AS INTEGER)
           ELSE 0
        END
     END
     FROM AnyTable;

But the same above code is throwing the following error in BTEQ(Demo Version) and QueryMan.

       CASE
           $
      *** Failure 3706 Syntax error: expected something between the 'ELSE'
     keyword and the 'CASE' keyword.
                     Statement# 1, Info =188
      *** Total elapsed time was 1 second.

Following code which is working fine in BTEQ(Demo Version) and QueryMan, does not work in ITEQ with error "2620 The format or data contains a bad character".

     SELECT CAST('1 234' AS INTEGER);

I will appreciate if somebody could explain it.

Thanks

Vivek

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