Warning in DB2 Stage
Posted: Mon Apr 23, 2007 10:11 am
Hi Forum,
In my job process reads records from a sequential file and validate this record in a db2 table, if exists perform an updated operation else insert the new record.
After run, in the director log appear this message
'DM_FCV_PROMEDIO..DB2_D_FCV_CONVERSION: This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.'
Both operation, insert and update are in the same db2 stage, with the array size 50 and transaction size 100.
Is incompatible use a same stage for both operations???
Thnks for your help.
In my job process reads records from a sequential file and validate this record in a db2 table, if exists perform an updated operation else insert the new record.
After run, in the director log appear this message
'DM_FCV_PROMEDIO..DB2_D_FCV_CONVERSION: This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.'
Both operation, insert and update are in the same db2 stage, with the array size 50 and transaction size 100.
Is incompatible use a same stage for both operations???
Thnks for your help.