View previous topic :: View next topic
|
Author |
Message |
pkmurali Warnings : 1 Active User
Joined: 15 Dec 2005 Posts: 271
|
|
|
|
Hi all
How to define double dimension array in stored procedure using create type array [10][10]
I have seen examples in IBM sites having single dimension array. Even go ogling for double dimension array I am not able to get any
Thanks
Murali |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Perhaps you can locate the (recent) documentation of "create type array" for DB2 for z/OS and read it? |
|
Back to top |
|
|
pkmurali Warnings : 1 Active User
Joined: 15 Dec 2005 Posts: 271
|
|
|
|
Thanks Bill.
I have read the creat type as mentioned in the below URL
[url=http://https://www-01.ibm.com/support/knowledgecenter/#!/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0050497.html?cp=SSEPGG_9.7.0%2F2-10-6-97]
my doubt is
if i have a data type as CLOB which has 150*10000 storage
CREATE TYPE PHONENUMBERS AS CLOB
ARRAY[150][10000]
will the above declaration will be accepted?[/url] |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
I deliberately asked about DB2 for z/OS. You are showing a document for DB2 for LUW (Linux-Unix-Windows).
I haven't looked at the link you've shown, but if the syntax-diagram and the description indicate it is possible, then it is possible. If they don't, then it isn't.
As a hint, DB2 11 for z/OS, where it was introduced, does not allow for multiple dimensions. |
|
Back to top |
|
|
|