We have a third party application built on SharePoint, and we want to use DB2/400 on our System i for the application's backend database. The app uses ADO and OLE DB to query whatever database it links to, and the vendor has it working on a number of different databases, including DB2 on Windows and Linux and MS SQL Server. However, we can't get it working on DB2/400. We're using the IDMDA400 OLE DB provider, and have tried the IBMDASQL provider too. Both work fine with single SQL select statements, but when we hit an OLE DB SQL request that contains multiple SQL statements separate by the ';' statement terminator, they are rejected with error "SQL0104 Token ; was invalid. Valid tokens END-OF-STATEMENT". It looks to me like the OLE provider for DB2/400 only allows single SQL statements per call. Is there a solution to this? If not, we're going to have a lot of work to do - the application does most if its database access via multiple-statement SQL calls, usually with three steps; declare temp table, then populate temp table, then return results from temp table. It can be re-engineered, but we'd rather avoid that, as the cost is significant.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!