SAP SQL Anywhere

Question

We're considering a PKB implementation against our ASE DB. As it stands now, there's not a native ASE Driver for PKB. All the literature I see recommends using a direct connection to ASA, with proxies to the source ASE system. Is there a way to directly execute a procedure in the ASE database? Or, does this configuration mean that only table level access via the proxys is available?

Answer 1

Once you create a proxy server in SA to connect to your ASE server, you can issue a

FORWARD TO server-name { sql-statement }

to send the sql-statement to the server-name (i.e. ASE) server. In your scenerio, your sql statement would be the call to the ASE procedure.

This is discussed in the SQLAnywhere docs which you can view here: http://dcx.sybase.com/index.html#1101en/dbreference_en11/forward-to-statement.html

SAP SQL Anywhere

execute SP in ASE through ASA

Follow this question

Related questions