SQL0100W error message when I run a query
"Stafford,Stuart,VEVEY,Contractor for Technology Unit" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
Hi List, After we upgraded AIX to version 7.1 (perl v5.10.1) our perl DBD/DBI modules stopped working for DB2. I have re-compiled the latest modules of DBI (DBI-1.627) and DBD for DB2 (DBD-DB2-1.85). Both modules compiled successfully using xlc_r compiler on AIX. When I use the modules to query the DB2 database, everything works. However after retrieving the output I need, the below message appears after every query:- SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000 This message appears for every query, regardless of whether data is returned or not. I searched the internet and apparently this is not an error message as such, but why has it started appearing? It was not apparent in the old DBD/DBI modules. Is there a way I can turn it off? Any help appreciated. Thanks and regards Stuart Stuart Stafford I Data Center & Systems - Infrastructure & Application Management I Digital & Technology I PLD K4 114-01 I Phone: +41 21 924 6257 * Visit our IAM Intranet <http://thenest-eur-hq.nestle.com/GL/GL_INFS/InformationTechnology/Pages/InformationTechnology/IAM.aspx>