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.

How can I access .DLL functions from Stored Procedures?

3 posts in Product Futures Discussion Last posting was on 2002-02-21 15:26:12.0Z
Jim T Posted on 2002-02-20 17:57:42.0Z
From: Jim T <jtough@helical.ns.ca>
Date: Wed, 20 Feb 2002 12:57:42 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: How can I access .DLL functions from Stored Procedures?
Message-ID: <B70943BA1892BE1E0062AAD485256B66.0062AAF685256B66@webforums>
Lines: 17
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:760
Article PK: 94287

I am new to Sybase products and I am trying to replicate an interface I
built for an Oracle 8.x server on a Sybase ASE 12.5 server.

In Oracle, I was able to use a LIBRARY declaration to link a .DLL to the
database (or a .SO under UNIX) and then I was able to call the .DLL
functions as if they were stored procedures. I wrote the .DLL myself, and
it had to meet the restrictions in the Oracle reference document.

I have been trying to find a similar feature in Sybase ASE 12.5, but I have
been unsuccessful so far. I just need to know the name of the
product/component so I can get the online manuals.

Any suggestions?

Jim Tough
Helical Systems Limited
jtough@helical.ns.ca


Bret Halford Posted on 2002-02-20 21:18:47.0Z
Message-ID: <3C7412B7.898DBA03@sybase.com>
Date: Wed, 20 Feb 2002 14:18:47 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: How can I access .DLL functions from Stored Procedures?
References: <B70943BA1892BE1E0062AAD485256B66.0062AAF685256B66@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 28
NNTP-Posting-Host: 157.133.80.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:759
Article PK: 94289

Hi Jim,

Two things come to mind:

extended stored procedures - see chapter 15 of the ASE 12.0 TSQL Guide
http://manuals.sybase.com:80/onlinebooks/group-as/asg1200e

SQLJ user defined functions and stored procedures, using the optional
(seperately licensed)
server-side Java feature. See the Java in ASE manual (same URL).

-bret

Jim T wrote:

> I am new to Sybase products and I am trying to replicate an interface I
> built for an Oracle 8.x server on a Sybase ASE 12.5 server.
>
> In Oracle, I was able to use a LIBRARY declaration to link a .DLL to the
> database (or a .SO under UNIX) and then I was able to call the .DLL
> functions as if they were stored procedures. I wrote the .DLL myself, and
> it had to meet the restrictions in the Oracle reference document.
>
> I have been trying to find a similar feature in Sybase ASE 12.5, but I have
> been unsuccessful so far. I just need to know the name of the
> product/component so I can get the online manuals.
>
> Any suggestions?
>
> Jim Tough
> Helical Systems Limited
> jtough@helical.ns.ca


Jim T Posted on 2002-02-21 15:26:12.0Z
From: Jim T <jtough@helical.ns.ca>
Date: Thu, 21 Feb 2002 10:26:12 -0500
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: How can I access .DLL functions from Stored Procedures?
Message-ID: <EB9F2CF6E70119A00054CBDC85256B67.007AED4085256B66@webforums>
References: <B70943BA1892BE1E0062AAD485256B66.0062AAF685256B66@webforums> <3C7412B7.898DBA03@sybase.com>
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!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:758
Article PK: 94286

Thanks Bret, that is exactly what I was looking for.

Jim Tough
Helical Systems Limited
jtough@helical.ns.ca