Page 1 of 1

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

Posted: Tue Sep 16, 2008 3:41 am
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

Posted: Tue Sep 16, 2008 5:01 am
by ray.wurlod
Welcome aboard. Start by disabling operator combination so that you can more accurately diagnose what's going on.

Posted: Tue Sep 16, 2008 7:59 am
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.

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

Posted: Thu Sep 18, 2008 12:04 am
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