Hi Volker,

When viewing the parameter list from Sybase Central on the remote function no parameters were showing.

I have since discovered that no parameters were added when creating the remote function from DB2. So I have added them via the alter procedure statement such as:

Alter procedure fnMyFunct(in @Parm1 varchar(5)....) at 'RemoteServer;;DBA;;fnMyFunct'

Now works.

Why doesn't the call/select of the remote procedure return any results.

My function returns a smallint either 0 or 1 to indicate whether the function was successful or not.

When I use: select fnMyFunct('Blah','Blah'...) as Result I always get 0 returned, even when it was supposed to return 1

Hi Volker,

Yes sorry am using remote functions.

Code: Here is the function in DB1

CREATE FUNCTION "DBA"."fnAddNewTherapistToTelemed"( in @TherapistCode varchar(5),in @Surname varchar(50),in @FirstName varchar(50),in @AddressLine1 varchar(50),in @AddressLine2 varchar(50),in @Suburb varchar(30),in @State varchar(3),in @Zip varchar(4),in @WorkPhoneNo varchar(30),in @MobilePhoneNo varchar(30),in @FaxNumber varchar(30),in @EmailAddress varchar(50) ) 
returns smallint
NOT DETERMINISTIC
begin
  /* Type the procedure statements here */
  ... code removed for simplicity
END

Here is the code for remote server and remote function in DB2

CREATE SERVER "TelemedParticipants" CLASS 'SAODBC' USING 'D12_64';
DROP PROCEDURE "DBA"."fnAddNewTherapistToTelemed";
CREATE PROCEDURE "DBA"."fnAddNewTherapistToTelemed"(in @TherapistCode varchar(5), in @Surname varchar(50),in @FirstName varchar(50),in @AddressLine1 varchar(50),in @AddressLine2 varchar(50),in @Suburb varchar(30),in @State varchar(3),in @Zip varchar(4),in @WorkPhoneNo varchar(30),in @MobilePhoneNo varchar(30),in @FaxNumber varchar(30),in @EmailAddress varchar(50))
at 'TelemedParticipants;;DBA;fnAddNewTherapistToTelemed';

Calling SQL from within a trigger in DB2

set nParticipantCreated = (select dba.fnAddNewTherapistToTelemed(n.TherapistCode,n.Surname,n.GivenName,n.AddressLine1,n.AddressLine2,n.Suburb,n.State,n.PostCode,n.PhoneNo,n.MobileNo,n.FaxNo,n.EmailAddress));

Regards