Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 13 Jul 2005 @ 18:55:18 GMT


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


Subj:   Teradata Extension Error - Error code 3144
 
From:   Kambhoji, Naveen Ram Prasanna

Hi All,

I am trying to execute the following query

     UPDATE TMR
     FROM TELEPHIA_MAP_REQ TMR,
     ( SELECT ZEROIFNULL(COUNT(*)),1 AS FV_RECS FROM DS_FV_DETAIL FVD WHERE
     UPPER(FVD.OK_TO_PUBLISH) = 'N' ) DT1 (C1, C2),
     ( SELECT ZEROIFNULL(COUNT(*)),1 AS MCL_RECS FROM TELEPHIA_MCL MCL WHERE
     MCL.MARKET_ID IS NULL OR MCL.CARRIER_ID IS NULL ) DT2 (C1, C2)
     SET LAST_UPDATE=CURRENT_DATE, MCL_RECS=DT1.C1, FV_DETAIL_RECS=DT2.C1
     WHERE DT1.C2=DT2.C2;

by using RunSQL macro action in the MS Access Form Close event sub-routine.

It throws me an error ---> Error Code: 3144 - Syntax error in Update Statement but the same SQL works absoultely fine in my SQL Assistant.I guess this is due to teradata extension SQL and the odbc is not converting it to native sql properly.

Please let me know if there is any round about way of doing the same or any configuration changes of odbc.


Thanks in advance

Prasanna K



     
  <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