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
When I joined IDUG as a volunteer a few years ago I was surprised that IDUG were not providing any Db2 education in Latin Amercia. The majority of the events and user group activities were concentrated in North America, Europe and Australia.
As a naive Spanish speaker I had a vision to extend IDUG into Latin Amercia. I am please to inform you that IDUG are hosting two events in Latin Amercia this…Continue
Added by Manuel Gomez Burriel on August 17, 2019 at 18:08 — 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