Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Dimensional Arrays

4 posts in Product Futures Discussion Last posting was on 2003-03-22 00:05:11.0Z
putnamr Posted on 2003-03-19 18:29:29.0Z
From: putnamr@river.it.gvsu.edu
Date: Wed, 19 Mar 2003 13:29:29 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Dimensional Arrays
Message-ID: <90626ACE88F8A694006593BD85256CEE.006593CC85256CEE@webforums>
Lines: 10
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1023
Article PK: 95263

Hello,

Will ASE in the future support at least a 2-dimensional array in procedure
cache using TSQL?

Example)
CREATE DIMENSION MY_DIMENSION[20][5] AS CHAR(20)

Thanks,
Ryan Putnam


Pablo Sanchez Posted on 2003-03-19 18:41:57.0Z
Subject: Re: Dimensional Arrays
From: Pablo Sanchez <pablo@dev.null>
References: <90626ACE88F8A694006593BD85256CEE.006593CC85256CEE@webforums>
Organization: High-Performance Database Engineering
Message-ID: <Xns934376A4C79F0pingottpingottbah@192.138.151.106>
User-Agent: Xnews/06.01.10
Newsgroups: sybase.public.ase.product_futures_discussion
Date: Wed, 19 Mar 2003 10:41:57 -0800
NNTP-Posting-Host: host-4-069.ionsky.com 66.35.44.69
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1026
Article PK: 95265

putnamr@river.it.gvsu.edu wrote in
news:90626ACE88F8A694006593BD85256CEE.006593CC85256CEE@webforums:

> Hello,
>
> Will ASE in the future support at least a 2-dimensional array in procedure
> cache using TSQL?
>
> Example)
> CREATE DIMENSION MY_DIMENSION[20][5] AS CHAR(20)

While we're at it, we should also ensure that associative arrays are
implemented as well.
--
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com


Sherlock, Kevin Posted on 2003-03-21 18:05:16.0Z
Message-ID: <3E7B544F.AACFF564@qwest.com.nospam>
Date: Fri, 21 Mar 2003 12:05:16 -0600
From: "Sherlock, Kevin" <ksherlo@qwest.com.nospam>
Reply-To: ksherlo@qwest.com.nospam
Organization: QWEST Wireless
X-Mailer: Mozilla 4.79 (Macintosh; U; PPC)
X-Accept-Language: en,pdf,ko
MIME-Version: 1.0
Subject: Re: Dimensional Arrays
References: <90626ACE88F8A694006593BD85256CEE.006593CC85256CEE@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: np45.qwest.com 155.70.39.45
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1031
Article PK: 95269

Can't you already do this with java in ASE? Or, am I misunderstanding
your requirement?

Some vendors (like Oracle) choose to implement some extention to SQL (or
layer on top of SQL) like "PL1".

In ASE, I'd go out on a limb and say anything you could code-up in PL1,
can be done with java.

putnamr@river.it.gvsu.edu wrote:
>
> Hello,
>
> Will ASE in the future support at least a 2-dimensional array in procedure
> cache using TSQL?
>
> Example)
> CREATE DIMENSION MY_DIMENSION[20][5] AS CHAR(20)
>
> Thanks,
> Ryan Putnam


putnamr Posted on 2003-03-22 00:05:11.0Z
From: putnamr@river.it.gvsu.edu
Date: Fri, 21 Mar 2003 19:05:11 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Dimensional Arrays
Message-ID: <43A4C21ED80F02210000797885256CF1.0068735485256CF0@webforums>
References: <90626ACE88F8A694006593BD85256CEE.006593CC85256CEE@webforums> <3E7B544F.AACFF564@qwest.com.nospam>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1032
Article PK: 95271

Hello,

I am sure that you can do it in Java, but that requires you to pay more and
support a lot more. I would like to be able to do this through TSQL and
procedure cache.