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.

SQL Function for MS-SQL compatibilty

6 posts in Product Futures Discussion Last posting was on 2005-03-16 13:17:29.0Z
Raynald M. Posted on 2005-03-03 00:49:47.0Z
From: "Raynald M." <no_spam_bilou120000@hotmail.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: fr, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: SQL Function for MS-SQL compatibilty
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: fuujin.kitagawa-ind.co.jp
X-Original-NNTP-Posting-Host: fuujin.kitagawa-ind.co.jp
Message-ID: <42265f2b$1@forums-1-dub>
Date: 2 Mar 2005 16:49:47 -0800
X-Trace: forums-1-dub 1109810987 219.96.229.20 (2 Mar 2005 16:49:47 -0800)
X-Original-Trace: 2 Mar 2005 16:49:47 -0800, fuujin.kitagawa-ind.co.jp
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1677
Article PK: 96672

Hi,

There is any chance that Sybase implement customize SQL function in ASE ?
We would make softwares who be compatible with both database ASE 12...
and MS SQL 2000. At this time, we do it except for SQL Function.

Nobody have some information on it ?

thx


Carl Kayser Posted on 2005-03-03 19:49:47.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <42265f2b$1@forums-1-dub>
Subject: Re: SQL Function for MS-SQL compatibilty
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: 146.142.33.192
Message-ID: <42276a54$1@forums-2-dub>
X-Original-Trace: 3 Mar 2005 11:49:40 -0800, 146.142.33.192
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Mar 2005 11:49:42 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Mar 2005 11:49:47 -0800
X-Trace: forums-1-dub 1109879387 10.22.108.75 (3 Mar 2005 11:49:47 -0800)
X-Original-Trace: 3 Mar 2005 11:49:47 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1682
Article PK: 96670

This was an ISUG enhancement request (9310_18) that "went nowhere". Then
there is request e01_274 which is basically the same. Sybase has indicated
to ISUG that it is planned. Which future release is the interesting
question.

"Raynald M." <no_spam_bilou120000@hotmail.com> wrote in message
news:42265f2b$1@forums-1-dub...
> Hi,
>
> There is any chance that Sybase implement customize SQL function in ASE ?
> We would make softwares who be compatible with both database ASE 12...
> and MS SQL 2000. At this time, we do it except for SQL Function.
>
> Nobody have some information on it ?
>
> thx


Bob Winter Posted on 2005-03-10 03:33:02.0Z
Sender: 2dd1.422fbef3.1804289383@sybase.com
From: Bob Winter
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: SQL Function for MS-SQL compatibilty
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <422fbfee.2ea6.1681692777@sybase.com>
References: <42276a54$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Mar 2005 19:33:02 -0800
X-Trace: forums-1-dub 1110425582 10.22.241.41 (9 Mar 2005 19:33:02 -0800)
X-Original-Trace: 9 Mar 2005 19:33:02 -0800, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1685
Article PK: 96674

The syntax isn't the same but T-SQL Functions can simulated.
See Re: Does Sybase T-Sql support custom functions like MS
Sql, from 5/26/04.
http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-1554&group=sybase.public.ase.product_futures_discussion

Bob Winter

> This was an ISUG enhancement request (9310_18) that "went
> nowhere". Then there is request e01_274 which is
> basically the same. Sybase has indicated to ISUG that it
> is planned. Which future release is the interesting
> question.
>
> "Raynald M." <no_spam_bilou120000@hotmail.com> wrote in
> message news:42265f2b$1@forums-1-dub...
> > Hi,
> >
> > There is any chance that Sybase implement customize SQL
> > function in ASE ? We would make softwares who be
> > compatible with both database ASE 12... and MS SQL 2000.
> At this time, we do it except for SQL Function. >
> > Nobody have some information on it ?
> >
> > thx
>
>


