One thing you might want to do is use
RAISE(TRANS('filename',field,field,'X')) The reason for this is that
when you use a file translate in an I-Descriptor, it drops fields to
multi-values, multi-value to sub-values etc...
Thanks,
Nick Cipollina
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kathy Tymoczko
Sent: Friday, October 14, 2005 11:42 AM
To: [email protected]
Subject: [U2] [UD] UniQuery virtual field question
I'm trying to make an i-descriptor that does the following: From a
multi-valued field, TRANS to another multi-valued field in a second
file,
and return just the first subvalue of that field for each record pointed
to
by the second field.
In the FILE1, I have a multi-valued field that is a list of pointers to
the
FILE2. And in that file is a multi-valued list of IDs. I only want the
first one of those. So that instead of a list that looks like:
FILE1 ID FILE2 IDS IDS
1234557 12345 0123456
0748923
13467 0003456
13578 0034569
0143434
I would have a list that looks like:
FILE1 ID FILE2 IDS IDS
1234557 12345 0123456
13467 0003456
13578 0034569
I've read the entire chaper on virtual fields in the "Using Unidata"
manual, but nothing I've tried (FIELD, SUBR('-FIELDS'), EXTRACT among
other
things) has worked.
Any suggestions would be greatly appreciated.
Kathy Tymoczko
Information Technology Services
Wabash College, Crawfordsville, Indiana 47933
[EMAIL PROTECTED] 765-361-6440
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
