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.
Warning in DB2 Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Warning in DB2 Stage
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
Re: Warning in DB2 Stage
Are you sure. Double check the update action for both your links. Your error message indicates that one of them is set to 'Update Or Insert'.jseclen wrote: '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.'
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Warning in DB2 Stage
Yes master, i verified and anylink is seted with that Update action. Is necessary separate in two diferents db2 stages or not?
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru