Kbase P126169: How to retrieve Array Fields in SQL-92 using OpenEdge 10.1A or higher?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/9/2009 |
|
Status: Verified
GOAL:
How to retrieve Array Fields in SQL-92 using OpenEdge 10.1A or higher?
GOAL:
How to use Array Elements in SQL-92 using OpenEdge 10.1A or higher?
GOAL:
How to retrieve Array Elements in SQL-92 with OpenEdge 10.1A or higher?
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
FIX:
For accessing array elements from SQL, as of OpenEdge 10.1A, queries can use array notation in SQL, as defined in the SQL:1999 standard.
This is really just like array references in the ABL:
SELECT my_array[1], my_array[32], .... FROM pub.my_table ....
Array references like this retrieve the data in its native OpenEdge data type, and do not convert it to character data type.
This will handle the Null values much better than using pro_element().
pro_element() still works in 10.1A or higher.