Raynald M. Posted on 2005-03-10 11:05:38.0Z
From: "Raynald M." <no_spam_bilou120000@hotmail.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: fr, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: SQL Function for MS-SQL compatibilty
References: <42276a54$1@forums-2-dub> <422fbfee.2ea6.1681692777@sybase.com>
In-Reply-To: <422fbfee.2ea6.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: arouen-106-2-2-129.w193-251.abo.wanadoo.fr
X-Original-NNTP-Posting-Host: arouen-106-2-2-129.w193-251.abo.wanadoo.fr
Message-ID: <42302a02@forums-1-dub>
Date: 10 Mar 2005 03:05:38 -0800
X-Trace: forums-1-dub 1110452738 193.251.92.129 (10 Mar 2005 03:05:38 -0800)
X-Original-Trace: 10 Mar 2005 03:05:38 -0800, arouen-106-2-2-129.w193-251.abo.wanadoo.fr
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1686
Article PK: 96671

ok for this, but it's not a really answer for my compatibility with
MS-SQL. We respect the commons rules of each and it's ok, except with
function.

Bob Winter a écrit :

> The syntax isn't the same but T-SQL Functions can simulated.
> See Re: Does Sybase T-Sql support custom functions like MS
> Sql, from 5/26/04.
> http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-1554&group=sybase.public.ase.product_futures_discussion
>
> Bob Winter
>
>
>>This was an ISUG enhancement request (9310_18) that "went
>>nowhere". Then there is request e01_274 which is
>>basically the same. Sybase has indicated to ISUG that it
>>is planned. Which future release is the interesting
>>question.
>>
>>"Raynald M." <no_spam_bilou120000@hotmail.com> wrote in
>>message news:42265f2b$1@forums-1-dub...
>>
>>>Hi,
>>>
>>>There is any chance that Sybase implement customize SQL
>>>function in ASE ? We would make softwares who be
>>>compatible with both database ASE 12... and MS SQL 2000.
>>
>>At this time, we do it except for SQL Function. >
>>
>>>Nobody have some information on it ?
>>>
>>>thx
>>
>>


Jeff Tallman Posted on 2005-03-11 07:00:22.0Z
From: Jeff Tallman <tallman@sybase.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: SQL Function for MS-SQL compatibilty
References: <42276a54$1@forums-2-dub> <422fbfee.2ea6.1681692777@sybase.com> <42302a02@forums-1-dub>
In-Reply-To: <42302a02@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Original-NNTP-Posting-Host: 67.127.179.10
Message-ID: <42314202$1@forums-2-dub>
X-Original-Trace: 10 Mar 2005 23:00:18 -0800, 67.127.179.10
Lines: 48
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Mar 2005 23:00:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Mar 2005 23:00:22 -0800
X-Trace: forums-1-dub 1110524422 10.22.108.75 (10 Mar 2005 23:00:22 -0800)
X-Original-Trace: 10 Mar 2005 23:00:22 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1687
Article PK: 96675


Raynald M. wrote:
> ok for this, but it's not a really answer for my compatibility with
> MS-SQL. We respect the commons rules of each and it's ok, except with
> function.
>
> Bob Winter a écrit :
>
>> The syntax isn't the same but T-SQL Functions can simulated.
>> See Re: Does Sybase T-Sql support custom functions like MS
>> Sql, from 5/26/04.
>> http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-1554&group=sybase.public.ase.product_futures_discussion
>>
>>
>> Bob Winter
>>
>>
>>> This was an ISUG enhancement request (9310_18) that "went
>>> nowhere". Then there is request e01_274 which is
>>> basically the same. Sybase has indicated to ISUG that it
>>> is planned. Which future release is the interesting
>>> question.
>>>
>>> "Raynald M." <no_spam_bilou120000@hotmail.com> wrote in
>>> message news:42265f2b$1@forums-1-dub...
>>>
>>>> Hi,
>>>>
>>>> There is any chance that Sybase implement customize SQL
>>>> function in ASE ? We would make softwares who be
>>>> compatible with both database ASE 12... and MS SQL 2000.
>>>
>>>
>>> At this time, we do it except for SQL Function. >
>>>
>>>> Nobody have some information on it ?
>>>>
>>>> thx
>>>
>>>
>>>

