George another trick to add to your bag of tricks You *can* actually access this level of delim. It's called the @TM, which you can access in an I-desc; but you are right you cannot access 1,1,1,1 as such what you have to do is use the FIELD command on @TM as the delim
Or you could Raise and then specify this locational directive. -----Original Message----- From: George Gallen <[email protected]> To: U2 Users List <[email protected]> Sent: Mon, Sep 12, 2011 1:44 pm Subject: Re: [U2] I-type Subvalue question Meant to say you can't do @1<1,1,1,1> -----Original Message----- rom: [email protected] [mailto:[email protected]] n Behalf Of George Gallen ent: Monday, September 12, 2011 4:43 PM o: U2 Users List ubject: Re: [U2] I-type Subvalue question That's right...I forgot the raise() You can either use <1,1,1> and no raise() - TRANS(....) ; @1<1,1,1> r 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----- rom: [email protected] [mailto:[email protected]] n Behalf Of John Thompson ent: Monday, September 12, 2011 4:39 PM o: U2 Users List ubject: 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 -- ohn Thompson ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 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
