That's right...I forgot the raise() You can either use <1,1,1> and no raise() - TRANS(....) ; @1<1,1,1> Or raise and <1,1> - TRANS(....) ; RAISE(@1) ; @2<1,1>
But if your really need to access data separated by SVM's, you have to use RAISE TRANS(....) ; RAISE(@1) ; @2<1,1,1> Because you can do: TRANS(....) ; @1<1,1,1,1> -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Thompson Sent: Monday, September 12, 2011 4:39 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question The @1<1,1,1> worked. Weird... So the output is not the same as whats in the data? Be nice of them to document that :) On Mon, Sep 12, 2011 at 4:37 PM, Wjhonson <[email protected]> wrote: > > Trans does not retain the marks as there are. > Trans always LOWERs all marks. > So to focus on any particular mark, you should next RAISE the entire > output-so-far. > > > > > > > -----Original Message----- > From: John Thompson <[email protected]> > To: U2 Users List <[email protected]> > Sent: Mon, Sep 12, 2011 1:26 pm > Subject: Re: [U2] I-type Subvalue question > > > No... I think you mean this? > TRANS('PRODUCT', PRD.ID.90, '12', 'V'); @1<1.1> > I also tried with 1,1 and no cigar... > On Mon, Sep 12, 2011 at 4:24 PM, Caryl Lange <[email protected]> wrote: > > 1.1 instead? > > Avante 9.1.7a/SB+ on Windows, tasty GUI flavored > > Best Regards, > Caryl Lange > Applications Development Manager > HME > 14110 Stowe Drive > Poway, California 92064 > phone: (858) 646-8806 > [email protected] > Visit our website: www.hme.com > > Please consider the environment before printing this email > > CONFIDENTIALITY NOTICE: E-mail may contain proprietary confidential > information that is legally privileged. Do not read this e-mail if you are > not the intended recipient. > This e-mail transmission, and any documents, files or previous e-mail > messages attached to it may contain proprietary information, trade > secrets, > and/or other confidential information that is legally privileged. If you > are > not the intended recipient, or a person responsible for delivering it to > the > intended recipient, you are hereby notified that any disclosure, copying, > distribution or use of any of the information contained in or attached to > this transmission is STRICTLY PROHIBITED. If you have received this > transmission in error, please immediately notify the original sender by > return E-mail, and destroy the original transmission and its attachments > without reading or saving in any manner. Thank you. > > > -----Original Message----- > From: [email protected] [mailto: > [email protected]] On Behalf Of John Thompson > Sent: Monday, September 12, 2011 1: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 <[email protected] > >wrote: > > > What happens if you do: > > > > TRANS('PRODUCT',PRD.ID.90,'12','V') ; @1<1,1> > > Mr2 > > Cost > > 10R > > S > > > > > > > > -----Original Message----- > > From: [email protected] [mailto: > > [email protected]] 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 > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > -- > ohn Thompson > ______________________________________________ > 2-Users mailing list > [email protected] > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
