stserver.u2ug.org
Subject
[U2] [UV] I descriptor help
10/02/2007 03:11
@listserver.u2ug.org
Subject: [U2] [UV] I descriptor help
I need to call a basic subroutine to process a field. The field in the
record is a multivalued field. How do I pass that field to the called
subroutine ?
The field is PARTNO which is defined as a MV field. I want to call a
subroutine such as SUBR
]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Friday, February 03, 2006 8:07 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV I-descriptor
OK... so in a few months I'll be 50+ so I will be the OLD
'FNG', with still
a lot to learn.
I did keep Ron P's solution and I
Chuck,
Thanks for extending the usefulness of that i-descr. I tend to
favor i-descr's without @n references so that they can be used as a
reference in another i-descr. The @n references and semicolons sure
make it more readable, but you are then limited to replicating the logic
in
Hi Peoples,
I've got a question on coding an I-descriptor in a UV-Pick account.
From file1 with a key of CO*PRODNO*WHS*UOM, I need to pull from file2 a
conversion value. File2's key is PRODNO with a multi-valued field of
UOM and an associated field of CONV.VAL. My problem comes in that
LOCATE
If you need the functionality of LOCATE, you need to call a subroutine,
period.
My own solution years ago was to write a generic LOCATESUB subroutine to
be called from I-descriptors.
In retrospect, I am not so sure that was a good idea because it is
complicated enough that I never remember it
:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UV I-descriptor
Hi Peoples,
I've got a question on coding an I-descriptor in a UV-Pick account.
From file1 with a key of CO*PRODNO*WHS*UOM, I need to pull from file2 a
conversion value. File2's key is PRODNO with a multi-valued
-users@listserver.u2ug.org
Subject: [U2] UV I-descriptor
Hi Peoples,
snip
FILE1 @ID = 01*11223344*W1*EA
FILE2 @ID = 11223344
5 = CS^SP^EA
9 = 1^2^12
I'm needing to get 12 back to the I-DESC in FILE1, again, hopefully
without having to resort to a called basic program.
---
u2
Bob,
Went brain dead on the 5 and 9 in your FILE2. The corrected
I-descr should read:
0001 I
0002
SUM(MULS(EQS(RAISE(TRANS(FILE2,OCONV(@ID,G1*1),5,X)),REUSE(OCONV(@
ID,G3*1))),RAISE(TRANS(FILE2,OCONV(@ID,G1*1),9,X
0003
0004
0005 10L
0006 M
--Ron P.
---
u2-users mailing list
There's just one problem with your attempt. You must remember that a
TRANS in UV will lower the delimiters. So if the field in the remote file
is value mark delimited, it will be sub-value mark delimited once TRANSed.
You're still an FNG it looks to me. (tic)
Gordon J. Glorfield
Sr.
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, February 03, 2006 1:55 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV I-descriptor
Finally a question I can answer. Oh boy I am not a newbie anymore.
File1 dictionary item:
Field(TRANS(FILE2
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron
Sent: Friday, February 03, 2006 2:27 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV I-descriptor - slight correction
Bob,
Went brain dead on the 5 and 9 in your FILE2. The corrected
I-descr should read:
0001
:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Saturday, 4 February 2006 11:31 a.m.
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV I-descriptor
Finally a question I can answer. Oh boy I am not a newbie anymore.
File1 dictionary item:
Field(TRANS(FILE2,FIELD(@ID,'*',2),9,'X
@listserver.u2ug.org
Subject: RE: [U2] UV I-descriptor
There's just one problem with your attempt. You must remember that a
TRANS in UV will lower the delimiters. So if the field in the remote file
is value mark delimited, it will be sub-value mark delimited once TRANSed.
You're still an FNG
: RE: [U2] UV I-descriptor
You're so close, Gary, but the catch is setting the value 3 in the
tail end of your FIELD function. The UOM will change from record to
record in FILE1. That's what I need the LOCATE function for.
I do grant your elevation from newbie status, though. smile
solutions.
-Original Message-
From: phil walker [SMTP:[EMAIL PROTECTED]
Sent: Friday, February 03, 2006 3:03 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV I-descriptor
Garry,
Sorry to burst your bubble ;-). But I don't think he was looking for a
hardcoded answer
From: Louie Bergsagel
Ron Pingilley's solution works, with his posted correction to
plug in fields 5 and 9.
Ron's method does indeed work. Nice work, Ron!
Now let's generalize it a bit. Suppose the final answer is a string
instead of numeric.
You can replace the outer
02: SUM(MULS(...))
, February 03, 2006 5:26 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV I-descriptor
From: Louie Bergsagel
Ron Pingilley's solution works, with his posted correction to
plug in fields 5 and 9.
Ron's method does indeed work. Nice work, Ron!
Now let's generalize it a bit. Suppose
18 matches
Mail list logo