If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Odbc problem With Procedure containing Begin Work and commit Work

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 7
Odbc problem With Procedure containing Begin Work and commit Work

Hi, I have a problem when calling a stored procedure wich contain the Begin Work and Commit Work statement from the SAP BODI ETL.
Then problem is the ETL encounter the error wich is sent by the Odbc driver
"General error" When I comment the begin work and commit Work the Job is lanching successfully.
Need help : CSDK 3.50 TC5 Wit Informix 10

Thanks
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Sep 2011
Location: Pont l'Abbé, Brittany, France
Posts: 334
Hi CHallenger,

This error is probably given because the stored procedure is expecting to work on a logged database.
Apparently, you db is not logged, explaining that the SP works without begin/commit.

If you can modify the source of the SP, and allowed to do it, what you can do is to add a "raise exception" on BEGIN WORK, COMMIT WORK and ROLLBACK WORK, so that it does not fail if the db is not logged.

Not very beautiful, but it should work.

THe other question is "why isn't your database in log mode"?

Last edited by begooden-it; 11-27-12 at 03:19.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jul 2012
Posts: 7
Hi, the problem is that is a bug in the Odbc 3.50 TC5, when it got Begin twice, It hangs with this error, so I have eliminate the Begin but the proble now is the error 'not in transaction' I don't know why ??
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Sep 2011
Location: Pont l'Abbé, Brittany, France
Posts: 334
Did you try with the last CSDK 3.70 ?
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Feb 2013
Posts: 1
Was this ever resolved

I'm experiencing the same problem. What was the solution?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On