Archives of the TeradataForum

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

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

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>>