IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
Sometimes it is useful to generate JCL executable code for //SYSIN via SQL mass operations, e.g. change specific tables from one option to another. If the result row fits into one JCL line with a length of 72, then all is fine. If the line must be split, then the question comes up: How to split?
Here is a solution for commands (like REBIND PACKAGE), SQL (like ALTER TRIGGER) or…Continue
AUTOBIND is a very useful automation instrument inside the Db2 engine.
Suppose you change the definition of the table or index and these changes have impact on the dependent package, the static SQL package is marked as invalid,…Continue
Added by Peter Hartmann on August 20, 2019 at 19:29 — No Comments
If you think you know all about APPLCOMPAT, then please read this!
Advanced triggers introduced in V12 allow SQL PL statements and this opens “SQL only applications” to triggers. There is reduced need to call a stored procedure,…Continue
Added by Peter Hartmann on August 7, 2019 at 11:13 — No Comments