I have a simple Function on my database:
RETURNS VARCHAR(32767) BEGIN RETURN 'Bill Aumen test'; END;`
When I execute
I have created a Remote Server and Function:
When I execute in ISQL from the remote database:
It all seems so simple, I must be missing something basic.
asked 21 Sep '16, 19:03
The documentation is a little bit unclear about VARCHAR returns: Remote Procedure Calls.
answered 22 Sep '16, 04:24
This is a bug in the software and is now corrected. The fix will appear in 18.104.22.1682 and 22.214.171.1247 or later versions. Thanks for reporting the problem.
answered 27 Sep '16, 12:03
WOW! I am surprised at the lack of capability! Returning CHAR(255) still didn't work. But returning INT did.
So I guess I will make remote tables on the remote server, and run the actual function there.
answered 22 Sep '16, 11:44