I am running a db2 stored procedure from the db2 connect query editor. 6 out of 9 of my stored procedures run without a problem. However 3 of the stored procedures cause the db2 connection to be lost and I get an error msg that db2bp.exe failed. All of the stored procedures where based on the same program. Does anyone know what could ca...
I choosed a web project in order to do that i am using an IDE (Eclipse), database (DB2 universal driver) and Apache Tomcat server. So, by gods grace every thing has gone well but when I try to update data to DB2 database through JDBC code then I am getting an SQL DB error as :: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: D...
Back at Tech Ed in 2008, Microsoft announced that: IBM and Microsoft have agreed to work together to integrate IBM DB2 database access with Visual Studio Team System Database Edition. -- Microsoft Press Release - 6/3/2008 Has anyone seen evidence that this has actually happened? More importantly, has anyone had success moving DB...
I am creating a table with tablespace: CREATE TABLE SALARY..... IN ACCOUNTING INDEX IN ACCOUNT_IDX Where will the Accounting and Account_IDX be created? ...
I have the following setup. 'Apps/Reports' <---------> 'DB2 Connect' <------------> 'Legacy DB2 on AS400' `Hibernate` `native calls` When data is retrieved from by the application, it will be padded with extra spaces if the length is less that the column length. Of note when running a query, if the WHERE c...