The closest thing would be to use the SQLJ functions - from a call level
implementation, the SQL would be identical. However, from an
implementation level, you get to take advantage of java's richer
functionality - both in mneumonics as well as object types (hashmaps,
treemaps, etc) - the latter may provide extensive performance
improvements over strict SQL implementations due to the ability to have
programmatic control of data caching.


Jan Zelenka Posted on 2005-03-16 13:17:29.0Z
From: Jan Zelenka <jan.zelenka@profinit.cz>
Reply-To: jan.zelenka@profinit.cz
Organization: Profinit
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: SQL Function for MS-SQL compatibilty
References: <42276a54$1@forums-2-dub> <422fbfee.2ea6.1681692777@sybase.com> <42302a02@forums-1-dub> <42314202$1@forums-2-dub>
In-Reply-To: <42314202$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: pd9e21d57.dip.t-dialin.net
X-Original-NNTP-Posting-Host: pd9e21d57.dip.t-dialin.net
Message-ID: <423831e9@forums-1-dub>
Date: 16 Mar 2005 05:17:29 -0800
X-Trace: forums-1-dub 1110979049 217.226.29.87 (16 Mar 2005 05:17:29 -0800)
X-Original-Trace: 16 Mar 2005 05:17:29 -0800, pd9e21d57.dip.t-dialin.net
Lines: 71
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1688
Article PK: 96676


Jeff Tallman wrote:
> Raynald M. wrote:
>
>> ok for this, but it's not a really answer for my compatibility with
>> MS-SQL. We respect the commons rules of each and it's ok, except with
>> function.
>>
>> Bob Winter a écrit :
>>
>>> The syntax isn't the same but T-SQL Functions can simulated.
>>> See Re: Does Sybase T-Sql support custom functions like MS
>>> Sql, from 5/26/04.
>>> http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-1554&group=sybase.public.ase.product_futures_discussion
>>>
>>>
>>> Bob Winter
>>>
>>>
>>>> This was an ISUG enhancement request (9310_18) that "went
>>>> nowhere". Then there is request e01_274 which is
>>>> basically the same. Sybase has indicated to ISUG that it
>>>> is planned. Which future release is the interesting
>>>> question.
>>>>
>>>> "Raynald M." <no_spam_bilou120000@hotmail.com> wrote in
>>>> message news:42265f2b$1@forums-1-dub...
>>>>
>>>>> Hi,
>>>>>
>>>>> There is any chance that Sybase implement customize SQL
>>>>> function in ASE ? We would make softwares who be
>>>>> compatible with both database ASE 12... and MS SQL 2000.
>>>>
>>>>
>>>>
>>>> At this time, we do it except for SQL Function. >
>>>>
>>>>> Nobody have some information on it ?
>>>>>
>>>>> thx
>>>>
>>>>
>>>>
>>>>
>
> The closest thing would be to use the SQLJ functions - from a call level
> implementation, the SQL would be identical. However, from an
> implementation level, you get to take advantage of java's richer
> functionality - both in mneumonics as well as object types (hashmaps,
> treemaps, etc) - the latter may provide extensive performance
> improvements over strict SQL implementations due to the ability to have
> programmatic control of data caching.

Most production ASE servers don't use JAVA. Introducing java into
production ASE server brings serious concerns about performance,
reliability etc. It's also paid option. Facing this, it's easier for the
developer to use stored procedures as a workaround. So mostly (at least
in my experience) ASE JAVA is not a solution.
I really would like to know why Sybase resists all the requests for TSQL
functions. It's not that Sybase doesn't realize the need to be
compatible with MSSQL - in some 12.5.x.x version there are new built-in
functions (with the functionality already available via different
built-in functions or syntax) just for the reason to by compatible. If
ASE had TSQL functions, it would by enough to add these function as
scripts to installmaster. How easier and more elegant.

Jan Zelenka