Kbase P119998: How to access an OpenEdge extent / array field without using PRO_ELEMENT
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/11/2007 |
|
Status: Unverified
GOAL:
How to access an OpenEdge extent / array field without using PRO_ELEMENT
GOAL:
How to reference an OpenEdge extent / array field from SQL-92
GOAL:
How to use index referencing for SQL-92 extent / array fields
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
FIX:
Starting in Open Edge 10.1A, you can now reference extent/array fields with an index.
For example, the following statement uses index referencing for the extent field monthquota which exists in the salesrep table of the sports2000 database:
Statement:
SQLExplorer>SELECT monthquota[1] FROM PUB.salesrep;
RESULT:
MonthQuota[1]
-------------
1600
1800
3800
1600
3800
2200
1800
4200
3000
Previously to 10.1A, the PRO_ELEMENT function was needed to access array / extent fields.