I did a search in these forums for "not compatible with parameter array binding" and found two hits. But I still have a couple of questions about this warning message.
I have several simple load jobs that just read a sequential file, do simple transformations and write to a table. I always use the "clear table then insert" option. The tables have no key columns. In the logs I always receive two warning messages at the start of each run.
Warning: "This update action 'DELETE FROM {tablename}' is not compatible with parameter array binding. Array Size property will be set to 1."
Warning: "The SQL statement will modify an entire table or view."
I tried changing my array size from the default 50 to 1, but I still receive the same messages and the job ran four times longer. So I changed it back to 50. DB2 always gives a warning message for a "delete from table" action. I often will do a "delete from table where 1=1" just to avoid the warning.
Anyone have any ideas on how I can avoid both warnings? I'd like my jobs to exit with "Job Finished OK", rather than "Job finished with warnings" - so I can tell a real problem/warning from the these benign ones.
Dave
warning message about parameter array binding...
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Fri May 29, 2009 9:23 am
-
- Participant
- Posts: 9
- Joined: Fri May 29, 2009 9:23 am