I'm working on Datastage 7.5 with Sybase as the Database.
I'm using an ODBC stage to load data into the sybase table.
It's properly loading data into it but on the link it's showing as "0 rows,0 rows/sec".
But in director this warning is coming:
*************************************************************
JT513Lod_Tbillingw_polinst_NB_1..Gld_tbillingw_polinst.IDENT1.To_Gld_tbillingw_polinst: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO schema.table(wip_no, wip_iteration_no, billing_cycle_seq_no, inst_num, inst_billing_date, inst_billed_date, inst_due_date, new_prem_written_amt, old_prem_written_amt, delta_prem_written_amt, new_charge_amt, old_charge_amt, delta_charge_amt, new_tax_amt, old_tax_amt, delta_tax_amt, new_billable_amt, old_billable_amt, delta_billable_amt, inst_prem_amt_collected, inst_collected_date, payment_ref, timestamp, reserved1, reserved2, reserved3, reserved4, reserved5, reserved6) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
0 Rows affected.
wip_no = "0011100029"
wip_iteration_no = "1"
billing_cycle_seq_no = 1
inst_num = 1
inst_billing_date = "2006-10-26 00:00:00"
inst_billed_date = "2006-10-26 00:00:00"
inst_due_date = "2006-10-26 00:00:00"
new_prem_written_amt = 0.0000
old_prem_written_amt = 0.0000
delta_prem_written_amt = 0.0000
new_charge_amt = 0.0000
old_charge_amt = 0.0000
delta_charge_amt = 0.0000
new_tax_amt = 0.0000
old_tax_amt = 0.0000
delta_tax_amt = 0.0000
new_billable_amt = 0.0000
old_billable_amt = 0.0000
delta_billable_amt = 0.0000
inst_prem_amt_collected = 0.0000
inst_collected_date = NULL
payment_ref = NULL
timestamp = "2008-05-13 15:19:40"
reserved1 = NULL
reserved2 = NULL
reserved3 = NULL
reserved4 = NULL
reserved5 = NULL
reserved6 = NULL
*************************************************************
Could anyone pls provide pointers to this..
Strange error while loading through ODBC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI