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.

Local External Stored Procedure Call Workaround

5 posts in Appeon (partner product) Last posting was on 2005-03-11 08:54:55.0Z
Chuck Kahn Posted on 2005-03-08 14:29:44.0Z
From: "Chuck Kahn" <chuck.kahn@lmco.com>
Newsgroups: sybase.public.appeon
Subject: Local External Stored Procedure Call Workaround
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: edge1a.lmco.com
X-Original-NNTP-Posting-Host: edge1a.lmco.com
Message-ID: <422db6d8$1@forums-1-dub>
Date: 8 Mar 2005 06:29:44 -0800
X-Trace: forums-1-dub 1110292184 192.31.106.194 (8 Mar 2005 06:29:44 -0800)
X-Original-Trace: 8 Mar 2005 06:29:44 -0800, edge1a.lmco.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:705
Article PK: 20863

I am trying to implement local external functions in object n_tr. These
externals are stored procedure calls in Sybase ASE. Unfortunately, it is
indicating in Appeon that stored procedure calls as local externals with the
keyword RPCFUNC are unsupported. What is the workaround?

Thank you.

Chuck


Julie Jiang Posted on 2005-03-09 00:50:57.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <422db6d8$1@forums-1-dub>
Subject: Re: Local External Stored Procedure Call Workaround
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: 210.21.221.178
Message-ID: <422e486c$1@forums-2-dub>
X-Original-Trace: 8 Mar 2005 16:50:52 -0800, 210.21.221.178
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Mar 2005 16:50:54 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Mar 2005 16:50:57 -0800
X-Trace: forums-1-dub 1110329457 10.22.108.75 (8 Mar 2005 16:50:57 -0800)
X-Original-Trace: 8 Mar 2005 16:50:57 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:706
Article PK: 12666

Hi Chuck,

There are two workarounds.
Method #1:
we can use n-Tier NVOs to encapsulate and work around RPC calls:

1) Deploy the user object (transaction type, user object A) that contains
RPC calls to stored procedures.

2) Create a user object (non-visual userobject type, user object B) for
calling to the RPC. Deploy the user object to the server side.

*** User object B will be the bridge NVO between the client application and
the user object A.

*** Follow the instructions in Section 5.2, Distributed desktop applications
in Appeon Migration Guide to generate proxy object, Stub/Skeleton for user
object B.

*** You can place the script for calling to the RPC in the object B.
*** The reason that the client application cannot directly talk with the
user object A is that user object A is standard class user object and cannot
generate Proxy.

Method #2:
rewrite the calling syntax. For example, if the declaration syntax is:
subroutine SAMPLE(string PARM1,ref string PARM2) RPCFUNC ALIAS FOR "SAMPLE"

Change the declaration syntax to:
string ls_parm1,ls_parm2
ls_parm1 = 'ABC'
DECLARE Sample PROCEDURE FOR SCOTT.SAMPLE (:ls_parm1);
execute Sample ;
fetch Sample into:ls_parm2;
messagebox("ls_parm2",ls_parm2)
commit ;
close Sample;

Regards,
Julie

"Chuck Kahn" <chuck.kahn@lmco.com> wrote in message
news:422db6d8$1@forums-1-dub...
> I am trying to implement local external functions in object n_tr. These
> externals are stored procedure calls in Sybase ASE. Unfortunately, it is
> indicating in Appeon that stored procedure calls as local externals with
the
> keyword RPCFUNC are unsupported. What is the workaround?
>
> Thank you.
>
> Chuck
>
>


Chuck Kahn Posted on 2005-03-09 14:20:00.0Z
From: "Chuck Kahn" <chuck.kahn@lmco.com>
Newsgroups: sybase.public.appeon
References: <422db6d8$1@forums-1-dub> <422e486c$1@forums-2-dub>
Subject: Re: Local External Stored Procedure Call Workaround
Lines: 84
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: edge1a.lmco.com
Message-ID: <422f060d$1@forums-2-dub>
X-Original-Trace: 9 Mar 2005 06:19:57 -0800, edge1a.lmco.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Mar 2005 06:19:58 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Mar 2005 06:20:00 -0800
X-Trace: forums-1-dub 1110378000 10.22.108.75 (9 Mar 2005 06:20:00 -0800)
X-Original-Trace: 9 Mar 2005 06:20:00 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:707
Article PK: 12667

Julie,

In Method 2, I believe what you gave me is using a stored procedures in
Oracle. Is the syntax the same for DBMS Sybase ASE 12.x as I looked up the
DECLARE in PB help and it was giving me syntax similar to:

DECLARE Sample procedure for
sample_sps @olddate = :ldt_olddate , @newdate = ldt_newdate
USING SQLCA;

What is the syntax if a variable in the ASE 12.5.x stored procedure is an
"output" variable?

Thanks

Chuck

