Pro_Element

[harms]

I am connecting a Progress Openedge db (10.1B) to a SQL 2005 db (using ODBC and SSIS) and am having problems extracting a progress extent field with hyphens in the field name. i.e. (CL-ANALYSIS-CODE-ELEMENT). Note I can extract another extent field without hyphens in it, however as soon as it has hypens, it errors out.

I have tried using PRO_Element, see below and this will parse, however it simply inserts nulls.

SELECT {fn PRO_ELEMENT ("CL-ANALYSIS-CODE-ELEMENT",1,1) } AS Element1
from ih.pub."rm-job"

Any help, would be much appreciated.

Matt

 

[Casper]

I think you can also use
select "CL-ANALYSIS-CODE-ELEMENT"[1] from tbl;

In 10.1B on sports for example:

SQLExplorer>select "month-quota"[1] from pub.salesrep;
Month-Quota[1]
--------------
1600
1800
3800
1600
3800
2200
1800
4200
3000

Casper.

 

[harms]

Hi Casper

Thanks so much for this, it worked like a dream.

Here is my final WORKING code.....

select "cl-analysis-code-element"[1] as cl1,
"cl-analysis-code-element"[3] as cl3,
"cl-analysis-code-element"[4] as cl4
from ih.pub."rm-job"
where "job-no" > 'G000000'


Excellent result, you are the main man..

Thanks again

Matt