Wednesday, March 7, 2012

Function call to Progress linked server

I have a Progress DB set up as a linked server.

To get the data through to SQL Server 2005 in a useable format i need to use the progress PRO_ELEMENT function call. How do I delimit this so it gets passed to the progress DB.

I've tried

SELECT

{fn PRO_ELEMENT(fldarr1,1,1)} as fld1

from ls1..pub.tab

This just returns an unknown function message which I believe is on the SQL Server end of the call.

This statement works fine through Business Objects.

Any help greatfully received.

try using OPENQUERY function.

select * from openquery (lnkd_server, 'SELECT {fn PRO_ELEMENT(fldarr1,1,1)} as fld1 from ls1..pub.tab')

No comments:

Post a Comment