Just curious....try changing the @<1,1> to @<1,1,1> If so, then the values are separated by @VM's but rather @SVM's
George -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, September 12, 2011 4:23 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question I get this still... DOR 610-434 0.78 0.00 0.00 0.00 0.53 That is a number 1 in the @1 right? On Mon, Sep 12, 2011 at 4:18 PM, George Gallen <ggal...@wyanokegroup.com>wrote: > What happens if you do: > > TRANS('PRODUCT',PRD.ID.90,'12','V') ; @1<1,1> > Mr2 > Cost > 10R > S > > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Monday, September 12, 2011 4:11 PM > To: U2 Users List > Subject: [U2] I-type Subvalue question > > Lets say I need to translate over to a file and get the cost of a product. > > However, the cost of the product is multivalued. > > How can I do this with an I-type and NOT grab all of the multi values? > > I > TRANS('PRODUCT', PRD.ID.90, '12', 'V') > MR2 > Cost > 10R > S > > So in attribute 12 of the PRODUCT file, I just need <12,1>. > > Do I need two I-types, or will TRANS() let me do this? > > The friendly manual seems to be failing me... > > -- > John Thompson > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users