Hi,
I'm a first timer on progress and need some help getting array data into SQL Server 2005.
I've got it all connected up as a linked server but need to know the syntax to get the PRO_ELEMENT call out to the Progress DB.
I've tried :
SELECT
{ fn PRO_ELEMENT ( "FLD",1,1) } AS col_val
from ls_prg_uat1..pub.uddetail
This just gives an unknown function error.
Any help would be appreciated.
Pat
I'm a first timer on progress and need some help getting array data into SQL Server 2005.
I've got it all connected up as a linked server but need to know the syntax to get the PRO_ELEMENT call out to the Progress DB.
I've tried :
SELECT
{ fn PRO_ELEMENT ( "FLD",1,1) } AS col_val
from ls_prg_uat1..pub.uddetail
This just gives an unknown function error.
Any help would be appreciated.
Pat