Oninit cdi / Archive
Talk to an expert →

Re: ODBC Question

Posted in 2003

Topics: Performance & Tuning, Installation, Setup & Upgrades, Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET

Mark D. Stock — — source: Usenet: comp.databases.informix

Manas Dadarkar wrote: > DB2 is the database I am using and it does not support > the BEGIN WORKstatement. Also, if I set the AUTOCOMMIT > feature on, we have a performance penalty and COMMIT > WORK might return an error. > Any other ideas? Post your question to a DB2 newsgroup? I can't see on this list who you cross-posted this question to, so you may have already done that, but this is an Informix newsgroup. The two answers that spring to mind, the second served with a splash of sarcasm, are: 1. Ask this question on a DB2 newsgroup 2. Upgrade your DB2 to Informix :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list

↪ replying to Mark D. Stock
John Carlson — — source: Usenet: comp.databases.informix

On Mon, 01 Sep 2003 17:54:53 +0100, "Mark D. Stock" <mdstock@mydassolutions.com> wrote: > >Manas Dadarkar wrote: >> DB2 is the database I am using and it does not support >> the BEGIN WORKstatement. Also, if I set the AUTOCOMMIT >> feature on, we have a performance penalty and COMMIT >> WORK might return an error. >> Any other ideas? > >Post your question to a DB2 newsgroup? > >I can't see on this list who you cross-posted this question to, so you may >have already done that, but this is an Informix newsgroup. > >The two answers that spring to mind, the second served with a splash of >sarcasm, are: > >1. Ask this question on a DB2 newsgroup >2. Upgrade your DB2 to Informix :-) Do they support that migration path? 8-)