Topic
No replies
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic Array function examples with incorrect names

‏2012-11-20T12:32:25Z |
Hi,

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):

ARRAY_FIRST http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0055005.html
ARRAY_LAST http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0055006.html
ARRAY_NEXT http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0055007.html
ARRAY_PRIOR http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0055011.html

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.