Kbase P15618: How to work with extents fields using SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/08/2009 |
|
Status: Verified
GOAL:
How to work with extents fields using SQL-92
FACT(s) (Environment):
Progress 9.x
FIX:
Array fields are created using the Progress 4GL Dictionary. In Progress 9.x the SQL-92 engine manages the arrays as NVARCHAR string, and the string representation is the concatenation of each array element with a semicolon (;) separating each element.
The Progress SQL-92 engine provides three functions to handle the array fields: PRO_ELEMENT, PRO_ARR_ESCAPE, PRO_ARR_DESCAPE.
To access an array field, use the pro_element function as in the following example statement which accesses element 1 of the extent field monthquota from sports2000 database:
SELECT pro_element(monthquota,1,1) from pub.salesrep