"Julie Jiang" <julie.jiang@appeon.net> wrote in message
news:422e486c$1@forums-2-dub...
> Hi Chuck,
>
> There are two workarounds.
> Method #1:
> we can use n-Tier NVOs to encapsulate and work around RPC calls:
>
> 1) Deploy the user object (transaction type, user object A) that contains
> RPC calls to stored procedures.
>
> 2) Create a user object (non-visual userobject type, user object B) for
> calling to the RPC. Deploy the user object to the server side.
>
> *** User object B will be the bridge NVO between the client application
and
> the user object A.
>
> *** Follow the instructions in Section 5.2, Distributed desktop
applications
> in Appeon Migration Guide to generate proxy object, Stub/Skeleton for user
> object B.
>
> *** You can place the script for calling to the RPC in the object B.
> *** The reason that the client application cannot directly talk with the
> user object A is that user object A is standard class user object and
cannot
> generate Proxy.
>
> Method #2:
> rewrite the calling syntax. For example, if the declaration syntax is:
> subroutine SAMPLE(string PARM1,ref string PARM2) RPCFUNC ALIAS FOR
"SAMPLE"
>
> Change the declaration syntax to:
> string ls_parm1,ls_parm2
> ls_parm1 = 'ABC'
> DECLARE Sample PROCEDURE FOR SCOTT.SAMPLE (:ls_parm1);
> execute Sample ;
> fetch Sample into:ls_parm2;
> messagebox("ls_parm2",ls_parm2)
> commit ;
> close Sample;
>
> Regards,
> Julie
>
>
> "Chuck Kahn" <chuck.kahn@lmco.com> wrote in message
> news:422db6d8$1@forums-1-dub...
> > I am trying to implement local external functions in object n_tr. These
> > externals are stored procedure calls in Sybase ASE. Unfortunately, it
is
> > indicating in Appeon that stored procedure calls as local externals with
> the
> > keyword RPCFUNC are unsupported. What is the workaround?
> >
> > Thank you.
> >
> > Chuck
> >
> >
>
>


Julie Jiang Posted on 2005-03-11 08:54:55.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 210.21.221.178
References: <422db6d8$1@forums-1-dub> <422e486c$1@forums-2-dub> <422f060d$1@forums-2-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: Local External Stored Procedure Call Workaround
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <42315cdb$1@forums-2-dub>
X-Original-Trace: 11 Mar 2005 00:54:51 -0800, web110.discountasp.net
Lines: 100
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Mar 2005 00:54:53 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Mar 2005 00:54:55 -0800
X-Trace: forums-1-dub 1110531295 10.22.108.75 (11 Mar 2005 00:54:55 -0800)
X-Original-Trace: 11 Mar 2005 00:54:55 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:712
Article PK: 12669

Hi Chuck,

If your ASE stored procedure contains an OUTPUT variable, the syntax should
be as:

DECLARE sample PROCEDURE FOR sample_sps
@olddate = :ldt_olddate,
@newdate = :ldt_newdate,
@rtn = :ls_rtn OUTPUT; //ls_rtn is the OUTPUT variable

Regards,
Julie

On 9 Mar 2005 06:20:00 -0800,
in sybase.public.appeon

Chuck Kahn <chuck.kahn@lmco.com> wrote:
>Julie,
>
>In Method 2, I believe what you gave me is using a stored procedures in
>Oracle. Is the syntax the same for DBMS Sybase ASE 12.x as I looked up the
>DECLARE in PB help and it was giving me syntax similar to:
>
>DECLARE Sample procedure for
> sample_sps @olddate = :ldt_olddate , @newdate = ldt_newdate
>USING SQLCA;
>
>What is the syntax if a variable in the ASE 12.5.x stored procedure is an
>"output" variable?
>
>Thanks
>
>Chuck
>
>
>"Julie Jiang" <julie.jiang@appeon.net> wrote in message
>news:422e486c$1@forums-2-dub...
>> Hi Chuck,
>>
>> There are two workarounds.
>> Method #1:
>> we can use n-Tier NVOs to encapsulate and work around RPC calls:
>>
>> 1) Deploy the user object (transaction type, user object A) that contains
>> RPC calls to stored procedures.
>>
>> 2) Create a user object (non-visual userobject type, user object B) for
>> calling to the RPC. Deploy the user object to the server side.
>>
>> *** User object B will be the bridge NVO between the client application
>and
>> the user object A.
>>
>> *** Follow the instructions in Section 5.2, Distributed desktop
>applications
>> in Appeon Migration Guide to generate proxy object, Stub/Skeleton for user
>> object B.
>>
>> *** You can place the script for calling to the RPC in the object B.
>> *** The reason that the client application cannot directly talk with the
>> user object A is that user object A is standard class user object and
>cannot
>> generate Proxy.
>>
>> Method #2:
>> rewrite the calling syntax. For example, if the declaration syntax is:
>> subroutine SAMPLE(string PARM1,ref string PARM2) RPCFUNC ALIAS FOR
>"SAMPLE"
>>
>> Change the declaration syntax to:
>> string ls_parm1,ls_parm2
>> ls_parm1 = 'ABC'
>> DECLARE Sample PROCEDURE FOR SCOTT.SAMPLE (:ls_parm1);
>> execute Sample ;
>> fetch Sample into:ls_parm2;
>> messagebox("ls_parm2",ls_parm2)
>> commit ;
>> close Sample;
>>
>> Regards,
>> Julie
>>
>>
>> "Chuck Kahn" <chuck.kahn@lmco.com> wrote in message
>> news:422db6d8$1@forums-1-dub...
>> > I am trying to implement local external functions in object n_tr. These
>> > externals are stored procedure calls in Sybase ASE. Unfortunately, it
>is
>> > indicating in Appeon that stored procedure calls as local externals with
>> the
>> > keyword RPCFUNC are unsupported. What is the workaround?
>> >
>> > Thank you.
>> >
>> > Chuck
>> >
>> >
>>
>>
>
>


