I was reading the information about array functions in the InfoCenter, and I think I found a mistake in the documentation.
The array functions I am interested are the following (with the documentation):
However, in the section (AppDev > SQL PL support > SQL PL data types) where the arrays are explained, the functions' name are not equal. They are FIRST, LAST and NEXT, without the prefix ARRAY_. The most terrible is PREV that does not match with ARRAY_PRIOR.
That confused me a lot because at the beginning I was reading only this section, and when I tried to execute the commands, all generated errors.
Arrays information http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.apdv.sqlpl.doc/doc/t0053486.html
First and Last http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.apdv.sqlpl.doc/doc/t0053489.html
Next and Prev http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.apdv.sqlpl.doc/doc/t0053490.html
Can someone in IBM correct that?
PS. I wrote a comment about this in the InfoCenter 10.1, but it does not appear.
This topic has been locked.