| Ln:1 SELECT | |
| Ln:1 select coalesce(max(info_id)+1,0) into NextID from sproc_info with rr use and keep exclusive locks | |
| Ln:1 Not executed - offline mode set | |
| Ln:3 SELECT | |
| Ln:3 select cd, cd + inc days, cd - inc days + coalesce(inc, 0) days | |
| from (select date '2015-09-02' as cd, 3 as inc from sysibm.sysdummy1) | |
| Ln:3 Not executed - offline mode set |