SQL server load jobs failing

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ketanshah123
Participant
Posts: 88
Joined: Wed Apr 05, 2006 1:04 am

SQL server load jobs failing

Post by ketanshah123 »

Hi

While trying loading data from oracle table to sql server tables jobs are failing with fatal error :

APT_CombinedOperatorController,0: [DataDirect][ODBC lib] Program type out of range [odbcUtils.C:277]

DataDirect][ODBC SQL Server Driver]COUNT field incorrect [odbcUtils.C:657]

any idea how I can resolve this

thnax in advance
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Are you doing a 'COUNT' in your SQL? What is your SQL in the ODBC stage?
Top
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

Can you send the detailed job log ?

Regards
Sreeni
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”