Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 30 Jun 2003 @ 21:04:35 GMT

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

Subj:   Re: 3707 Error Message
From:   Haritha Aepala


If two consecutive strings are given with blank are separator, they are treated as if they are concatenated. This works fine with SELECT statement but not with in the view.

for example:

sel * from t11 where j in ('1', '2' '3');

works as if you have given as

sel * from t11 where j in ('1', '23');

I have opened an incident with NCR and they are looking in to this problem. A DR82600 is opened to address this problem.

If you correct the view to have ',' between the strings, it should work fine. I have pasted small portion of view below.......

                              END)     AS Voice_Overage_Chrg_Amt
                          ,SUM(CASE WHEN P.PRODUCT_TYPE_CD IS NULL
                                     AND BSCH.CHARGE_CLASSIFICATION_CD
IN('104','204','304','404','504','604'  ==========> ',' is missing between 604 and 704


  <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