Julie Jiang Posted on 2005-03-10 10:14:57.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
References: <422db6d8$1@forums-1-dub> <422e486c$1@forums-2-dub> <422f060d$1@forums-2-dub>
Subject: Re: Local External Stored Procedure Call Workaround
Lines: 104
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 210.21.221.178
X-Original-NNTP-Posting-Host: 210.21.221.178
Message-ID: <42301e21$1@forums-1-dub>
Date: 10 Mar 2005 02:14:57 -0800
X-Trace: forums-1-dub 1110449697 210.21.221.178 (10 Mar 2005 02:14:57 -0800)
X-Original-Trace: 10 Mar 2005 02:14:57 -0800, 210.21.221.178
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:711
Article PK: 20866

Hi Chuck,

I suggest you first try method #1. Appeon engineer thinks that for method
2, if the variable is an "out", it should be ok if you directly add the
"out" between "@" and the variable name. But it takes some time for us to
verify it.

Regards,
Julie

"Chuck Kahn" <chuck.kahn@lmco.com> wrote in message
news:422f060d$1@forums-2-dub...
> Julie,
>
> In Method 2, I believe what you gave me is using a stored procedures in
> Oracle. Is the syntax the same for DBMS Sybase ASE 12.x as I looked up
the
> DECLARE in PB help and it was giving me syntax similar to:
>
> DECLARE Sample procedure for
> sample_sps @olddate = :ldt_olddate , @newdate = ldt_newdate
> USING SQLCA;
>
> What is the syntax if a variable in the ASE 12.5.x stored procedure is an
> "output" variable?
>
> Thanks
>
> Chuck
>
>
> "Julie Jiang" <julie.jiang@appeon.net> wrote in message
> news:422e486c$1@forums-2-dub...
> > Hi Chuck,
> >
> > There are two workarounds.
> > Method #1:
> > we can use n-Tier NVOs to encapsulate and work around RPC calls:
> >
> > 1) Deploy the user object (transaction type, user object A) that
contains
> > RPC calls to stored procedures.
> >
> > 2) Create a user object (non-visual userobject type, user object B) for
> > calling to the RPC. Deploy the user object to the server side.
> >
> > *** User object B will be the bridge NVO between the client application
> and
> > the user object A.
> >
> > *** Follow the instructions in Section 5.2, Distributed desktop
> applications
> > in Appeon Migration Guide to generate proxy object, Stub/Skeleton for
user
> > object B.
> >
> > *** You can place the script for calling to the RPC in the object B.
> > *** The reason that the client application cannot directly talk with the
> > user object A is that user object A is standard class user object and
> cannot
> > generate Proxy.
> >
> > Method #2:
> > rewrite the calling syntax. For example, if the declaration syntax is:
> > subroutine SAMPLE(string PARM1,ref string PARM2) RPCFUNC ALIAS FOR
> "SAMPLE"
> >
> > Change the declaration syntax to:
> > string ls_parm1,ls_parm2
> > ls_parm1 = 'ABC'
> > DECLARE Sample PROCEDURE FOR SCOTT.SAMPLE (:ls_parm1);
> > execute Sample ;
> > fetch Sample into:ls_parm2;
> > messagebox("ls_parm2",ls_parm2)
> > commit ;
> > close Sample;
> >
> > Regards,
> > Julie
> >
> >
> > "Chuck Kahn" <chuck.kahn@lmco.com> wrote in message
> > news:422db6d8$1@forums-1-dub...
> > > I am trying to implement local external functions in object n_tr.
These
> > > externals are stored procedure calls in Sybase ASE. Unfortunately, it
> is
> > > indicating in Appeon that stored procedure calls as local externals
with
> > the
> > > keyword RPCFUNC are unsupported. What is the workaround?
> > >
> > > Thank you.
> > >
> > > Chuck
> > >
> > >
> >
> >
>
>