IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to define and use Double dimension array Array [10][10]


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 271

PostPosted: Mon Jun 22, 2015 8:36 am
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Jun 22, 2015 11:52 am
Reply with quote

Perhaps you can locate the (recent) documentation of "create type array" for DB2 for z/OS and read it?
Back to top
View user's profile Send private message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 271

PostPosted: Mon Jun 22, 2015 2:13 pm
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Jun 22, 2015 2:21 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DTL - how to define key with stacked ... TSO/ISPF 3
No new posts Help in extracting data between doubl... DFSORT/ICETOOL 5
No new posts COBOL Ascending and descending sort n... COBOL Programming 5
No new posts To find an array of words (sys-symbol... JCL & VSAM 9
No new posts Define default volume for DSN storage... JCL & VSAM 8
Search our Forums:

Back to Top