Add two business days to a date

[gwilburn]

IBM's official response:

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzoffset.htm

Allowed use of OFFSET: The offset-clause is only allowed as part of the outer fullselect of a DECLARE CURSOR statement or a prepared select-statement. It is not supported in interactive SQL.

Remember not supported doesn't mean you might not be able to get it to work here or there, but it isn't supported until recent PTF levels of R720 and R730.

Since R720 goes out of support soon, you should be looking at an upgrade anyway.


FWIW - I am doing an upgrade very soon.

[Viking]

Ok, so now I'm on Level 21 of SF99702, and now both LIMIT and OFFSET work in my old interactive green screen STRSQL. I was on Level 18 previously, and even though my machine could use LIMIT and OFFSET with only level 18 (via ACS Run SQL Scripts, Linoma Surveyor, etc.), I guess the green screen STRSQL needed the higher PTF level of at least 19. These both work now:

SELECT * FROM myFile     
ORDER BY myField          
offset 2 rows

SELECT * FROM myFile
ORDER BY myField         
limit 2,1