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.

Define an array in SQL Anywhere 9.0.2

4 posts in General Discussion Last posting was on 2010-03-20 08:25:12.0Z
Partha Posted on 2010-03-19 13:04:40.0Z
Sender: 6fb0.4ba136c1.1804289383@sybase.com
From: Partha
Newsgroups: ianywhere.public.general
Subject: Define an array in SQL Anywhere 9.0.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ba37668.513b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Mar 2010 05:04:40 -0800
X-Trace: forums-1-dub 1269003880 10.22.241.41 (19 Mar 2010 05:04:40 -0800)
X-Original-Trace: 19 Mar 2010 05:04:40 -0800, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7985
Article PK: 7012

Hi All,

What is the syntax to declare an array in SQL Anywhere
9.0.2?


Rob Waywell Posted on 2010-03-19 14:41:51.0Z
From: "Rob Waywell" <rwaywell_no_spam@sybase.com>
Newsgroups: ianywhere.public.general
References: <4ba37668.513b.1681692777@sybase.com>
Subject: Re: Define an array in SQL Anywhere 9.0.2
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ba38d2f@forums-1-dub>
Date: 19 Mar 2010 06:41:51 -0800
X-Trace: forums-1-dub 1269009711 10.22.241.152 (19 Mar 2010 06:41:51 -0800)
X-Original-Trace: 19 Mar 2010 06:41:51 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7988
Article PK: 7016

Partha,
Can you provide a bit more context? For example are you trying to
declare a column or datatype that is an array? There is no array datatype in
SQL Anywhere.

On the other hand, if you happen to be writing a C/C++ app and using the
Embedded SQL programming interface, then you would be using arrays when
executing a wide fetch or a wide insert:
ASA Programming Guide

Embedded SQL Programming

Fetching data

Fetching more than one row at a time
___________________________________
ASA SQL Reference

SQL Statements

EXECUTE statement [ESQL]
_______________________________________

Robert Waywell | Practice Manager | Sybase iAnywhere | 519.883.6226 |
rwaywell@sybase.com | www.sybase.com

<Partha> wrote in message news:4ba37668.513b.1681692777@sybase.com...
> Hi All,
>
> What is the syntax to declare an array in SQL Anywhere
> 9.0.2?


Partha Posted on 2010-03-19 14:56:53.0Z
Sender: 5446.4ba38fc2.1804289383@sybase.com
From: Partha
Newsgroups: ianywhere.public.general
Subject: Re: Define an array in SQL Anywhere 9.0.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ba390b5.5486.1681692777@sybase.com>
References: <4ba38d2f@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Mar 2010 06:56:53 -0800
X-Trace: forums-1-dub 1269010613 10.22.241.41 (19 Mar 2010 06:56:53 -0800)
X-Original-Trace: 19 Mar 2010 06:56:53 -0800, 10.22.241.41
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7989
Article PK: 7017

Hi,

I want to used an array in store procedure as a input
parameter. How I will declare the array in sql anywhre.

> Partha,
> Can you provide a bit more context? For example are
> you trying to declare a column or datatype that is an
> array? There is no array datatype in SQL Anywhere.
>
> On the other hand, if you happen to be writing a C/C++
> app and using the Embedded SQL programming interface,
> then you would be using arrays when executing a wide
> fetch or a wide insert: ASA Programming Guide
>
> Embedded SQL Programming
>
> Fetching data
>
> Fetching more than one row at a time
> ___________________________________
> ASA SQL Reference
>
> SQL Statements
>
> EXECUTE statement [ESQL]
> _______________________________________
>
> Robert Waywell | Practice Manager | Sybase iAnywhere |
> 519.883.6226 | rwaywell@sybase.com | www.sybase.com
>
>
> <Partha> wrote in message
> > news:4ba37668.513b.1681692777@sybase.com... Hi All,
> >
> > What is the syntax to declare an array in SQL Anywhere
> > 9.0.2?
>
>


Breck Carter [TeamSybase] Posted on 2010-03-20 08:25:12.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Define an array in SQL Anywhere 9.0.2
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <nc19q55ukd4jdctv9m379vbjehcagijqb7@4ax.com>
References: <4ba38d2f@forums-1-dub> <4ba390b5.5486.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 20 Mar 2010 00:25:12 -0800
X-Trace: forums-1-dub 1269073512 10.22.241.152 (20 Mar 2010 00:25:12 -0800)
X-Original-Trace: 20 Mar 2010 00:25:12 -0800, vip152.sybase.com
Lines: 64
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7990
Article PK: 7021

SQL Anywhere doesn't support arrays in the SQL language.

This is a holdover from the original design of relational databases:
"we don't need no steenking arrays, we have tables!"

In the real world, we DO need arrays... and maybe, someday, we will
get them.

Breck

On 19 Mar 2010 06:56:53 -0800, Partha wrote:

>Hi,
>
>I want to used an array in store procedure as a input
>parameter. How I will declare the array in sql anywhre.
>
>> Partha,
>> Can you provide a bit more context? For example are
>> you trying to declare a column or datatype that is an
>> array? There is no array datatype in SQL Anywhere.
>>
>> On the other hand, if you happen to be writing a C/C++
>> app and using the Embedded SQL programming interface,
>> then you would be using arrays when executing a wide
>> fetch or a wide insert: ASA Programming Guide
>>
>> Embedded SQL Programming
>>
>> Fetching data
>>
>> Fetching more than one row at a time
>> ___________________________________
>> ASA SQL Reference
>>
>> SQL Statements
>>
>> EXECUTE statement [ESQL]
>> _______________________________________
>>
>> Robert Waywell | Practice Manager | Sybase iAnywhere |
>> 519.883.6226 | rwaywell@sybase.com | www.sybase.com
>>
>>
>> <Partha> wrote in message
>> > news:4ba37668.513b.1681692777@sybase.com... Hi All,
>> >
>> > What is the syntax to declare an array in SQL Anywhere
>> > 9.0.2?
>>
>>

--
Breck Carter

Visit SQLA! ...the new SQL Anywhere online community
http://sqla.stackexchange.com

Blog: http://sqlanywhere.blogspot.com/

RisingRoad helps SQL Anywhere developers make better databases...
http://www.risingroad.com/

Breck.Carter at gmail