can view data through DB2 aPI Stage, but unable to fetch fro

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nihar
Participant
Posts: 9
Joined: Thu Jul 27, 2006 11:27 pm
Location: New Delhi

can view data through DB2 aPI Stage, but unable to fetch fro

Post by Nihar »

Hi,
I am facing typical problem while trying to fetch data from DB2 Server through "DB2/UDB API Stage. The exact error log is mentioned below:

"APT_CombinedOperatorController,0: Fatal Error: Fatal: SQLFetch: Error retrieving results from server. "

kindly help me in this regard.

Thanks in Advance,
Nihar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard. Start by disabling operator combination so that you can more accurately diagnose what's going on.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You've not only posted in the 'wrong' forum but you've marked your job as a Server job when it obviously isn't. Please try to set those correctly in the future.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Nihar
Participant
Posts: 9
Joined: Thu Jul 27, 2006 11:27 pm
Location: New Delhi

can view data through DB2 API Stage, but unable to fetch

Post by Nihar »

ray.wurlod wrote:Welcome aboard. Start by disabling operator combination so that you can more accurately diagnose what's going on. ...
Please let me know where I can disable operator combination.

If all the "Derivations" from the "Columns" tab in the DB2 API Stage is cleared then only data can be viewed through "View Data..." button. Otherwise View data is not also possible.

kindly help me in this regard.

Thanks in advance
Post Reply