RE: [U2] UV I-descriptor
Thanks for all the help, folks! It solves my problem quite well and
lets me document it in one place.
"These things almost fly themselves."
As always, you all super!
BobW
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Friday, 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 the final answer is a string
instead of numeric.
You can replace the outer
02: SUM(MULS(...))
with
o2: CONVERT(@VM,'',IFS(...,'')
as follows:
02:CONVERT(@VM,'',IFS(EQS(RAISE(TRANS("FILE2",OCONV(@ID,"G1*1"),5,"X")),
REUSE(OCONV(@ID,"G3*1"))),RAISE(TRANS("FILE2",OCONV(@ID,
"G1*1"),9,"X")),''))
or equivalently:
02:
@ID['*',4,1];TRANS(FILE2,@ID['*',2,1],-1,'X');EQS(@2<1,5>,REUSE(@1));IFS
(@,@2<1,9>,'');CONVERT(@SM,'',@)
depending on taste/standards manual.
Of course, we're still left with the problem of maintainability.
Chuck Stevenson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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 the final answer is a string
instead of numeric.
You can replace the outer
02: SUM(MULS(...))
with
o2: CONVERT(@VM,'',IFS(...,'')
as follows:
02:CONVERT(@VM,'',IFS(EQS(RAISE(TRANS("FILE2",OCONV(@ID,"G1*1"),5,"X")),
REUSE(OCONV(@ID,"G3*1"))),RAISE(TRANS("FILE2",OCONV(@ID,
"G1*1"),9,"X")),''))
or equivalently:
02:
@ID['*',4,1];TRANS(FILE2,@ID['*',2,1],-1,'X');EQS(@2<1,5>,REUSE(@1));IFS
(@,@2<1,9>,'');CONVERT(@SM,'',@)
depending on taste/standards manual.
Of course, we're still left with the problem of maintainability.
Chuck Stevenson
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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 will try it out on some of our files where
we have a G/L# in Field 2 and the dollar amount in Field 3.
That's why I love this users group postings. Always some great 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. Your solution would work for the example he gave but I
> am sure he wants a more generic solution which would 'locate' the value
> of the 4th '*' delimited field in the FILE 1 @ID in field 5 of the FILE
> 2 record and then return the value from the corresponding position in
> field 9.
>
> Cheers,
>
> Phil
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[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'),VM,3)
>
> so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
> element and then the 3rd position value.
>
>
> *
> Learning Universe for me as a newbie was challenging but the most
> difficult part of my job is trying to decipher the application design,
> since we are not provided with any technical documentation. Or our
> software vendor just does not have any good documentation and relies on
> a few "core" old timers to make changes and provide an oral history of
> the design. Questions like how is an AP Check disbursement
> tracked/indexed back to the Vendor Invoice go un-answered. So we have a
> TEST account where we reverse engineer the code.
>
> > -Original Message-
> > From: Bob Woodward [SMTP:[EMAIL PROTECTED]
> > Sent: Friday, February 03, 2006 12: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 field
> > of UOM and an associated field of CONV.VAL. My problem comes in that
> > LOCATE is not valid in an I-DESC formula.
> >
> > I know I can make a basic program and call it but I prefer to have
> > this totally self contained within the DICT entry. Example data is:
> >
> > 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.
> >
> > TIA
> >
> > BobW
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor
Thanks for the promotion BOB... Gordon still thinks I just an FNG ... woww... MAMSI must have cut-back on the NICE pills.(sha-zam). > -Original Message- > From: Bob Woodward [SMTP:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 2:49 PM > To: u2-users@listserver.u2ug.org > Subject: 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. > > BobW > > > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor
Well maybe that explains why the designers of our application have made
pervasive use of the TILDE (~) to delimit many of their data elements. (toc)
> -Original Message-
> From: Gordon J Glorfield [SMTP:[EMAIL PROTECTED]
> Sent: Friday, February 03, 2006 2:43 PM
> To: u2-users@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 it looks to me. (tic)
>
>
> Gordon J. Glorfield
> Sr. Applications Developer
> MAMSI (A UnitedHealth Company)
> 301-360-8839
>
> [EMAIL PROTECTED] wrote on 02/03/2006 04:54:51 PM:
>
> > 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'),VM,3)
>
> > so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
> > element and then the 3rd position value.
>
> [snip]
>
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity to
> which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] Jeremy Woods/WA/QBE/Insurance is out of the office.
I will be out of the office starting 03/02/2006 and will not return until 14/02/2006. I will respond to your message when I return. IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. If you are not the intended recipient, any use or dissemination of the information and any disclosure or copying of this email is unauthorised and strictly prohibited. If you have received this email in error, please promptly inform us by reply email or telephone. You should also delete this email and destroy any hard copies produced. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV I-descriptor
Ron Pingilley's solution works, with his posted correction to plug in fields
5 and 9.
On 2/3/06, phil walker <[EMAIL PROTECTED]> wrote:
>
> Garry,
>
> Sorry to burst your bubble ;-). But I don't think he was looking for a
> hardcoded answer. Your solution would work for the example he gave but I
> am sure he wants a more generic solution which would 'locate' the value
> of the 4th '*' delimited field in the FILE 1 @ID in field 5 of the FILE
> 2 record and then return the value from the corresponding position in
> field 9.
>
> Cheers,
>
> Phil
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[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'),VM,3)
>
> so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
> element and then the 3rd position value.
>
>
> *
> Learning Universe for me as a newbie was challenging but the most
> difficult part of my job is trying to decipher the application design,
> since we are not provided with any technical documentation. Or our
> software vendor just does not have any good documentation and relies on
> a few "core" old timers to make changes and provide an oral history of
> the design. Questions like how is an AP Check disbursement
> tracked/indexed back to the Vendor Invoice go un-answered. So we have a
> TEST account where we reverse engineer the code.
>
> > -Original Message-
> > From: Bob Woodward [SMTP:[EMAIL PROTECTED]
> > Sent: Friday, February 03, 2006 12: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 field
> > of UOM and an associated field of CONV.VAL. My problem comes in that
> > LOCATE is not valid in an I-DESC formula.
> >
> > I know I can make a basic program and call it but I prefer to have
> > this totally self contained within the DICT entry. Example data is:
> >
> > 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.
> >
> > TIA
> >
> > BobW
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor - slight correction
Thanks Ron,
This looks to be close to what I need. I'll have to see if I can fit
this into my needs. You're right about maintainability but the trade
off is I don't have to worry about a detached subroutine getting changed
to generalize it for reuse. There's something to be said for specific
use programming in a non-OOP environment.
Charles' comments are good, too, and I've told myself much of what he
said. I really want to avoid the subroutine method, though,
specifically to force a single use of the function. The choice of a
bunch of very small, specific use, subroutines verses a general purpose
subroutine is always a dilemma. In this case, I'm wanting to avoid the
general purpose option. While waiting for replies, I went ahead and did
the subroutine but that's only if we're not able to come up with an
I-DESC only solution.
BobW
-Original Message-
From: [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 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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor
Garry,
Sorry to burst your bubble ;-). But I don't think he was looking for a
hardcoded answer. Your solution would work for the example he gave but I
am sure he wants a more generic solution which would 'locate' the value
of the 4th '*' delimited field in the FILE 1 @ID in field 5 of the FILE
2 record and then return the value from the corresponding position in
field 9.
Cheers,
Phil
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[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'),VM,3)
so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
element and then the 3rd position value.
*
Learning Universe for me as a newbie was challenging but the most
difficult part of my job is trying to decipher the application design,
since we are not provided with any technical documentation. Or our
software vendor just does not have any good documentation and relies on
a few "core" old timers to make changes and provide an oral history of
the design. Questions like how is an AP Check disbursement
tracked/indexed back to the Vendor Invoice go un-answered. So we have a
TEST account where we reverse engineer the code.
> -Original Message-
> From: Bob Woodward [SMTP:[EMAIL PROTECTED]
> Sent: Friday, February 03, 2006 12: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 field
> of UOM and an associated field of CONV.VAL. My problem comes in that
> LOCATE is not valid in an I-DESC formula.
>
> I know I can make a basic program and call it but I prefer to have
> this totally self contained within the DICT entry. Example data is:
>
> 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.
>
> TIA
>
> BobW
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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.
BobW
-Original Message-
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",FIELD(@ID,'*',2),9,'X'),VM,3)
so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
element and then the 3rd position value.
*
Learning Universe for me as a newbie was challenging but the most
difficult
part of my job is trying to decipher the application design, since we
are
not provided with any technical documentation. Or our software vendor
just
does not have any good documentation and relies on a few "core" old
timers
to make changes and provide an oral history of the design. Questions
like
how is an AP Check disbursement tracked/indexed back to the Vendor
Invoice
go un-answered. So we have a TEST account where we reverse engineer the
code.
> -Original Message-
> From: Bob Woodward [SMTP:[EMAIL PROTECTED]
> Sent: Friday, February 03, 2006 12: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 field of
> UOM and an associated field of CONV.VAL. My problem comes in that
> LOCATE is not valid in an I-DESC formula.
>
> I know I can make a basic program and call it but I prefer to have
this
> totally self contained within the DICT entry. Example data is:
>
> 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.
>
> TIA
>
> BobW
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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 it looks to me. (tic)
Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839
[EMAIL PROTECTED] wrote on 02/03/2006 04:54:51 PM:
> 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'),VM,3)
> so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
> element and then the 3rd position value.
[snip]
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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 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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor
Bob,
Hey, that was fun! I got this one to work:
U2UG.TEST
0001 I
0002
SUM(MULS(EQS(RAISE(TRANS("FILE2",OCONV(@ID,"G1*1"),1,"X")),REUSE(OCONV(@
ID,"G3*1"))),RAISE(TRANS("FILE2",OCONV(@ID,"G1*1"),2,"X"
0003
0004
0005 10L
0006 M
It gets <1> from file2, using "G1*1" of the key from file 1,
compares the multivalues to "G3*1" of the file1 key, which results in a
MV'd list of 0 and 1, with the only "1" corresponding to the MV in
file2<1> that matches. Then gets <2> from file2, and MULS them
together, and sums the results. What you get is 1 * the matching
qty-per-uom value from file2.
Give it a whirl, and see if it works for you. It's pretty nasty
to modify, so a program may be a better solution in the end
--Ron Pingilley
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Friday, February 03, 2006 2:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] UV I-descriptor
Hi Peoples,
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-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
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'),VM,3)
so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
element and then the 3rd position value.
*
Learning Universe for me as a newbie was challenging but the most difficult
part of my job is trying to decipher the application design, since we are
not provided with any technical documentation. Or our software vendor just
does not have any good documentation and relies on a few "core" old timers
to make changes and provide an oral history of the design. Questions like
how is an AP Check disbursement tracked/indexed back to the Vendor Invoice
go un-answered. So we have a TEST account where we reverse engineer the
code.
> -Original Message-
> From: Bob Woodward [SMTP:[EMAIL PROTECTED]
> Sent: Friday, February 03, 2006 12: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 field of
> UOM and an associated field of CONV.VAL. My problem comes in that
> LOCATE is not valid in an I-DESC formula.
>
> I know I can make a basic program and call it but I prefer to have this
> totally self contained within the DICT entry. Example data is:
>
> 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.
>
> TIA
>
> BobW
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV I-descriptor
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 exactly and end up looking it up. I have done several i-desc utility subroutines like that, but LOCATESUB is the one I am unhappy about. Using my subroutine, I'd end up with some variation on this theme: 01: I 02: RAISE( TRANS(FILE2,@ID['*',1,1], -1, 'X' )); SUBR( '*LOCATESUB',@ID['*',4,1],@1,4,1,0,''); IF @ > 0 THEN @1<9,@> ELSE '?' Of course, that's all on line 2. TRANS arg3 = -1 means return the entire argument. TRANS lowers all delimiters, so RAISE bumps them back up again. Instead of RAISE, I could have just located on subval level. LOCATESUB has arguments for att, val, subval, & locate-by; LOCATESUB returns a negative number if, internally, its locate takes the else clause. Hence, the IF @>0 test. ( Everyone knows that @ID['*',4,1] == FIELD( @ID, '*', 4, 1 ) == FIELD(@ID,'*',4) , right? ) So is LOCATESUB general utility worth it? If so, you can have it. If not, a specific subroutine for this I-descriptor is in order. It might be more maintainable. Chas. Stevenson > From: Bob Woodward [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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[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 field of UOM and an associated field of CONV.VAL. My problem comes in that LOCATE is not valid in an I-DESC formula. I know I can make a basic program and call it but I prefer to have this totally self contained within the DICT entry. Example data is: 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. TIA BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: XML Issue
Thanks for your help. I'm not opening it with any editor. I do the HTTP Call to the URL the vendor gives me. When I look at the "RESPDATA" (response data) just with a CRT during the download, that's when I see the structure I'm referring to. (I have to remove the 'standalone' or remove the heading entirely in order for the xdom parser to even receive it.) I remove line feeds after the XDOM parser has done it's thing before I write to my U2 file. What was throwing me was that I suddenly had to add the extra steps of altering the heading and removing line feeds. I've downloaded so many xml docs (and I do this all directly through UniBasic using the extentions) that I got used to seeing it a certain way. Another difference I noted in the URL response header that worked w/o the extra steps is content type text/xml and on the new URL it's shown as content type text/html. I can make it work. It just worries me that I don't know exactly why I needed to blank out the header and manage line feeds.. thanks again, Nancy From: spotless.com.au> Subject: RE: [U2] Re: XML Issue Newsgroups: gmane.comp.db.u2.general Date: 2006-02-03 00:00:14 GMT (18 hours and 57 minutes ago) Nancy, I am presuming that you are opening the document using a text editor and then saving it to an operating system file, not a U2 file?? XML is `structure' agnostic. The layout of an XML document when opened in a text editor (for example) is unaffected by the encoding of the document. What you are seeing is probably just the difference in how the line feeds are represented in your text editor. If you need to manipulate the XML before writing it, use a specific XML editor like XMLSpy. Otherwise a text editor like EditPlus can figure out your linefeeds and is also excellent for dealing with XML. If you want to view the document with `pretty' layout, open the document with a web browser (Firefox, Internet Explorer etc). Cheers, Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Index at infocus
Thanks, that helps. At 11:28 AM 2/3/2006, you wrote: There are archives here, though I don't think they go back as far as Infocus: http://www.mail-archive.com/u2-users%40listserver.u2ug.org/ Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Index at infocus
On 2/3/06, Doug Miller <[EMAIL PROTECTED]> wrote: > Funny because I was just going to post about this as well. Have not > used it in quite a while and wouldn't you know it, when I wanted it, > it was down. There are archives here, though I don't think they go back as far as Infocus: http://www.mail-archive.com/u2-users%40listserver.u2ug.org/ -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Calendar and Contacts (UV)
Hi Tom, Contacts and Calendaring capabilities can take many forms. We have a Contacts Management/Marketing module that is part of our manufacturing and distribution software, which, like our EDI module, can be installed separately and integrated with any backend software. It manages Contacts, which can include current customers, schedules telephone calls and callbacks, adjusted for time zone differences, and stores critical information gathered during each call from which sales forecasts can be developed. Actions to be taken in conjunction with any Contact can be scheduled by date and time and assigned to any responsible party(s), including preparing something, attending some meeting or taking any action you wish to define. Schedules of assigned activities can then be reviewed/published by action, by date/time, by responsible party, etc. for calendaring purposes. The Contacts Management/Marketing module is currently running on A/P, has been migrated to mvBase and is in the process, along with the rest of our software, of being migrated to Universe. If this general framework, with our without modifications, might fit you needs, please contact me. I'll be glad to discuss your needs further with you and setup a demo. Rgds, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: "Tom Dodds" <[EMAIL PROTECTED]> To: "User group U2" Sent: Thursday, February 02, 2006 7:33 AM Subject: [U2] Calendar and Contacts (UV) > Does anyone know of a good set of tools for UniVerse that has integrated > Contacts and Calendaring capabilities. We would prefer the tools to be > written in Basic with no need for outside routines. We are running UV > 10.1.17 on AIX 5.2.3 > > > > Thanks for the help. > > > > Tom Dodds > > [EMAIL PROTECTED] > > 708-234-9608 Office > > 630-235-2975 Cell > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Index at infocus
Funny because I was just going to post about this as well. Have not used it in quite a while and wouldn't you know it, when I wanted it, it was down. Thanks for your efforts Lee. At 08:59 AM 2/3/2006, you wrote: Apologies -- the server is completely down and in the process of being reconstructed -- fedora 4, apache 2.2 ... Expect to be back up into next week. Lee Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Universe and SQL Server
Thanks for all of the suggestions. I was a little off in what it is that we want to do with this, but all of your suggestions were very helpful. What they really wanted was a way to compare data in SQL Server and UV. So we are probably going to write a .NET app that sits in the middle and pulls the data from both sides into datasets and compares them for differences. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Tod Sigafoos Sent: Friday, February 03, 2006 10:14 AM To: Nick Cipollina Subject: Re: [U2][UV] Universe and SQL Server Nick, Thursday, February 2, 2006, 1:41:23 PM, you wrote: NC> Hello all, NC> We are currently looking into ways to share our data between NC> universe and SQL Server, and I am trying to get some suggestions NC> on the best way to do this. We are currently generating text NC> files in UV and ftp'ing those files to a designated location. We NC> have a task scheduler that picks up the files when they arrive and NC> inserts them into SQL server. I know there are ways to NC> communicate directly between SQL server and Universe and I am NC> looking for the best way to do this. It doesn't matter if NC> Universe reaches out to SQL Server or vice versa. Thanks. I think you will find the BCI client of Universe to be very good at the communication to SqlServer. Last year I worked with a client who needed the same type of communication. We developed a couple of routines they could use to 'read/write' SqlServer with minimal interference with the Universe developers. It turned out faily well .. quick and error free. There really is no need to go to any 'external middleware' answer when all the tools are right there. It lowers maintenance as your developers don't need to learn anything new (although that IS always fun). Give it a try .. ask questions here. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ 'Politics is like driving. To go backward, put it in R. To go forward, put it in D' unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Ref: [U2][UV] Universe and SQL Server
Nick, If your using Windows as the OS then just use BCI. It come's with UV for free. We use it here and it work's great. In addition I would also create a UV trigger to work with your BCI call(s). Rudy Date: Thu, 2 Feb 2006 16:41:23 -0500 From: "Nick Cipollina" <[EMAIL PROTECTED]> Subject: [U2][UV] Universe and SQL Server <> Rudy Cooper Information Technology Project Technical Lead Sage Publications 2455 Teller Road Thousand Oaks, California 91320 Direct (805) 410-7724 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] XML Newbie with Unidata
At 08:26 -0500 2006/02/03, Jeffrey Butera wrote:
For the sake of simplicity, we can assume all data fields in the
Unidata file are single valued, so the XML structure is very simple
- no nested fields, save the outermost ROOT and record tags. The
only wrinkle is that the XML field names don't match the Unidata
DICT, so I know I'll have to have a mapping.
I need some advice on how to proceed.
A real simple solution is to make a text template of the root XML
tags and one for the individual record tags. Just include "place
holders" for the data from your file. Then, read-up each record to
be exported, use CHANGE() to replace the placeholders with the
appropriate field data, accumulate a long string of the record XML
and then finally stuff that into the main XML template.
Your record template would look something like:
{LAST.NAME}
...
and then in the code, you'd CHANGE() '[EMAIL PROTECTED]' and '{LAST.NAME}' to the
real @ID and the value in the LAST.NAME field.
On the inbound, just strip all excess whitespace and line breaks,
convert '><', '>' and '<' to '>@FM<', '>@FM', '@FM<' (respectively,
and do '><' first) and then use a LOOP...REMOVE...REPEAT to step
through the data to build your records.
Let me know if you need some code snippetts.
I've also seen people make custom DICT entries so that they could
just do a LIST/SORT and grab the XML via an EXECUTE ... CAPTURING.
Works fine on the outbound, but won't help any on the inbound.
Ray
--
.=.
| =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= |
| -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- |
| |
|Midwest Regional Office: 815-547-0662 (voice) 815-547-0353 (Fax)|
.=.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata/XML Newbie
Hello Jeff Don't know if this will help or not. But you mentioned "The only wrinkle in this is that the XML field names will not match the DICT field names" I've been doing some work with UniData's XML via UniObjects. I've found you can override the names assigned in the XML result by using the COL.HDG modifier. So something like LIST FILENAME FIELDNAME COL.HDG "MY FIELD NAME" TOXML ELEMENTS ... Will give you control over the names in the resulting XML. Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:03 PM To: u2-users@listserver.u2ug.org Subject:[U2] Unidata/XML Newbie I have a need to export a Unidata (6.1.4) file as XML and later populate data in the file from an XML document. For the sake of simplicity, let's assume that every field is single valued at the moment so the XML document is quite simple - no nested fields, etc. The only wrinkle in this is that the XML field names will not match the DICT field names, so something like LIST FILENAME TOXML ELEMENTS ... won't cut it for the export portion. From the discussion here and my reading, it appears that I can go the route of PrepareXML, OpenXMLData, ReadXMLData, CloseXMLData, ReleaseXML. But then I stumbled upon DBOTXML, XMLTODB which seem simpler (at least conceptually). I'm not sure if I'm missing something obvious, and I know at some point I have to create an XML mapping, just not sure which route is the one I should try - so I'm asking those of you actively working with with XML. If anyone can advice on which avenue I should follow (even if it's something I haven't listed above) I'd be grateful. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "Hindsight alone is not wisdom." George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] Universe and SQL Server
Nick, Thursday, February 2, 2006, 1:41:23 PM, you wrote: NC> Hello all, NC> We are currently looking into ways to share our data between NC> universe and SQL Server, and I am trying to get some suggestions NC> on the best way to do this. We are currently generating text NC> files in UV and ftp'ing those files to a designated location. We NC> have a task scheduler that picks up the files when they arrive and NC> inserts them into SQL server. I know there are ways to NC> communicate directly between SQL server and Universe and I am NC> looking for the best way to do this. It doesn't matter if NC> Universe reaches out to SQL Server or vice versa. Thanks. I think you will find the BCI client of Universe to be very good at the communication to SqlServer. Last year I worked with a client who needed the same type of communication. We developed a couple of routines they could use to 'read/write' SqlServer with minimal interference with the Universe developers. It turned out faily well .. quick and error free. There really is no need to go to any 'external middleware' answer when all the tools are right there. It lowers maintenance as your developers don't need to learn anything new (although that IS always fun). Give it a try .. ask questions here. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ 'Politics is like driving. To go backward, put it in R. To go forward, put it in D' unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Index at infocus
Ed and all: Apologies -- the server is completely down and in the process of being reconstructed -- fedora 4, apache 2.2 ... Expect to be back up into next week. Lee On Fri, 3 Feb 2006 [EMAIL PROTECTED] wrote: > http://www.indexinfocus.com/ hasn't been working for a week now at > least. Anyone know what's going on or who to tell about it? > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.375 / Virus Database: 267.15.0/249 - Release Date: 2/2/2006 > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Lee J. Leitner, Ph.D. [EMAIL PROTECTED] http://www.leitner.org/~leitnerl The world can only be grasped by action, not by contemplation. The hand is the cutting edge of the mind. -- Jacob Bronowski V.13.0 --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Index at infocus
http://www.indexinfocus.com/ hasn't been working for a week now at least. Anyone know what's going on or who to tell about it? -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.0/249 - Release Date: 2/2/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Universe and SQL Server
I have a client that I setup with such a scenario about 2 years ago and everything has been going smooth ever since. It consists of a .NET windows service that uses uniOLEDB and UO.NET to keep sql server data in sync with a universe database. The service itself is a 'dumb' data mover that can handle a number of different data scenarios - creating the destination datatables, moving entire files, specific records, custom exported data such as report data etc. The data that is synchronized is determined entirely on the universe side of things. The service kicks of at regular intervals ( hourly ) and checks with universe for queued sync requests. Very customizable. Very slick. If I could find the time I'd like to package it up for sale along with a number of other services I've written. Gerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: February 2, 2006 19:15 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Universe and SQL Server Just because you're exchanging data with a relational database doesn't mean you need to use SQL or ODBC with U2. You can use a middle-tier ADO.NET dataset, and then use that as your data source for SQL Server or Universe. For ADO.NET to U2 connectivity I'd use mv.NET, but you can use any tool available in this market once you setup the structures. The way you're doing this now, and this middle-tier approach, both allow you some freedom to make the data exchanges asynchronously - if one system is down the other can continue exporting or importing data with the middle tier. You don't have that option if you go direct from Universe to relational. It also allows you to change your data extraction methods without affecting the "other" side: If you're doing SQL queries from Universe, you need someone who understands both SQL and Universe to get in and make changes. If you keep the sides separate then you don't need one person with all skillsets. mv.NET is ideal for this sort of thing. With one of the built-in libraries (Core Objects) you can exchange data just with calls to BASIC rules, or you can open files and process dynamic arrays directly using familiar syntax from VB.NET, C#, or other languages. With another included library (Adapter Objects) you can use SQL-like syntax with DICT references for doing retrievals _and_ insert/update/delete operations. With SQL Server 2005 now allowing managed code for stored procedures, SQL Server is actually getting closer to the MV model, with code inside the environment itself. I haven't tried this, but I'd guess you could use mv.NET or UO.NET directly within SQL Server to poll Universe for data. The session pooling capabilities in mv.NET also allow for many users to process queries from a single DBMS license. Of course higher traffic or longer operations will require more licenses, but for short burst transactions this can be very economical. For a single process that sends data from Universe to SQL Server you only need one low-cost license. If you want to do this without getting an mv.NET developer license, I'll be happy to whip up a data exchange component to suit your needs, it would run as a Windows service that exchanges data in the background. I've been wanting to do this for a while anyway. The advantage of having a developer license of course is that instead of purchasing a single-use component you'll have a general purpose toolkit for doing all sorts of things. E-mail for more info: Tony Gravagno TG@ removethisNebula-RnD.com Nick Cipollina wrote: > Hello all, > > We are currently looking into ways to share our data between universe > and SQL Server, and I am trying to get some suggestions on the best > way to do this. We are currently generating text files in UV and > ftp'ing those files to a designated location. We have a task > scheduler that picks up the files when they arrive and inserts them > into SQL server. I know there are ways to communicate directly > between SQL server and Universe and I am looking for the best way to > do this. It doesn't matter if Universe reaches out to SQL Server or > vice versa. > Thanks. > > Nick Cipollina > > Pick Programmer > ACS Heritage, Inc. > 2810 North Parham Road, Suite 210 > Richmond, VA 23294 > (804)644-8707 x 314 > > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML Newbie with Unidata
I'm experienced with Unidata, but relatively new to XML. In short, I need to export a Unidata file to XML, and likewise later load XML data into said Unidata file. We're on Unidata 6.1.4 if that matters. For the sake of simplicity, we can assume all data fields in the Unidata file are single valued, so the XML structure is very simple - no nested fields, save the outermost ROOT and record tags. The only wrinkle is that the XML field names don't match the Unidata DICT, so I know I'll have to have a mapping. I need some advice on how to proceed. 1) From reading this list and the Unidata docs, I presume one route is PrepareXML, OpenXMLData, ReadXMLData, CloseXMLData, ReleaseXML. 2) Last night I stumbled across DBOTXML, XMLTODB but cannot find much in the way of documentation on these. 3) I see the many XDOM... routines, but this looks like overkill for my simple needs at this point. Any advice and/or recommendations are greatly appreciated. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "Hindsight alone is not wisdom." George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Test
Test - please ignore , Sorry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[no subject]
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Jeremy Woods/WA/QBE/Insurance is out of the office.
I will be out of the office starting 03/02/2006 and will not return until 14/02/2006. I will respond to your message when I return. IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. If you are not the intended recipient, any use or dissemination of the information and any disclosure or copying of this email is unauthorised and strictly prohibited. If you have received this email in error, please promptly inform us by reply email or telephone. You should also delete this email and destroy any hard copies produced. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] phantom COMO file message
Jeff, Yes, but Unidata also writes message there also, such as "PHANTOM process has completed." "Jeff Schasny" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/02/2006 02:30 PM Please respond to u2-users To: cc: Subject:RE: [U2] phantom COMO file message The messages in the &PH& file are whatever the output of your applications program provides. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 02, 2006 11:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] phantom COMO file message Sorry, I was not clear, I know where the _PH_ records are and how to view and create them, I was asking for a listing of various messages that Unidata would write to them, not just what is captured by the PHANTOM or COMO ON commands as out put. Thanks! "Anthony Dzikiewicz" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/02/2006 12:55 PM Please respond to u2-users To: cc: Subject:RE: [U2] phantom COMO file message They are in the &PH& file. Here is an example; >CLEAR.FILE DATA &PH& File "&PH&" has been cleared. >PHANTOM COUNT CF Phantom process started with process ID 17087. [17087] Done: COUNT CF >LIST &PH& LIST &PH& 12:49:43 02-02-06 PAGE 1 OS filename... COUNT_46180_13913 1 records listed. > 46180 IS THE TIME 12:49:40 AND 13913 IS THE DATE 02/02/06 Another way to track things is by doing COMO ON whatever, in each PAragraph. The problem with this is that each time you run the job it will step on the last one possibly hiding errors. Another thing to look at is the error log for Universe. On our system is in in /usr/ibm/uv/errlog. Basically the Universe home directory. If the file doesn't exist, then just create it and Universe will start logging to it. Anthony > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, February 02, 2006 11:58 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] phantom COMO file message > > > Does anyone know where I might get a list of COMO file > messages that are > written out by phantoms, when different issues come up in the > programs, > being ran by the PHANTOM command? > > For example, when is this message written out?: > > "PHANTOM process 392716 has completed." > > Is this simply written everytime the process that created the > COMO file > ended for any reason? What if an error state is encountered? What if > killed by an admin? What about a core dump? Etc. > > Our programmers relate "has completed" with a successful > completion of the > program. > > Thanks! > > Tom VanKirk > Systems Admin > Kraftmaid Cabinetry Inc. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.0/248 - Release Date: 2/1/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.0/248 - Release Date: 2/1/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
