Progress
SQL-92
Guide and Reference


Unsubscripted Array References

When there is a reference to an unsubscripted Progress array column, Progress SQL-92 performs these operations:

This results in dual data types for array fields. The fetch type is TPE_DT_NVARCHAR for the unsubscripted references. The underlying Progress 4GL data type is the native type.

EXAMPLES

The first example assumes a character array named ARRAYCHAR containing three elements in a row in the customer table where the cust_num column is equal to 88, and with values:

ARRAYCHAR[ 1 ] = ’aa’

ARRAYCHAR[ 2 ] = ’bb’

ARRAYCHAR[ 3 ] = ’cc’

The ARRAYCHAR example returns the value ’aa;bb;cc’.

SELECT arraychar FROM customer WHERE cust_num = 88 ; 
 
ARRAYCHAR
 
---------
aa;bb;cc
 
1 record selected 

To retrieve an individual element from an array with any escape characters removed, use the PRO_ELEMENT and PRO_ARR_DESCAPE functions. For example, ARRAYTYPE[ 2 ] contains the value ’aa;bb’. The PRO_ELEMENT function in the ARRAYTYPE example returns ’aa~;bb’ and PRO_ARR_DESCAPE(’aa~;bb’) removes the escape character ( ~ ), returning the element value ’aa;bb’.

select pro_arr_descape(pro_element(arraytype,2,2)) from customer  ;
ARRAYTYPE
 
---------
aa;bb
 
1 record selected 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095