[U2] Obtain the last spool number Universe generated

2011-10-31 Thread Jean Pierre Boishardy 
we are in universe version 10.1.22 /AIX 5.3

To obtain the last job number created by a user , we use the following shell
script :
sh -c \`cat /.uvhome`/bin/analyze.shm -p|grep sp_job_id| awk '{if (NF==NR) print
$0}'|awk  'BEGIN {OFS=:}{print $2}'\
But when the server is overloaded the job number delivered by the script seems 
not the right one.


1 -is what has already been observed?
2 -is this the only way?
 
Thanks,
Jean Pierre Boishardy

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] [ot] Is it just me.....

2011-10-31 Thread George Gallen 
Or was I the only person that wasn't thinking wine during this commercial?

http://www.youtube.com/watch?v=uS0fwYKCvIE
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Obtain the last spool number Universe generated

2011-10-31 Thread George Gallen 
Were you looking for the last job# for That user# or the last job# by any user?

If for that user# we use the following:

SUBROUTINE RETURN.SETPTR(JOBNAME,PON)
*
* RETURN-SETPTR - THIS SUBROUTINE WILL RETURN IN JOBNAME THE CURRENT
* SPOOL WILL GO TO.
*
*
*
*
   EXECUTE SETPTR :PON CAPTURING JUNK
   SEARCH=@FM:Output to HOLD file
   XX=INDEX(JUNK,SEARCH,1)
   IF XX=0 THEN
  JOBNAME=
  RETURN
   END
   JUNK=JUNK[XX+1,LEN(JUNK)]
   YY=INDEX(JUNK,:,1)
   YZ=INDEX(JUNK,CHAR(254),1)
   JOBNAME=JUNK[YY+2,YZ-YY-2]
   RETURN
*
END


George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jean Pierre Boishardy
Sent: Monday, October 31, 2011 8:18 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Obtain the last spool number Universe generated

we are in universe version 10.1.22 /AIX 5.3

To obtain the last job number created by a user , we use the following shell
script :
sh -c \`cat /.uvhome`/bin/analyze.shm -p|grep sp_job_id| awk '{if (NF==NR) print
$0}'|awk  'BEGIN {OFS=:}{print $2}'\
But when the server is overloaded the job number delivered by the script seems 
not the right one.


1 -is what has already been observed?
2 -is this the only way?
 
Thanks,
Jean Pierre Boishardy

___
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

Re: [U2] Obtain the last spool number Universe generated

2011-10-31 Thread George Gallen 
This subroutine must be run by that user# in order to function correctly.

And it returns the HOLD filename, not the spooler number - sorry.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, October 31, 2011 10:17 AM
To: U2 Users List
Subject: Re: [U2] Obtain the last spool number Universe generated

Were you looking for the last job# for That user# or the last job# by any user?

If for that user# we use the following:

SUBROUTINE RETURN.SETPTR(JOBNAME,PON)
*
* RETURN-SETPTR - THIS SUBROUTINE WILL RETURN IN JOBNAME THE CURRENT
* SPOOL WILL GO TO.
*
*
*
*
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho 
Hey Guys,

I am concatenating an alpha code into a string providing that the code 
does not already exist (in the string).  If my existing string = X.STRING 
and my code = X.CODE should the following work?

IF X.STRING MATCH X.CODE THEN
END ELSE
  X.STRING = X.STRING:',':X.CODE
END

Thanks!

Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread Wjhonson 

Does Matches recognize comma as a delimiter? I don't think it does.

IF NOT(X.STRING) MATCH X.CODE THEN   X.STRING1,-1 = X.CODE



-Original Message-
From: Greg Coelho coe...@american.edu
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Oct 31, 2011 10:37 am
Subject: Re: [U2] Using 'MATCH'


Hey Guys,
I am concatenating an alpha code into a string providing that the code 
oes not already exist (in the string).  If my existing string = X.STRING 
nd my code = X.CODE should the following work?
IF X.STRING MATCH X.CODE THEN
ND ELSE
 X.STRING = X.STRING:',':X.CODE
