| Posted on 2007-07-16 15:18:10-07 by ssemenyuk |
| No error returned |
|
Hi,
I am experiencing strange behaviour with DBD::DB2. I don't get error codes or error messages although trace shows that errors are there. Example is below. You will notice that err is always 0. On the output all err, errstr, status are undef for both sth and dbh. All the warnings and errors are enabled. Ah, also the version of DB2 module is 1.0. I am using ActiveState perl: This is perl, v5.8.8 built for MSWin32-x86-multi-thread
(with 50 registered patches, see perl -V for more detail)
Copyright 1987-2006, Larry Wall
Binary build 820 [274739] provided by ActiveState http://www.ActiveState.com
Built Jan 23 2007 15:57:46
Thanks in advance.
------------ Trace output
-> prepare for DBD::DB2::db (DBI::db=HASH(0x1cfeeb0)~0x1cfee5c '
TRUNCATE TABLE ARSTEMP.HRCCDATATEMP; --ALTER TABLE ARSTEMP.HRCCDATATEMP ACTIVATE
+NOT LOGGED INITIALLY WITH EMPTY TABLE;
') thr#224fc4
New 'DBI::st' (for DBD::DB2::st, parent=DBI::db=HASH(0x1cfee5c), id=undef)
dbih_setup_handle(DBI::st=HASH(0x1cff06c)=>DBI::st=HASH(0x1cff024), DBD::DB2::st, 19e9ad0, Null
+!)
dbih_make_com(DBI::db=HASH(0x1cfee5c), 1d0d9a4, DBD::DB2::st, 160, 0) thr#224fc4
dbih_setup_attrib(DBI::st=HASH(0x1cff024), Err, DBI::db=HASH(0x1cfee5c)) SCALAR(0x1cfe9d0) (alr
+eady defined)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), State, DBI::db=HASH(0x1cfee5c)) SCALAR(0x1cfe9b8) (a
+lready defined)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), Errstr, DBI::db=HASH(0x1cfee5c)) SCALAR(0x1cfe9c4) (
+already defined)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), TraceLevel, DBI::db=HASH(0x1cfee5c)) 15 (already def
+ined)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), FetchHashKeyName, DBI::db=HASH(0x1cfee5c)) 'NAME' (a
+lready defined)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), HandleSetErr, DBI::db=HASH(0x1cfee5c)) undef (not de
+fined)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), HandleError, DBI::db=HASH(0x1cfee5c)) undef (not def
+ined)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), ReadOnly, DBI::db=HASH(0x1cfee5c)) undef (not define
+d)
dbih_setup_attrib(DBI::st=HASH(0x1cff024), Profile, DBI::db=HASH(0x1cfee5c)) undef (not defined
+)
dbd_st_prepare'd sql f131073
TRUNCATE TABLE ARSTEMP.HRCCDATATEMP; --ALTER TABLE ARSTEMP.HRCCDATATEMP ACTIVATE
+NOT LOGGED INITIALLY WITH EMPTY TABLE;
<- prepare= DBI::st=HASH(0x1cff06c) at remedyUserSync.pl line 513 via at remedyUserSync.pl lin
+e 512
-> err in DBD::_::common for DBD::DB2::db (DBI::db=HASH(0x1cfeeb0)~0x1cfee5c) thr#224fc4
<- err= undef at remedyUserSync.pl line 516 via at remedyUserSync.pl line 475
-> execute for DBD::DB2::st (DBI::st=HASH(0x1cff06c)~0x1cff024) thr#224fc4
SQLExecute failed error 1 recorded: [IBM][CLI Driver][DB2/SUN] SQL0104N An unexpected token "ARSTE
+MP" was found following "TRUNCATE TABLE ". Expected token
s may include: "JOIN". SQLSTATE=42601
!! ERROR: -104 '[IBM][CLI Driver][DB2/SUN] SQL0104N An unexpected token "ARSTEMP" was found fo
+llowing "TRUNCATE TABLE ". Expected tokens may include:
"JOIN". SQLSTATE=42601
' (err#0)
<- execute= -1 at remedyUserSync.pl line 519 via at remedyUserSync.pl line 475
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/SUN] SQL0104N An unexpected token "ARSTEMP" was
+ found following "TRUNCATE TABLE ". Expected tokens may i
nclude: "JOIN". SQLSTATE=42601
DBD::DB2::st execute failed: [IBM][CLI Driver][DB2/SUN] SQL0104N An unexpected token "ARSTEMP" was
+ found following "TRUNCATE TABLE ". Expected tokens may i
nclude: "JOIN". SQLSTATE=42601
-> DESTROY for DBD::DB2::st (DBI::st=HASH(0x1cff024)~INNER) thr#224fc4
ERROR: -104 '[IBM][CLI Driver][DB2/SUN] SQL0104N An unexpected token "ARSTEMP" was found fo
+llowing "TRUNCATE TABLE ". Expected tokens may include:
"JOIN". SQLSTATE=42601
' (err#0)
|
| Direct Responses: 5748 | Write a response |
