The output after setting $dbh->trace(3):
insert or replace into TMP_credDerivOrig
select
A.date,
A.CDId,
A.CDName,
A.CDTicket,
A.tradeId,
A.tapsAccount,
A.CDBook,
coalesce(A.CDFid,'') CDFid,
A.CDStatus,
A.CDTradeDate,
A.CDExpDate,
A.CDNotional,
A.CDCurr,
A.CDSellBuy,
A.CDType,
A.CDExerType,
A.CDEntity,
A.CDCusip,
A.CDSetlType,
A.CDCredInit,
A.CDSingleEntry,
A.CDMaterialType,
A.CDEffDate,
A.CDPremFreq,
A.CDPaymentType,
A.CDUpfrontSetl,
A.CDPublicInfo,
A.CDCollReq,
A.CDSpreadCurve,
A.CDPremium,
A.CDOptType,
A.CDAccrue,
A.CDRefPrice,
A.CDPremiumAmnt,
A.CDLastCoupLength,
A.CDWhoDelivers,
A.CDCollateralText,
A.CDFactorReason,
A.CDDefStartProt,
A.CDDefEndProt,
A.CDDefProtType,
B.CDComment,
A.CDEvent,
A.CDCurveType,
A.CrvShName,
A.CDRefEntity,
A.CDRefIndustry,
A.CDRefCountry,
A.CDRefSNP,
A.CDRefMoody,
A.CDRefMSRating,
A.CDRefId
from TMP_credDerivOrig A,
C1_credDerivComment B
where A.CDId = B.CDId;
-> prepare for DBD::SQLite::db (DBI::db=HASH(0x8159970)~0x8389c6c '
insert or replace into TMP_credDerivOrig
select
A.date,
A.CDId,
A.CDName,
A.CDTicket,
A.tradeId,
A.tapsAccount,
A.CDBook,
coalesce(A.CDFid,'') CDFid,
A.CDStatus,
A.CDTradeDate,
A.CDExpDate,
A.CDNotional,
A.CDCurr,
A.CDSellBuy,
A.CDType,
A.CDExerType,
A.CDEntity,
A.CDCusip,
A.CDSetlType,
A.CDCredInit,
A.CDSingleEntry,
A.CDMaterialType,
A.CDEffDate,
A.CDPremFreq,
A.CDPaymentType,
A.CDUpfrontS...') thr#813b008
dbih_setup_handle(DBI::st=HASH(0x8390cb8)=>DBI::st=HASH(0x8389d8c),
DBD::SQLite::st, 8390c88, Null!)
dbih_make_com(DBI::db=HASH(0x8389c6c), 838a0b8, DBD::SQLite::st,
124, 0) thr#813b008
sqlite trace: prepare statement:
insert or replace into TMP_credDerivOrig
select
A.date,
A.CDId,
A.CDName,
A.CDTicket,
A.tradeId,
A.tapsAccount,
A.CDBook,
coalesce(A.CDFid,'') CDFid,
A.CDStatus,
A.CDTradeDate,
A.CDExpDate,
A.CDNotional,
A.CDCurr,
A.CDSellBuy,
A.CDType,
A.CDExerType,
A.CDEntity,
A.CDCusip,
A.CDSetlType,
A.CDCredInit,
A.CDSingleEntry,
A.CDMaterialType,
A.CDEffDate,
A.CDPremFreq,
A.CDPaymentType,
A.CDUpfrontSetl,
A.CDPublicInfo,
A.CDCollReq,
A.CDSpreadCurve,
A.CDPremium,
A.CDOptType,
A.CDAccrue,
A.CDRefPrice,
A.CDPremiumAmnt,
A.CDLastCoupLength,
A.CDWhoDelivers,
A.CDCollateralText,
A.CDFactorReason,
A.CDDefStartProt,
A.CDDefEndProt,
A.CDDefProtType,
B.CDComment,
A.CDEvent,
A.CDCurveType,
A.CrvShName,
A.CDRefEntity,
A.CDRefIndustry,
A.CDRefCountry,
A.CDRefSNP,
A.CDRefMoody,
A.CDRefMSRating,
A.CDRefId
from TMP_credDerivOrig A,
C1_credDerivComment B
where A.CDId = B.CDId; at dbdimp.c line 258
<- prepare= DBI::st=HASH(0x8390cb8) at DBUtilLite.pm line 185 via
at DBUtilLite.pm line 185
-> DESTROY for DBD::SQLite::st (DBI::st=HASH(0x8390b80)~INNER)
thr#813b008
<- DESTROY= undef at DBUtilLite.pm line 186 via at DBUtilLite.pm
line 186
-> execute for DBD::SQLite::st (DBI::st=HASH(0x8390cb8)~0x8389d8c)
thr#813b008
sqlite trace: Execute returned 0 cols
at dbdimp.c line 391
<- execute= 566606 at DBUtilLite.pm line 187 via at DBUtilLite.pm
line 187
-> rows for DBD::SQLite::st (DBI::st=HASH(0x8390cb8)~0x8389d8c)
thr#813b008
<- rows= 566606 at DBUtilLite.pm line 189 via at test.pl line 29
rows affected: 566606
-> prepare for DBD::SQLite::db (DBI::db=HASH(0x8159970)~0x8389c6c '
') thr#813b008
dbih_setup_handle(DBI::st=HASH(0x8390cc4)=>DBI::st=HASH(0x8390a6c),
DBD::SQLite::st, 8390ca0, Null!)
dbih_make_com(DBI::db=HASH(0x8389c6c), 838a0b8, DBD::SQLite::st,
124, 0) thr#813b008
sqlite trace: prepare statement:
at dbdimp.c line 258
<- prepare= DBI::st=HASH(0x8390cc4) at DBUtilLite.pm line 185 via
at DBUtilLite.pm line 185
-> DESTROY for DBD::SQLite::st (DBI::st=HASH(0x8389d8c)~INNER)
thr#813b008
<- DESTROY= undef at DBUtilLite.pm line 186 via at DBUtilLite.pm
line 186
-> execute for DBD::SQLite::st (DBI::st=HASH(0x8390cc4)~0x8390a6c)
thr#813b008
sqlite trace: Execute returned 0 cols
at dbdimp.c line 391
sqlite error 21 recorded: not an error at dbdimp.c line 398
!! ERROR: 21 'not an error(21) at dbdimp.c line 398' (err#0)
<- execute= undef at DBUtilLite.pm line 187 via at DBUtilLite.pm
line 187
1 -> FETCH for DBD::SQLite::st (DBI::st=HASH(0x8390a6c)~INNER
'ParamValues') thr#813b008
.. FETCH DBI::st=HASH(0x8390a6c) 'ParamValues' = undef
ERROR: 21 'not an error(21) at dbdimp.c line 398' (err#0)
1 <- FETCH= undef at DBUtilLite.pm line 187 via at DBUtilLite.pm line
187
DBD::SQLite::st execute failed: not an error(21) at dbdimp.c line 398
[for Statement "
"] at /u/crdceed/lib/perl5/DBUtilLite.pm line 187.
DBD::SQLite::st execute failed: not an error(21) at dbdimp.c line 398
[for Statement "
"] at /u/crdceed/lib/perl5/DBUtilLite.pm line 187.
-> DESTROY for DBD::SQLite::st (DBI::st=HASH(0x8390a6c)~INNER)
thr#813b008
ERROR: 21 'not an error(21) at dbdimp.c line 398' (err#0)
<- DESTROY= undef
-> DESTROY for DBD::SQLite::db (DBI::db=HASH(0x8389c6c)~INNER)
thr#813b008
ERROR: 21 'not an error(21) at dbdimp.c line 398' (err#0)
<- DESTROY= undef
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not
intend to waive confidentiality or privilege. Use of this email is prohibited
when received in error.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