ND
Thanks!
Greg
__
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Martin Braid 
Hi Greg, I would convert your string to a VM array, use the LOCATE
syntax to add it if relevant and then convert back to a string. Martin
(I am not going to worry why you aren't just using an array)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: 31 October 2011 17:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using 'MATCH'

Hey Guys,

I am concatenating an alpha code into a string providing that the code 
does not already exist (in the string).  If my existing string =
X.STRING 
and my code = X.CODE should the following work?

IF X.STRING MATCH X.CODE THEN
END ELSE
  X.STRING = X.STRING:',':X.CODE
END

Thanks!

Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Epicor Software (UK) is a limited company registered in England  Wales.  
Registration Number: 2338274.   Registered Office:  6th Floor, One London Wall, 
London EC2Y 5EB 
This e-mail is for the use of the intended recipient(s) only. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not use, disclose or 
distribute this e-mail without the author's prior permission. We have taken 
precautions to minimize the risk of transmitting software viruses, but we 
advise you to carry out your own virus checks on any attachment to this 
message. We cannot accept liability for any loss or damage caused by software 
viruses. Any views and/or opinions expressed in this e-mail are of the author 
only and do not represent the views of Epicor Software (UK) Limited or any 
other company within its group.


This message has been scanned for malware by Websense. www.websense.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread Woodward, Bob 
You might also be able to use COUNT.

IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE

Not knowing what your potential codes are, though, they may or may not
fit your needs.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid
Sent: Monday, October 31, 2011 10:44 AM
To: U2 Users List
Subject: Re: [U2] Using 'MATCH'

Hi Greg, I would convert your string to a VM array, use the LOCATE
syntax to add it if relevant and then convert back to a string. Martin
(I am not going to worry why you aren't just using an array)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: 31 October 2011 17:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using 'MATCH'

Hey Guys,

I am concatenating an alpha code into a string providing that the code 
does not already exist (in the string).  If my existing string =
X.STRING 
and my code = X.CODE should the following work?

IF X.STRING MATCH X.CODE THEN
END ELSE
  X.STRING = X.STRING:',':X.CODE
END

Thanks!

Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Epicor Software (UK) is a limited company registered in England  Wales.

Registration Number: 2338274.   Registered Office:  6th Floor, One
London Wall, London EC2Y 5EB 
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses. Any views
and/or opinions expressed in this e-mail are of the author only and do
not represent the views of Epicor Software (UK) Limited or any other
company within its group.


This message has been scanned for malware by Websense. www.websense.com
___
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread George Gallen 
How about?

LOCATE X.CODE IN CHANGE(X.STRING,,,CHAR(254)) SETTING POS ELSE 
X.STRING=X.STRING:,:X.CODE

Or 

LOCATE X.CODE IN CHANGE(X.STRING,,,CHAR(254))1 SETTING POS ELSE 
X.STRING=X.STRING:,:X.CODE


Depending on which UV Flavor your running

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, October 31, 2011 1:43 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using 'MATCH'


Does Matches recognize comma as a delimiter? I don't think it does.

IF NOT(X.STRING) MATCH X.CODE THEN   X.STRING1,-1 = X.CODE



-Original Message-
From: Greg Coelho coe...@american.edu
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Oct 31, 2011 10:37 am
Subject: Re: [U2] Using 'MATCH'


Hey Guys,
I am concatenating an alpha code into a string providing that the code 
oes not already exist (in the string).  If my existing string = X.STRING 
nd my code = X.CODE should the following work?
IF X.STRING MATCH X.CODE THEN
ND ELSE
 X.STRING = X.STRING:',':X.CODE
ND
Thanks!
Greg
__
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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread Wjhonson 

If there is a need to extrude the result comma-delimited then

IF NOT(X.STRING) MATCH X.CODE THEN   X.STRING1,-1 = X.CODE
CONVERT , TO @VM IN X.STRING


-Original Message-
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Oct 31, 2011 11:47 am
Subject: Re: [U2] Using 'MATCH'


How about?
LOCATE X.CODE IN CHANGE(X.STRING,,,CHAR(254)) SETTING POS ELSE 
.STRING=X.STRING:,:X.CODE
Or 
LOCATE X.CODE IN CHANGE(X.STRING,,,CHAR(254))1 SETTING POS ELSE 
.STRING=X.STRING:,:X.CODE

epending on which UV Flavor your running
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: Monday, October 31, 2011 1:43 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Using 'MATCH'

oes Matches recognize comma as a delimiter? I don't think it does.
IF NOT(X.STRING) MATCH X.CODE THEN   X.STRING1,-1 = X.CODE

-Original Message-
rom: Greg Coelho coe...@american.edu
o: u2-users u2-users@listserver.u2ug.org
ent: Mon, Oct 31, 2011 10:37 am
ubject: Re: [U2] Using 'MATCH'

ey Guys,
 am concatenating an alpha code into a string providing that the code 
es not already exist (in the string).  If my existing string = X.STRING 
d my code = X.CODE should the following work?
F X.STRING MATCH X.CODE THEN
D ELSE
X.STRING = X.STRING:',':X.CODE
D
hanks!
reg
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Wjhonson 

Oops!  Recte

CONVERT @VM TO , IN X.STRING





-Original Message-
From: Wjhonson wjhon...@aol.com
To: u2-users u2-users@listserver.u2ug.org
Sent: Mon, Oct 31, 2011 11:50 am
Subject: Re: [U2] Using 'MATCH'



f there is a need to extrude the result comma-delimited then
IF NOT(X.STRING) MATCH X.CODE THEN   X.STRING1,-1 = X.CODE
ONVERT , TO @VM IN X.STRING


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread George Gallen 
I would normally work with the dynamic array, and convert when done

Aside from CONVERT @VM TO , IN X.STRING

Also...

X.STRING = '' : CHANGE(X.STRING,@VM,',') : ''

If you need quoted comma delimited - this will NOT however, change embedded 's 
which will corrupt your data

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, October 31, 2011 2:50 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using 'MATCH'


If there is a need to extrude the result comma-delimited then

IF NOT(X.STRING) MATCH X.CODE THEN   X.STRING1,-1 = X.CODE
CONVERT , TO @VM IN X.STRING


-Original Message-
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Oct 31, 2011 11:47 am
Subject: Re: [U2] Using 'MATCH'


How about?
LOCATE X.CODE IN CHANGE(X.STRING,,,CHAR(254)) SETTING POS ELSE 
.STRING=X.STRING:,:X.CODE
Or 
LOCATE X.CODE IN CHANGE(X.STRING,,,CHAR(254))1 SETTING POS ELSE 
.STRING=X.STRING:,:X.CODE

epending on which UV Flavor your running
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: Monday, October 31, 2011 1:43 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Using 'MATCH'

oes Matches recognize comma as a delimiter? I don't think it does.
IF NOT(X.STRING) MATCH X.CODE THEN   X.STRING1,-1 = X.CODE

-Original Message-
rom: Greg Coelho coe...@american.edu
o: u2-users u2-users@listserver.u2ug.org
ent: Mon, Oct 31, 2011 10:37 am
ubject: Re: [U2] Using 'MATCH'

ey Guys,
 am concatenating an alpha code into a string providing that the code 
es not already exist (in the string).  If my existing string = X.STRING 
d my code = X.CODE should the following work?
F X.STRING MATCH X.CODE THEN
D ELSE
X.STRING = X.STRING:',':X.CODE
D
hanks!
reg
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread George Smith 
If you are trying to look for an arbitrary delimited string, I think the
safest thing to do is

IF INDEX(',':X.STRING:',',  ',':X.CODE:',',1) THEN
X.STRING=X.STRING:',':X.CODE


On Mon, Oct 31, 2011 at 10:55 AM, Woodward, Bob
bob_woodw...@k2sports.comwrote:

 You might also be able to use COUNT.

 IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE

 Not knowing what your potential codes are, though, they may or may not
 fit your needs.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid
 Sent: Monday, October 31, 2011 10:44 AM
 To: U2 Users List
 Subject: Re: [U2] Using 'MATCH'

 Hi Greg, I would convert your string to a VM array, use the LOCATE
 syntax to add it if relevant and then convert back to a string. Martin
 (I am not going to worry why you aren't just using an array)

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
 Sent: 31 October 2011 17:38
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Using 'MATCH'

 Hey Guys,

 I am concatenating an alpha code into a string providing that the code
 does not already exist (in the string).  If my existing string =
 X.STRING
 and my code = X.CODE should the following work?

 IF X.STRING MATCH X.CODE THEN
 END ELSE
  X.STRING = X.STRING:',':X.CODE
 END

 Thanks!

 Greg
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 

 Epicor Software (UK) is a limited company registered in England  Wales.

 Registration Number: 2338274.   Registered Office:  6th Floor, One
 London Wall, London EC2Y 5EB
 This e-mail is for the use of the intended recipient(s) only. If you
 have received this e-mail in error, please notify the sender immediately
 and then delete it. If you are not the intended recipient, you must not
 use, disclose or distribute this e-mail without the author's prior
 permission. We have taken precautions to minimize the risk of
 transmitting software viruses, but we advise you to carry out your own
 virus checks on any attachment to this message. We cannot accept
 liability for any loss or damage caused by software viruses. Any views
 and/or opinions expressed in this e-mail are of the author only and do
 not represent the views of Epicor Software (UK) Limited or any other
 company within its group.


 This message has been scanned for malware by Websense. www.websense.com
 ___
 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




-- 
George Smith,  Phoenix, AZ
Member of the Independent Computer Consultants Association since 1983
Member of the Institute for Management Consulting since 2007
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread George Smith 
Hit the wrong key and sent this incomplete. Finished below

On Mon, Oct 31, 2011 at 12:15 PM, George Smith grsassocia...@gmail.comwrote:


 If you are trying to look for an arbitrary delimited string, I think the
 safest thing to do is something like

 IF INDEX(',':X.STRING:',',  ',':X.CODE:',',1)=0 THEN
 X.STRING=X.STRING:',':X.CODE




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho 
Guys,

Thanks for the great suggestions.  I believe that I did get MATCH confused 
with COUNT thinking that it could navigate a delimiter...  In this 
situation I'm thinking that just using COUNT would be the best solution. I 
do appreciate the diversity of the solutions presented.

Thanks!

Greg



From:   Woodward, Bob bob_woodw...@k2sports.com
To: U2 Users List u2-users@listserver.u2ug.org
Date:   10/31/2011 01:55 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org



You might also be able to use COUNT.

IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE

Not knowing what your potential codes are, though, they may or may not
fit your needs.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid
Sent: Monday, October 31, 2011 10:44 AM
To: U2 Users List
Subject: Re: [U2] Using 'MATCH'

Hi Greg, I would convert your string to a VM array, use the LOCATE
syntax to add it if relevant and then convert back to a string. Martin
(I am not going to worry why you aren't just using an array)

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: 31 October 2011 17:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using 'MATCH'

Hey Guys,

I am concatenating an alpha code into a string providing that the code 
does not already exist (in the string).  If my existing string =
X.STRING 
and my code = X.CODE should the following work?

IF X.STRING MATCH X.CODE THEN
END ELSE
  X.STRING = X.STRING:',':X.CODE
END

Thanks!

Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Epicor Software (UK) is a limited company registered in England  Wales.

Registration Number: 2338274.   Registered Office:  6th Floor, One
London Wall, London EC2Y 5EB 
This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We cannot accept
liability for any loss or damage caused by software viruses. Any views
and/or opinions expressed in this e-mail are of the author only and do
not represent the views of Epicor Software (UK) Limited or any other
company within its group.


This message has been scanned for malware by Websense. www.websense.com
___
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread George Gallen 
Be careful using a straight count,

Because HELL will be found in in the word HELLO for instance, and would not 
be added
Make sure you surround your search criteria with the delimiters being used, as 
noted in one of the replies.

So, ,HELL, would not be found if ,HELLO, were in the list.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Monday, October 31, 2011 4:15 PM
To: U2 Users List
Subject: Re: [U2] Using 'MATCH'

Guys,

Thanks for the great suggestions.  I believe that I did get MATCH confused 
with COUNT thinking that it could navigate a delimiter...  In this 
situation I'm thinking that just using COUNT would be the best solution. I 
do appreciate the diversity of the solutions presented.

Thanks!

Greg



From:   Woodward, Bob bob_woodw...@k2sports.com
To: U2 Users List u2-users@listserver.u2ug.org
Date:   10/31/2011 01:55 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org



You might also be able to use COUNT.

IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE

Not knowing what your potential codes are, though, they may or may not
fit your needs.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread Wjhonson 

Match *can* navigate a delimiter.
It navigates the multi-value delimiter @VM
That's the only one it can navigate, but why not use it if it's there ?
To me using Match makes the code clear.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread George Gallen 
Is it flavor dependent?

I tried it under Information flavor :

0001: Y=HELLO
0002: Y1,-1=THERE
0003: IF Y MATCH HELLO THEN PRINT YES ELSE PRINT NO
0004: STOP
0005: END

I got NO, unless I set it up incorrectly - could be...I never used for this 
purpose before.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, October 31, 2011 4:47 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using 'MATCH'


Match *can* navigate a delimiter.
It navigates the multi-value delimiter @VM
That's the only one it can navigate, but why not use it if it's there ?
To me using Match makes the code clear.
___
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho 
George,

Thanks!  This is a good point.  I will retain the ',' delimiter when I do 
my COUNT.

Greg



From:   George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Date:   10/31/2011 04:45 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org



Be careful using a straight count,

Because HELL will be found in in the word HELLO for instance, and 
would not be added
Make sure you surround your search criteria with the delimiters being 
used, as noted in one of the replies.

So, ,HELL, would not be found if ,HELLO, were in the list.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Monday, October 31, 2011 4:15 PM
To: U2 Users List
Subject: Re: [U2] Using 'MATCH'

Guys,

Thanks for the great suggestions.  I believe that I did get MATCH confused 

with COUNT thinking that it could navigate a delimiter...  In this 
situation I'm thinking that just using COUNT would be the best solution. I 

do appreciate the diversity of the solutions presented.

Thanks!

Greg



From:   Woodward, Bob bob_woodw...@k2sports.com
To: U2 Users List u2-users@listserver.u2ug.org
Date:   10/31/2011 01:55 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org



You might also be able to use COUNT.

IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE

Not knowing what your potential codes are, though, they may or may not
fit your needs.

___
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho 
George,

Thanks for pointing this out.  I'm running a test now... if it there are 
any issues I'll switch to MATCH and @VM.

Greg



From:   George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Date:   10/31/2011 05:10 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org



Is it flavor dependent?

I tried it under Information flavor :

0001: Y=HELLO
0002: Y1,-1=THERE
0003: IF Y MATCH HELLO THEN PRINT YES ELSE PRINT NO
0004: STOP
0005: END

I got NO, unless I set it up incorrectly - could be...I never used for 
this purpose before.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, October 31, 2011 4:47 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Using 'MATCH'


Match *can* navigate a delimiter.
It navigates the multi-value delimiter @VM
That's the only one it can navigate, but why not use it if it's there ?
To me using Match makes the code clear.
___
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Wjhonson 

Your syntax is backward George its not IF Y MATCH HELLO
its
IF HELLO MATCH Y










-Original Message-
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Oct 31, 2011 2:10 pm
Subject: Re: [U2] Using 'MATCH'


Is it flavor dependent?
I tried it under Information flavor :
0001: Y=HELLO
002: Y1,-1=THERE
003: IF Y MATCH HELLO THEN PRINT YES ELSE PRINT NO
004: STOP
005: END
I got NO, unless I set it up incorrectly - could be...I never used for this 
urpose before.
George
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: Monday, October 31, 2011 4:47 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Using 'MATCH'

atch *can* navigate a delimiter.
t navigates the multi-value delimiter @VM
hat's the only one it can navigate, but why not use it if it's there ?
o me using Match makes the code clear.
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho 
Guys,

I've run a test against 10,000 records and COUNT is performing flawlessly. 
 When I get a minute I'll switch it to MATCH and see how it runs.  I agree 
with the comment that MATCH would be clearer code and would easier to 
follow...

Thanks again,

Greg



From:   Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org
Date:   10/31/2011 05:20 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org




Your syntax is backward George its not IF Y MATCH HELLO
its
IF HELLO MATCH Y










-Original Message-
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Oct 31, 2011 2:10 pm
Subject: Re: [U2] Using 'MATCH'


Is it flavor dependent?
I tried it under Information flavor :
0001: Y=HELLO
002: Y1,-1=THERE
003: IF Y MATCH HELLO THEN PRINT YES ELSE PRINT NO
004: STOP
005: END
I got NO, unless I set it up incorrectly - could be...I never used for 
this 
urpose before.
George
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: Monday, October 31, 2011 4:47 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Using 'MATCH'

atch *can* navigate a delimiter.
t navigates the multi-value delimiter @VM
hat's the only one it can navigate, but why not use it if it's there ?
o me using Match makes the code clear.
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
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

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Using 'MATCH'

2011-10-31 Thread Mecki Foerthmann 

I don't get the problem.
Why would you want to do this in the first place?
Why not just convert the commas to @VM, use LOCATE and convert the @VM 
back to commas?


BTW if the first string is HELL or it is the first entry then counting 
,HELL, won't find it either.

KISS!

Mecki

On 31/10/2011 20:41, George Gallen wrote:

Be careful using a straight count,

Because HELL will be found in in the word HELLO for instance, and would not 
be added
Make sure you surround your search criteria with the delimiters being used, as 
noted in one of the replies.

So, ,HELL, would not be found if ,HELLO, were in the list.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Monday, October 31, 2011 4:15 PM
To: U2 Users List
Subject: Re: [U2] Using 'MATCH'

Guys,

Thanks for the great suggestions.  I believe that I did get MATCH confused
with COUNT thinking that it could navigate a delimiter...  In this
situation I'm thinking that just using COUNT would be the best solution. I
do appreciate the diversity of the solutions presented.

Thanks!

Greg



From:   Woodward, Bobbob_woodw...@k2sports.com
To: U2 Users Listu2-users@listserver.u2ug.org
Date:   10/31/2011 01:55 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org



You might also be able to use COUNT.

IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE

Not knowing what your potential codes are, though, they may or may not
fit your needs.

___
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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho 
Mechi,

I am creating an extract for export to a third party vendor.  This 
requires that I convert a multi-valued field to a single (comma delimited) 
value.  The thought was instead of converting from comma to @VM and then 
back to comma that we might save the processor a bit of work by keeping is 
simple and just using COUNT against the comma delimited value.  Initially 
I thought that I might go upstream and use LOCATE while we were still 
dealing with a multi-valued field, there are subroutines in place that are 
considering other criteria...

Thanks,

Greg



From:   Mecki Foerthmann mec...@gmx.net
To: u2-users@listserver.u2ug.org
Date:   10/31/2011 05:54 PM
Subject:Re: [U2] Using 'MATCH'
Sent by:u2-users-boun...@listserver.u2ug.org



I don't get the problem.
Why would you want to do this in the first place?
Why not just convert the commas to @VM, use LOCATE and convert the @VM 
back to commas?

BTW if the first string is HELL or it is the first entry then counting 
,HELL, won't find it either.
KISS!

Mecki

On 31/10/2011 20:41, George Gallen wrote:
 Be careful using a straight count,

 Because HELL will be found in in the word HELLO for instance, and 
would not be added
 Make sure you surround your search criteria with the delimiters being 
used, as noted in one of the replies.

 So, ,HELL, would not be found if ,HELLO, were in the list.

 George

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
 Sent: Monday, October 31, 2011 4:15 PM
 To: U2 Users List
 Subject: Re: [U2] Using 'MATCH'

 Guys,

 Thanks for the great suggestions.  I believe that I did get MATCH 
confused
 with COUNT thinking that it could navigate a delimiter...  In this
 situation I'm thinking that just using COUNT would be the best solution. 
I
 do appreciate the diversity of the solutions presented.

 Thanks!

 Greg



 From:   Woodward, Bobbob_woodw...@k2sports.com
 To: U2 Users Listu2-users@listserver.u2ug.org
 Date:   10/31/2011 01:55 PM
 Subject:Re: [U2] Using 'MATCH'
 Sent by:u2-users-boun...@listserver.u2ug.org



 You might also be able to use COUNT.

 IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE

 Not knowing what your potential codes are, though, they may or may not
 fit your needs.

 ___
 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

Re: [U2] Using 'MATCH'

2011-10-31 Thread Wols Lists 
On 31/10/11 17:37, Greg Coelho wrote:
 Hey Guys,
 
 I am concatenating an alpha code into a string providing that the code 
 does not already exist (in the string).  If my existing string = X.STRING 
 and my code = X.CODE should the following work?
 
 IF X.STRING MATCH X.CODE THEN
 END ELSE
   X.STRING = X.STRING:',':X.CODE
 END
 
I notice nobody seems to have pointed out a MAJOR gotcha in using MATCH.
If your code is as described, you'll avoid it, but what validation have
you got in place on X.CODE? Is it possible that numbers could
accidentally get into it?

We did something like this years ago with a line something like

IF TEXT MATCH USER THEN

where USER was the department code followed by the user's initials. And
while most departments were alphas, there were a couple of alphanumerics.

All went well until Albert from M6 ran the code ...

USER = M6AWT

Who can see the landmine just waiting to explode ... ?

Cheers,
Wol
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users