Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
pkmurali
Warnings : 1

Active User


Joined: 15 Dec 2005
Posts: 236

PostPosted: Mon Jun 22, 2015 8:36 am    Post subject: How to define and use Double dimension array Array [10][10]
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Mon Jun 22, 2015 11:52 am    Post subject: Reply to: How to define and use Double dimension array Array [10][10]
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: 236

PostPosted: Mon Jun 22, 2015 2:13 pm    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Mon Jun 22, 2015 2:21 pm    Post subject: Reply to: How to define and use Double dimension array Array [10][10]
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am
No new posts Unstring list of values into an array. Roshnii COBOL Programming 8 Mon Jun 27, 2016 6:25 pm
No new posts How to define PCB for paired segments ashok_uddaraju IMS DB/DC 4 Tue Jun 14, 2016 11:40 pm
No new posts Define Alias for multiple Data sets u... sandy98669 JCL & VSAM 4 Fri May 27, 2016 1:07 pm
No new posts trying to define a VSAM Cluster in JCL t5590ag JCL & VSAM 10 Thu May 19, 2016 5:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us