Shan is CUSTOMER.PHONE.NUMBER an associated MV?  If you have an association
with a field like CUSTOMER.PHONE.TYPE and you want just the FAX numbers then
you can use the WITH keyword in your query like:


David A. Green
(480) 201-7953
DAG Consulting

-----Original Message-----
[] On Behalf Of Shanmukh Nandha
Sent: Thursday, December 26, 2013 11:26 PM
Subject: [U2] Regarding: LISTING SUB-VALUES

Hi Everyone,

Always a pleasure to read the useful advice and varying personalities on
this list.

Generally we are using SB+ account.  There will be many multi-value field
available in files, How to list specific Multi values of a field in specific
file .

For example:-

CUSTOMER FILE contains fields like
1. CUSTOMER.NAME <>  (single value) 2. CUSTOMER.SALARY
(single value) 3.CUSTOMER.PHONE.NUMBER (multi value)

1. JOHN (Cust name with single value)
2. 70$/hr (Cust salary with single value) 3. 123454ý 655656ý 767787ý 87887
(Cust Ph No with Multi value)

General to list specific field we use LIST CUSTOMER F3.

How to list 3rd position of 3rd field of CUSTOMER file.

Could any one of you can please let me know

Thank you,
U2-Users mailing list

U2-Users mailing list

Reply via email to