Timeline for DB2 Dynamic Load from cursor
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 17, 2016 at 13:02 | history | tweeted | twitter.com/StackDBAs/status/710451295648354304 | ||
| Feb 17, 2016 at 10:10 | vote | accept | rrrohanb | ||
| Feb 17, 2016 at 10:10 | answer | added | rrrohanb | timeline score: 2 | |
| Dec 25, 2015 at 20:36 | comment | added | rrrohanb | Thanks it worked!! Any issues if I use cursor with hold? There are other statements that I will need to call in the same loop of this works fine.. | |
| Dec 25, 2015 at 15:33 | comment | added | mustaccio | COMMIT closes the cursor. You don't need that commit anyway, because the LOAD utility is not under transaction control. | |
| Dec 25, 2015 at 9:03 | history | edited | rrrohanb | CC BY-SA 3.0 | Noticed a Commit in the procedure inside the loop. Added the same here. |
| Dec 25, 2015 at 5:02 | comment | added | rrrohanb | Also if i comment the Call to ADMIN_CMD it runs without any issue. | |
| Dec 25, 2015 at 4:57 | history | asked | rrrohanb | CC BY-SA 3.0 |