Yeesh. Its funny how the manual states, "I-types are very similar to BASIC"
Hmmm....
Thanks for the info.
On Mon, Sep 12, 2011 at 4:44 PM, George Gallen <ggal...@wyanokegroup.com>wrote:
> Meant to say you can't do @1<1,1,1,1>
>
> -----Original Message-----
> From: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Monday, September 12, 2011 4:43 PM
> To: U2 Users List
> Subject: 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>
> 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: u2-users-boun...@listserver.u2ug.org [mailto:
> u2-users-boun...@listserver.u2ug.org] 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 <wjhon...@aol.com> 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 <jthompson...@gmail.com>
> > To: U2 Users List <u2-users@listserver.u2ug.org>
> > 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 <cla...@hme.com> 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
> > cla...@hme.com
> > 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: u2-users-boun...@listserver.u2ug.org [mailto:
> > u2-users-boun...@listserver.u2ug.org] 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 <
> 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
> >
> >
> > --
> > ohn Thompson
> > ______________________________________________
> > 2-Users mailing list
> > 2-us...@listserver.u2ug.org
> > ttp://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
> _______________________________________________
> 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
