Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Jul 2005 @ 16:00:58 GMT


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


Subj:   Teradata ODBC Error in Informatica.
 
From:   Dutt, Vishal

I am trying to move data from one table to another using informatica powercenter 7.1.2 but its giving Teradata ODBC error. Both the tables are in Teradata.

Session fails at read itself. Following error comes in informatica sessionlog:

     --------------------------------
     READER_1_1_1> RR_4029 SQ Instance [SQ_TIME_HIST] User specified SQL
     Query [SELECT TIME_HIST.CURDATE, TIME_HIST.DAY#, TIME_HIST.MONTH#,
     TIME_HIST.QUARTER, TIME_HIST.YEAR#, TIME_HIST.DAY_OF_WEEK_NUM,
     TIME_HIST.WEEK_OF_MONTH, TIME_HIST.SEASON, TIME_HIST.WEEKEND_IND,
     TIME_HIST.HOLIDAY_IND, TIME_HIST.HOLIDAY_NAME, TIME_HIST.DAY_OF_WEEK,
     TIME_HIST.MONTH_NAME, TIME_HIST.EVENT, TIME_HIST.CREATED_DATE,
     TIME_HIST.MODIFIED_DATE, TIME_HIST.WEEK_OF_YEAR,
     TIME_HIST.WEEK_ENDING_SAT, TIME_HIST.WEEK_ENDING_SUN,
     TIME_HIST.DAY_OF_YEAR, TIME_HIST.ROLLING_YEAR,
     TIME_HIST.ROLLING_YEAR_DESC, TIME_HIST.ROLLING_QTR,
     TIME_HIST.ROLLING_QTR_DESC, TIME_HIST.ROLLING_MONTH,
     TIME_HIST.ROLLING_MONTH_DESC, TIME_HIST.ROLLING_WEEK,
     TIME_HIST.ROLLING_WEEK_DESC, TIME_HIST.ROLLING_4_WEEK,
     TIME_HIST.ROLLING_4_WEEK_DESC, TIME_HIST.ROLLING_7_DAY,
     TIME_HIST.ROLLING_7_DAY_DESC, TIME_HIST.ROLLING_30_DAY,
     TIME_HIST.ROLLING_30_DAY_DESC, TIME_HIST.WEEKDAY_IND,
     TIME_HIST.SOURCE_MODIFIED_DATE, TIME_HIST.HISTORY_LOAD_DATE,
     TIME_HIST.ROLLING_3_MONTH,
     TIME_HIST.ROLLING_6_MONTH, TIME_HIST.ROLLING_9_MONTH,
     TIME_HIST.rolling_12_month, TIME_HIST.WEEK_ENDING_THU,
     TIME_HIST.AGENCY_CODE
     FROM
      DEV_SAMPLE.TIME_HIST]
     READER_1_1_1> Tue Jul 26 16:32:40 2005
     READER_1_1_1> RR_4035 SQL Error [
     FnName: Prepare -- [NCR][ODBC Teradata][Teradata RDBMS] Syntax error:
     expected something between the 'SELECT' keyword and ','. ].
     READER_1_1_1> Tue Jul 26 16:32:40 2005
     READER_1_1_1> BLKR_16004 ERROR: Prepare failed.
     .
     .
     --------------------------------------

Same SQL runs fine on SQL Assistant. ODBC version in use is 3.04.

Has anyone come across error like this before?



     
  <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