Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
That may be applicable if we're controlling both lists, but in this situation list 0 could come from anywhere. We just need to be able to execute a second list without blowing away list 0. On Mon, Sep 24, 2012 at 11:44 AM, Trevor Fulton tful...@epicor.com wrote: BASICTYPE M and P allows for named Select Lists, so you can EXECUTE SENTENCE RTNLIST WIP.LIST CAPTURING JUNK LOOP READNEXT WIP.ID FROM WIP.LIST ELSE EXIT CALL SUB1 REPEAT So in SUB1 you can do another EXECUTE to another Named list. Trevor. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 24 September 2012 17:43 To: U2 Users List Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== mzYSmfEz!grmb2Vr9yuNyLUcPPmbfFPdrr1lqOECv!Swg== to report this email as spam. 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] Unidata 7.1.16 Multiple Active Select Lists
Good thought on the index, but alas, no index on the file. We could
probably add one, but then how do we control the order of the records being
retrieved from the list? (The order is important to our process.)
On Mon, Sep 24, 2012 at 11:49 AM, Dave Davis dda...@harriscomputer.comwrote:
Aren't these nested selects kind of slow?
If the field in file b is indexed, I would use the SETINDEX and READFWD
statements in place of the SELECT statement. You are using Unidata, so
unless you need to make this work for Universe as well that's what I would
do.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 1:43 PM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Well, that success was short lived. While the READLIST and FORMLIST allow
my SUBR(..) field to not consume the active select list zero, these two
commands produce different results:
LIST ORDER.LINE WITH fieldName fieldName
...this will show the lines that have this field set, and will show the
field properly. However, this command returns no items:
SELECT ORDER.LINE WITH fieldName
Basically my program is doing this:
READLIST ACTIVE.LIST FROM 0 ELSE NULL
*
CMD = select ... TO 2
EXECUTE CMD CAPTURING OUTPUT
*
EOF = @FALSE
LOOP
READNEXT ID FROM 2 ELSE EOF = @TRUE
UNTIL EOF DO
..
REPEAT
*
CLEARSELECT 2
*
FORMLIST ACTIVE.LIST TO 0
All other input/ideas appreciated.
On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com
wrote:
And we have a winner! Thank you everyone! The READLIST and FORMLIST
will work; seems kinda kludgy, but hey, it's working.
On Mon, Sep 24, 2012 at 11:21 AM, David A. Green
dgr...@dagconsulting.com
wrote:
If you already have an active list then you'll have to save it, then
restore it. See READLIST and FORMLIST.
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 10:11 AM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
It's all fine if the program controls both lists, but in this case
the
SUBR(..) type field could be accessed in just about any context, from
TCL, from a download, from MITS, from another BASIC routine, with or
without a select list...
The RTNLIST doesn't solve the problem of my select command
consuming the active list 0. It seems that the PASSLIST extension to
EXECUTE is designed specifically for this purpose, but it produces
nothing but compilation
errors:
CMD = select ...
EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2
...produces a compilation error about the misuse of RTNLIST,
despite the documentation saying this should be possible.
The point is that I want to leave select list 0 entirely alone, which
is why I'm using $BASICTYPE U. BASICTYPE P - standard on these
SB+ systems - does not allow one to READNEXT from anything but list
0, and I want to leave list zero untouched.
Gotta be a way, right?
-K
On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com
wrote:
Hi Kevin, Any reason why you are using type U ? This certainly
works using P ...
S='SELECT SOMEFILE WITH SOMETHING = OOJIT'
EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT
EOF=0
LOOP UNTIL EOF DO
READNEXT MYID FROM MYLIST THEN
GSOUB MYMESS
END ELSE EOF=1
REPEAT
Martin
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker
Hughes
Sent: 24 September 2012 17:49
To: 'U2 Users List'
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Can you use SELECT yourfile WITH whatever TO 8 {specific list
number} in the master process, and let your SUBR virtual field
default to list
0 {zero}?
The other option could be to do a READLIST within the SUBR function
and reset the list when RETURNing, but this could be onerous in
terms of processing speed.
HTH
-Baker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin
King
Sent: Monday, September 24, 2012 11:43 AM
To: U2 Users List
Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists
How does one manage multiple active select lists in Unidata? I
could have sworn I've done this before, but for some reason it's
not working at all as I recall.
I have this SUBR(..) type field in file A that selects records from
file B to calculate an aggregate. This works fine when listing
file A and showing the field. However, if there's an active select
list when file A is listed
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Bob, this is exactly what I'm attempting, to save the current 0 list and
restore it. David, checking the list before the FORM.LIST appears to have
solved the problem. Thank you.
Has this kind of thing always been this onerous? I recall doing it much
more easily - on Unidata - but it's been years.
On Mon, Sep 24, 2012 at 11:57 AM, Woodward, Bob
bob_woodw...@k2sports.comwrote:
Seems like the simple solution would be in your subroutine, before you
need to generate your select, test the SYSTEM variable to see if an
active select is already in use. If it is, do a READLIST into a
variable. Then at the end of your subroutine, if anything is in your
variable, do a UNIBASIC SELECT to reestablish the active select list.
You might just always check for an active list at the beginning of your
subroutine as a normal setup function then as a exit routine, restore
the active list.
Just a thought.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 10:43 AM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Well, that success was short lived. While the READLIST and FORMLIST
allow my SUBR(..) field to not consume the active select list zero,
these two commands produce different results:
LIST ORDER.LINE WITH fieldName fieldName
...this will show the lines that have this field set, and will show the
field properly. However, this command returns no items:
SELECT ORDER.LINE WITH fieldName
Basically my program is doing this:
READLIST ACTIVE.LIST FROM 0 ELSE NULL
*
CMD = select ... TO 2
EXECUTE CMD CAPTURING OUTPUT
*
EOF = @FALSE
LOOP
READNEXT ID FROM 2 ELSE EOF = @TRUE
UNTIL EOF DO
..
REPEAT
*
CLEARSELECT 2
*
FORMLIST ACTIVE.LIST TO 0
All other input/ideas appreciated.
On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com
wrote:
And we have a winner! Thank you everyone! The READLIST and FORMLIST
will work; seems kinda kludgy, but hey, it's working.
On Mon, Sep 24, 2012 at 11:21 AM, David A. Green
dgr...@dagconsulting.com
wrote:
If you already have an active list then you'll have to save it, then
restore it. See READLIST and FORMLIST.
David A. Green
(480) 813-1725
DAG Consulting
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 10:11 AM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
It's all fine if the program controls both lists, but in this case
the
SUBR(..) type field could be accessed in just about any context, from
TCL, from a download, from MITS, from another BASIC routine, with or
without a select list...
The RTNLIST doesn't solve the problem of my select command
consuming the active list 0. It seems that the PASSLIST extension to
EXECUTE is designed specifically for this purpose, but it produces
nothing but compilation
errors:
CMD = select ...
EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2
...produces a compilation error about the misuse of RTNLIST,
despite the documentation saying this should be possible.
The point is that I want to leave select list 0 entirely alone, which
is why I'm using $BASICTYPE U. BASICTYPE P - standard on these
SB+ systems - does not allow one to READNEXT from anything but list
0, and I want to leave list zero untouched.
Gotta be a way, right?
-K
On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com
wrote:
Hi Kevin, Any reason why you are using type U ? This
certainly
works using P ...
S='SELECT SOMEFILE WITH SOMETHING = OOJIT'
EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT
EOF=0
LOOP UNTIL EOF DO
READNEXT MYID FROM MYLIST THEN
GSOUB MYMESS
END ELSE EOF=1
REPEAT
Martin
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker
Hughes
Sent: 24 September 2012 17:49
To: 'U2 Users List'
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Can you use SELECT yourfile WITH whatever TO 8 {specific list
number} in the master process, and let your SUBR virtual field
default to list
0 {zero}?
The other option could be to do a READLIST within the SUBR function
and reset the list when RETURNing, but this could be onerous in
terms of processing speed.
HTH
-Baker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin
King
Sent: Monday, September 24, 2012 11:43 AM
To: U2 Users List
Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists
How does one manage multiple active select lists in Unidata
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
That's just it, George, there is no saved list. It's just an active list 0. On Mon, Sep 24, 2012 at 12:05 PM, George R Smith geo...@grsmith.arcoxmail.com wrote: Have you given any consideration on reading the list from the pointer file ? George -Original Message- From: Kevin King Sent: Monday, September 24, 2012 1:01 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Bob, this is exactly what I'm attempting, to save the current 0 list and restore it. David, checking the list before the FORM.LIST appears to have solved the problem. Thank you. Has this kind of thing always been this onerous? I recall doing it much more easily - on Unidata - but it's been years. On Mon, Sep 24, 2012 at 11:57 AM, Woodward, Bob bob_woodw...@k2sports.com**wrote: Seems like the simple solution would be in your subroutine, before you need to generate your select, test the SYSTEM variable to see if an active select is already in use. If it is, do a READLIST into a variable. Then at the end of your subroutine, if anything is in your variable, do a UNIBASIC SELECT to reestablish the active select list. You might just always check for an active list at the beginning of your subroutine as a normal setup function then as a exit routine, restore the active list. Just a thought. -Original Message- From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:43 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com wrote: And we have a winner! Thank you everyone! The READLIST and FORMLIST will work; seems kinda kludgy, but hey, it's working. On Mon, Sep 24, 2012 at 11:21 AM, David A. Green dgr...@dagconsulting.com wrote: If you already have an active list then you'll have to save it, then restore it. See READLIST and FORMLIST. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:11 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists It's all fine if the program controls both lists, but in this case the SUBR(..) type field could be accessed in just about any context, from TCL, from a download, from MITS, from another BASIC routine, with or without a select list... The RTNLIST doesn't solve the problem of my select command consuming the active list 0. It seems that the PASSLIST extension to EXECUTE is designed specifically for this purpose, but it produces nothing but compilation errors: CMD = select ... EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2 ...produces a compilation error about the misuse of RTNLIST, despite the documentation saying this should be possible. The point is that I want to leave select list 0 entirely alone, which is why I'm using $BASICTYPE U. BASICTYPE P - standard on these SB+ systems - does not allow one to READNEXT from anything but list 0, and I want to leave list zero untouched. Gotta be a way, right? -K On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com wrote: Hi Kevin, Any reason why you are using type U ? This certainly works using P ... S='SELECT SOMEFILE WITH SOMETHING = OOJIT' EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT EOF=0 LOOP UNTIL EOF DO READNEXT MYID FROM MYLIST THEN GSOUB MYMESS END ELSE EOF=1 REPEAT Martin -Original Message- From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 24 September 2012 17:49 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Can you use SELECT yourfile
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
What I don't understand is why I can't seem to get PASSLIST and RTNLIST to work in BASIC. Seems that's exactly what these are intended to do but they give me nothing but compilation failures. On Mon, Sep 24, 2012 at 12:12 PM, George R Smith geo...@grsmith.arcoxmail.com wrote: Kevin, Got it, and you don't want to or can't READNEXT thru and create your own list and save it to file of our choice then read it back in and use. I know it seems like you should not have to do that but I have used this in the past. George -Original Message- From: Kevin King Sent: Monday, September 24, 2012 1:08 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists That's just it, George, there is no saved list. It's just an active list 0. On Mon, Sep 24, 2012 at 12:05 PM, George R Smith geo...@grsmith.arcoxmail.com wrote: Have you given any consideration on reading the list from the pointer file ? George -Original Message- From: Kevin King Sent: Monday, September 24, 2012 1:01 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Bob, this is exactly what I'm attempting, to save the current 0 list and restore it. David, checking the list before the FORM.LIST appears to have solved the problem. Thank you. Has this kind of thing always been this onerous? I recall doing it much more easily - on Unidata - but it's been years. On Mon, Sep 24, 2012 at 11:57 AM, Woodward, Bob bob_woodw...@k2sports.comwrote: Seems like the simple solution would be in your subroutine, before you need to generate your select, test the SYSTEM variable to see if an active select is already in use. If it is, do a READLIST into a variable. Then at the end of your subroutine, if anything is in your variable, do a UNIBASIC SELECT to reestablish the active select list. You might just always check for an active list at the beginning of your subroutine as a normal setup function then as a exit routine, restore the active list. Just a thought. -Original Message- From: u2-users-bounces@listserver.u2ug.org http://u2ug.org u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@**lis**tserver.u2ug.orghttp://listserver.u2ug.org u2-users-**boun...@listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org ] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:43 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com wrote: And we have a winner! Thank you everyone! The READLIST and FORMLIST will work; seems kinda kludgy, but hey, it's working. On Mon, Sep 24, 2012 at 11:21 AM, David A. Green dgr...@dagconsulting.com wrote: If you already have an active list then you'll have to save it, then restore it. See READLIST and FORMLIST. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-bounces@listserver.u2ug.org http://u2ug.org u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@**lis**tserver.u2ug.orghttp://listserver.u2ug.org u2-users-**boun...@listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org ] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:11 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists It's all fine if the program controls both lists, but in this case the SUBR(..) type field could be accessed in just about any context, from TCL, from a download, from MITS, from another BASIC routine, with or without a select list... The RTNLIST doesn't solve the problem of my select command consuming the active list 0. It seems that the PASSLIST extension to EXECUTE is designed specifically for this purpose, but it produces nothing but compilation errors: CMD = select ... EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2 ...produces a compilation error about the misuse of RTNLIST, despite the documentation saying this should be possible. The point is that I want to leave select list 0 entirely alone, which is why I'm using $BASICTYPE U. BASICTYPE P
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Thanks for the information. It is unusual that the subroutine works fine without a list but it consumes the active select list if there is one when the subroutine EXECUTES the select command. On Mon, Sep 24, 2012 at 2:11 PM, Colin Alfke alfke...@hotmail.com wrote: Kevin; The problem is that the initial list is list 0 so that your execute select uses it - regardless of pass/rtnlist. Like David said you will have to save the list items before your select and then restore it to list 0 when done. Another alternative is to use the unibasic select - which loses any index gains and you have to process the file yourself. I don't use rtn/passlist so I'm not sure why they aren't compiling - but if you're using the TO 2 syntax you shouldn't need them and I don't think they'll help you anyway, but I would be surprised that the compiler would catch the double usage. I've used the initial techniques with existing select lists. How list 0 behaves while it's still building is an interesting test. I would like it to work - but am not really surprised that it doesn't. hth Colin -Original Message- From: Kevin King Sent: September 24, 2012 12:20 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists What I don't understand is why I can't seem to get PASSLIST and RTNLIST to work in BASIC. Seems that's exactly what these are intended to do but they give me nothing but compilation failures. [snip] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:43 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. ___ 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] [UD] LISTUSER output: phantom vs. iphantm
Excellent, thanks Wally! On Fri, Sep 14, 2012 at 9:23 PM, Wally Terhune wterh...@rocketsoftware.comwrote: https://u2tc.rocketsoftware.com/documentation/PDF/1177927.pdf Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, September 14, 2012 8:37 AM To: U2 Users List Subject: Re: [U2] [UD] LISTUSER output: phantom vs. iphantm Is there a definitive list of operations that makes something an iPhantom vs. a phantom? I know about sockets, but presume there is more, right? ___ 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] [UD] LISTUSER output: phantom vs. iphantm
Is there a definitive list of operations that makes something an iPhantom vs. a phantom? I know about sockets, but presume there is more, right? On Fri, Sep 14, 2012 at 1:26 AM, Brian Leach br...@brianleach.co.uk wrote: iPhantoms are any background that perform interactive operations, such as opening a socket or device. They consume a licence. FWIH some time back a couple of naughty sites were buying small numbers of users and opening ttys directly with phantoms so IBM blocked that. Now it catches all of us who legitimately want to make a web service or similar call in the background. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: 13 September 2012 23:32 To: u2-users@listserver.u2ug.org Subject: [U2] [UD] LISTUSER output: phantom vs. iphantm What is the difference between LISTUSER USRTYPEs phantom and iphantm? On our systems, we will have 100 to 200 phantom processes, i.e. background processes, running at any given moment. When I look at them via LISTUSER, they will be split approximately 60/40 between phantom and iphantm. All were started using the PHANTOM verb. I can't discern a difference, and I can't find anything about it in the 7.3 UniData documents. A search for iphantm has no hits. This comes into play because it seems that SYSTEM(514) includes iphantm sessions in the count, but not phantom sessions. We have a monitoring program that warns us if the number of users approaches the configured license limit, and it uses SYSTEM(514). We built in for it to allow for a configurable amount of phantom processes. If phantom processes may or may not be included in SYSTEM(514), our monitor program isn't as accurate as it could be. It seems to me that neither phantom nor iphantm should be included in SYSTEM(514). HELP for SYSTEM(514) states that it returns the number users currently logged in and does not include phantoms. Presumably, this is the number of licenses in use. Do iphantm sessions use a license? UniData 7.3.1 HPUX 11.31 Dean Armbruster Information Technology, System Analyst Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2839 * F: +1 (757) 989 2801 www.ferguson.comhttp://www.wolseley.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] [UD] Determining number of users licensed
Can you parse it out of the listusers OS command? On Wed, Sep 12, 2012 at 2:24 PM, dean.armbrus...@ferguson.com wrote: Is there a way to programmatically determine the number of licensed users allowed? SYSTEM(514) reports the number of non-phantom users currently logged in, which is essentially the number of licenses in use. I want to compare that against the number of users allowed in a monitoring program. I want to know if we're close to the limit before we run out. The number of licenses varies by server. Colleagues have suggested using grep on udtconfig for NUSERS, but that is not the same thing. Since we generally have 100-200 phantom processes, we sometimes configure to a size larger than the license limit to have room for those phantom processes. UniData 7.3.1 HPUX 11.31 Dean Armbruster Information Technology, System Analyst Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2839 * F: +1 (757) 989 2801 www.ferguson.comhttp://www.wolseley.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] [ud] Sub-second delay?
Ah crap, this client is Unidata 6.1 and NAP is not supported. I'm not seeing it in the 7.1 or 7.2 docs either. Looks to be a UV thing, right? On Mon, Aug 27, 2012 at 9:41 AM, David L. Wasylenko d...@pickpro.com wrote: NAP 500 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, August 27, 2012 10:46 AM To: U2 Users List Subject: [U2] [ud] Sub-second delay? Is there anything in Unidata (7.1, in particular) that can do a sub-second delay, like maybe a half second? ___ 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] [ud] Sub-second delay?
Thanks everyone. David, good idea. The original premise was to try to keep a Unidata program from overflowing the AIX spooler, which has a max job # of 999. We were hitting it with a couple thousand documents daily (within a few minutes) and the premise was that if I had a job 615 in the spooler, the next 615 that got generated (round robin) would overwrite the first 615. This has subsequently been disproven, so the delay is less of a concern now. But while I'm here... anyone know how to configure an AIX 5.3 print queue daemon to have longer than 3 character job #'s? -K On Mon, Aug 27, 2012 at 10:48 AM, David L. Wasylenko d...@pickpro.comwrote: If you are trying to unload a heavy processs... how about sleeping one second every 100 records or every 1000 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, August 27, 2012 11:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? How interesting. RQM isn't even in the online help for Universe 10, but it does compile. -Original Message- From: David L. Wasylenko d...@pickpro.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Aug 27, 2012 9:41 am Subject: Re: [U2] [ud] Sub-second delay? Universe only supports an integer for the SLEEP command... Try this in unidata: 001 CRT TIMEDATE() 002 FOR I=1 TO 5 003 SLEEP 0.5 004 NEXT I 005 CRT TIMEDATE() I've no idea if it's supported... but it's worth a shot to test. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, August 27, 2012 11:30 AM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? RQM is still supported by UniData, but it's now merely a synonym for SLEEP. NAP is a UV thing, with millisecond granularity. SLEEP, in both UV and UD, like the *nix sleep command, only counts in whole seconds. Larry Hiscock Western Computer Services RQM was supposed to be merely a command to release quantuum which means to pause until I come back up in the time-slicing round-robin. At some point I wonder if they didn't just replace this with a Sleep 1 but that's not really what it was *supposed* to be. ___ 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 ___ 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] [ud] Sub-second delay?
That's a pretty tight loop Marco. I agree with David, these kinds of tight loops can really negatively impact performance. On Mon, Aug 27, 2012 at 10:59 AM, Marco Antonio Rojas Castro marco_roja...@hotmail.com wrote: H = SYSTEM(12) ;* TIME IN MILISECONDS LOOP H2 = SYSTEM(12) IF H2 - H 500 THEN EXIT ;* 500 MS ELAPSED REPEAT Date: Mon, 27 Aug 2012 10:17:01 -0600 From: ke...@precisonline.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? Ah crap, this client is Unidata 6.1 and NAP is not supported. I'm not seeing it in the 7.1 or 7.2 docs either. Looks to be a UV thing, right? On Mon, Aug 27, 2012 at 9:41 AM, David L. Wasylenko d...@pickpro.com wrote: NAP 500 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, August 27, 2012 10:46 AM To: U2 Users List Subject: [U2] [ud] Sub-second delay? Is there anything in Unidata (7.1, in particular) that can do a sub-second delay, like maybe a half second? ___ 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 ___ 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] MySQL query qestion....
I agree with Brian, a stored procedure or function seems to be the way to go, where you get the value, store it in a variable, and then use the variable in the query. On Thu, Jul 19, 2012 at 10:29 AM, Brian Leach br...@brianleach.co.ukwrote: George It depends on the db type. In SQL Server, for example, you would create a stored procedure that would capture the subquery result to a local variable and use that. e.g. DECLARE @lastUpdate DATETIME; SELECT @lastUpdate = some_expression ; select * from table where last_update @lastUpdate But I don't know with mySQL - it's a bit short on intellect - but I see it has a SELECT .. INTO format for populating a variable. Might be worth a shot. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 19 July 2012 16:56 To: U2 Users Subject: [U2] MySQL query qestion This is specific to MySQL, but could apply to any SQL DB. Is there a way to put the results of one query to be used by another, without having that second query run on each Iteration of the sub query? Example: SELECT * FROM TABLE WHERE LAST_UPDATE (SELECT UPDATE_PROCEDURE()); The function UPDATE_PROCEDURE() returns a timestamp, and then updates itself with a new timestamp. My workaround is: SELECT * FROM TABLE WHERE LAST_UPDATE (SELECT GET_PROCEDURE()); SELECT UPDATE_PROCEDURE(); Here the GET_PROCEDURE() only retrieves a value, and doesn't update it. BUT...if there were half a million records in the TABLE, I'd prefer not to run the GET procedure half a million times To retrieve the same result which could add significant processing time (this would be run for each of the tables I'm mirroring on UV from MySQL . George ___ 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
[U2] Redback port
What TCP/IP port# does Redback typically use? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Redback port
Awesome, thanks! On Thu, Jul 12, 2012 at 1:56 PM, Dan Goble dan.go...@interlinebrands.comwrote: You would need to look in your rgwresp.ini file to see what it is set to. Path to the file is $RBHOME/rgw/conf Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Please notify the sender immediately by e-mail if you have received this e-mail in error and delete all copies of this message. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, July 12, 2012 1:55 PM To: U2 Users List Subject: [U2] Redback port What TCP/IP port# does Redback typically use? ___ 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
[U2] Unidata Limits
I was asked a question today that ... well, it stumped me. Is there a practical limit to an incrementing number on Unidata and if so, what is that limit? I seem to recall something way back on Reality that said that numbers could count to 1+e38 or something ridiculous like that, but is that still applicable? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Runaway Jobs
How are you exiting udt? Are you logging off with EXECUTE 'OFF' or CHAIN 'OFF' in BASIC? Or are you logging off with a proc doing OFF (or LO for that matter)? On Tue, Jun 26, 2012 at 7:05 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: We are having occasional, random issues with runaway processes. We run lots of jobs through cron. We pipe the output for each cron job to a xxx.RESULTS file so that we can review them in case there are any issues. All of our cron jobs do the following: Set the needed environment variables Cd to the desired account Fire up a udt session Execute the desired programs/processes that are fed to it Print a standard FINISHED message Exit UniData (which should then kill the Unix script) For some mysterious reason, random jobs will occasionally keep going. Not only does this eat up the CPU, but the xxx.RESULTS file gets HUGE! Gigs in size! If we look at the contents of the RESULTS file, we see exactly what we would have expected from the script/UniData. It shows that it cleanly executed the off command to terminate the udt session, but it then appears to have carriage returns for millions of rows. In fact, the udt process is still active! Even though we have typed the off command. The RESULTS file will just grow and grow at an alarmingly fast pace until once of us kills the process. It is not consistent in any way that we have determined. It is not the same script getting stuck - it appears random. A script that gets stuck in a runaway status will work just fine the next time it runs. Has anyone experienced this before and if so, what was the solution? We are running: HP-UX Model mbhp7640 version of unix B.11.31 U ia64 bit machine Itantium box Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No ___ 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] Universe/Unidata in the Cloud
for use with the Workgroup Edition, but are limited to a maximum of two (2) CP sessions. Enterprise Edition is offered with two (2) initial Rocket CP sessions with optional additional CP session entitlements available for purchase. ... that might process transactions... This would effectively blow any SaaS or BPaaS option out of the water for a U2 based application. I may be misunderstanding the above, or there may be a different license available somewhere, hence my question. Thank you, Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.net -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: June-02-12 4:04 PM To: U2 Users List Subject: Re: [U2] Universe/Unidata in the Cloud Just so I'm clear... what exactly would be different about such a license? Seems to me the typical licensing terms would work just fine, as long as you have enough seats to handle the traffic. I would, however, be concerned about opening up the telnet port on a cloud architecture. On Fri, Jun 1, 2012 at 6:05 PM, Robert Houben robert.hou...@fwic.net wrote: Does Rocket license Universe or Unidata for use in the cloud? Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.nethttp://www.fwic.net/ LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_ba dge Twitter http://www.twitter.com/fusionwareint FaceBook http://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integra tion-Corp/115116258510923 ___ 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 ___ 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] Universe/Unidata in the Cloud
Just so I'm clear... what exactly would be different about such a license? Seems to me the typical licensing terms would work just fine, as long as you have enough seats to handle the traffic. I would, however, be concerned about opening up the telnet port on a cloud architecture. On Fri, Jun 1, 2012 at 6:05 PM, Robert Houben robert.hou...@fwic.netwrote: Does Rocket license Universe or Unidata for use in the cloud? Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.nethttp://www.fwic.net/ LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_badge Twitter http://www.twitter.com/fusionwareint FaceBook http://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integration-Corp/115116258510923 ___ 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] Monthly Multivalue Inserts and Speed
Certainly the dimensioned array over dynamic would be beneficial in this
situation whenever possible. Unfortunately, this only applies to your
custom code Dave, as the SB+ stuff and the stuff written by Prelude is
going to continue using the dynamic array access. In your custom code, you
might be able to eek out some gains by separating the multivalued fields
you're using out to single attributes, update the single attributes, and
then replace the attributes in the record from the single attribute
variables.
Whether the file is dynamic or static will certainly play a part, with
dynamic files almost always performing worse than static hashed files. In
my opinion [flame suit on] the only reason to use dynamic files in Unidata
is to breach the 2G limit. There is no appreciable performance reason for
using dynamic files, unless of course you simply want the application to
perform worse than it would with a static hashed file. Especially with
split load at 10% - you're going to split the group when it's 10% full of
keys. That said, I can't really think of anything better except to not use
a dynamic file.
-K
On Fri, Jun 1, 2012 at 12:47 PM, David L. Wasylenko d...@pickpro.com wrote:
File size looks small.
Very generic sizing rules:
Pick a modulo of the smaller of these two numbers:
* The item count within the file (731,825)
* The total byte count divided by the group size (2,197,829,057 /
16,384 = 134,144)
Then find a prime number above that, or at least not divisible by 2, 3, 5,
7...
I get 134,147 for a reasonable modulo.
The current mod is 67,907 which is about half the calculated modulo.
50% of your data is in hash-overflow, causing a linear search within each
group at least 50% of the time.
This can be a large part of the issue.
A dimensioned array instead of a dynamic array would help your type of
processing as well.
... david ...
David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 12:09 PM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
FILE.STAT results:
MOD OV HTY ITEMS BYTES MNI/G MXI/G MNB/I MXB/I
67801 0 64 731825 2197829057 02719 14300
---- ---
67801 731825 2197829057
Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
Wasylenko
Sent: Friday, June 01, 2012 12:07 PM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
What's the record count and total byte count?
... david ...
David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 9:41 AM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
Results of the ANALYZE.FILE:
Dynamic File name = WHSE.STAT
Number of groups in file (modulo) = 67801
Minimum groups of file= 67801
Hash type = 0, blocksize = 16384
Split load = 10, Merge load = 5
Split/Merge type = KEYONLY
Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
Wasylenko
Sent: Friday, June 01, 2012 10:32 AM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
3k isn't large.
#1 thing to look at is file size.
Change the file-type to dynamic. It will not give the best performance
compared to monitoring file size of a static file type, but over the
long-term, avoids sizing issues that are the #1 reason for bad performance.
Can you perform an ANALYZE.FILE {filename} and post the result?
... david ...
David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 9:30 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed
I have a file that is taking a very long time to update, seemingly longer
and longer each month. Here is briefly how the attributes are organized, a
relatively simple example:
Attribute 1
Re: [U2] OT: Manners
In our constant debate of which peanut butter tastes more like fresh peanuts, it discouraging when people lose sight f the fact that it really is about the peanut butter, and not an overt attack on people who are allergic to nuts... On Wed, Apr 25, 2012 at 7:16 PM, Danny Ruckel dan...@southwesttraders.comwrote: Well said Don, couldn't agree with you more... Danny Ruckel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, April 25, 2012 5:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] OT: Manners Someone posts a job posting in here and the job poster is belitted? Unbelievable. Since I didn't see anyone else say it, I will say it. Thank you Mr. Butera for posting your employment opportunity at Hamsphire College on our lists, I appreciate it. Regards, Don Verhagen ___ 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] Global Catalog: Universe vs. Unidata
Good info, thanks for the page reference! On Fri, Mar 9, 2012 at 5:51 PM, Wjhonson wjhon...@aol.com wrote: Universe shared memory can bite. The speed improvement is probably not an issue, unless you are truly running a subroutine ten thousand times every hour. -Original Message- From: Charles Stevenson stevenson.c...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Mar 9, 2012 4:48 pm Subject: Re: [U2] Global Catalog: Universe vs. Unidata The concept is similar, but there's an additional step. See UV 11.1 Administering Universe pdF, Chapter 18, UniAdmin pdf, Chapter 16, Managing Catalog Shared Menu. ost UV shops in my experience don't bother with it, but I think it's a ood tool and not difficult to master. cds On 3/9/2012 6:02 PM, Kevin King wrote: On Unidata, globally cataloguing a program causes it to run in a separate memory space so that if 10 users are running the program, only one copy of the routine is loaded into memory. From the docs: Multiple users can run globally cataloged programs simultaneously — UniData brings one copy of the program into shared memory. Is the same true for globally cataloguing on Universe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
[U2] Global Catalog: Universe vs. Unidata
On Unidata, globally cataloguing a program causes it to run in a separate memory space so that if 10 users are running the program, only one copy of the routine is loaded into memory. From the docs: Multiple users can run globally cataloged programs simultaneously — UniData brings one copy of the program into shared memory. Is the same true for globally cataloguing on Universe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ editing question
I've never known it to be enter-able from the keyboard. On Thu, Feb 9, 2012 at 6:02 PM, Lunt, Bruce bl...@shaklee.com wrote: If you mean: ctrl] that doesn't seem to work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, February 09, 2012 4:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SB+ editing question It's not Ctrl-Rightbracket ? -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Thu, Feb 9, 2012 4:57 pm Subject: [U2] SB+ editing question Hi All have a question about what key(s) to enter to insert a value mark when ntering into a field in a screen. The field should probably be changed to ulti-valued from single-valued but this is a generic field that is filled ith data from anywhere in the record to be updated. So, when the ulti-value field is displayed it shows a small 2 between each of the value ositions. What is the keystroke to insert that 2? hanks, ruce __ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ editing question
Use a Process After Screen Accept to change some other character to it. On Thu, Feb 9, 2012 at 6:07 PM, Lunt, Bruce bl...@shaklee.com wrote: Is there another way? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, February 09, 2012 5:03 PM To: U2 Users List Subject: Re: [U2] SB+ editing question I've never known it to be enter-able from the keyboard. On Thu, Feb 9, 2012 at 6:02 PM, Lunt, Bruce bl...@shaklee.com wrote: If you mean: ctrl] that doesn't seem to work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, February 09, 2012 4:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SB+ editing question It's not Ctrl-Rightbracket ? -Original Message- From: Lunt, Bruce bl...@shaklee.com To: u2-users u2-users@listserver.u2ug.org Sent: Thu, Feb 9, 2012 4:57 pm Subject: [U2] SB+ editing question Hi All have a question about what key(s) to enter to insert a value mark when ntering into a field in a screen. The field should probably be changed to ulti-valued from single-valued but this is a generic field that is filled ith data from anywhere in the record to be updated. So, when the ulti-value field is displayed it shows a small 2 between each of the value ositions. What is the keystroke to insert that 2? hanks, ruce __ 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 ___ 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] Building an Excel File
ding ding ding... gentlemen, to your corners... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Including Code - A Best Practice?
An include is fine for declarations, but not for executable code due to the fact that individual lines in the include cannot be debugged (on Unidata). Declarations like EQUates and common blocks are best uses for includes. The need to break apart big routines due to some arbitrary limit (i.e. 32K) is no longer a valid argument and without the ability to debug included code, any gains quickly become lost. On Tue, Feb 7, 2012 at 4:04 PM, Baker Hughes baker.hug...@mouser.comwrote: A friendly discussion arose recently among some U2/MV Developers about whether to include code. If any of you have opinions about the positive aspects or negative aspects of this practice, please respond. Should it be adopted as a best practice, or rejected as special situation use only? Many shops probably include long sections of variable assignments, or perhaps globally opened files. This is pretty much accepted everywhere as a good practice. In question here is the insertion of actual code - business logic or screen I/O programs or code snippets. Maybe you know of methods to overcome some of the obvious downsides: unintended reassignment of local variables, difficulty in debugging, others. What are the positive upsides? Performance gains? What is the longest snippet you think should be included, if allowed? What advantage has included code over a CALL or a Function? Reuse. What else? Can the downsides be mitigated satisfactorily to justify the gains? Thanks so much. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] Including Code - A Best Practice?
I agree with Wols; a subroutine takes more memory and is slower to launch but is so much easier to work with in any sized system. It's funny, our subroutines are oddly similar to how Microsoft implemented DLL wrecknology for Windows, but we've never had the kind of hell that Windows programmers experience. Funny how that works... :) On Tue, Feb 7, 2012 at 5:01 PM, Wols Lists antli...@youngman.org.uk wrote: On 07/02/12 23:46, Kevin King wrote: An include is fine for declarations, but not for executable code due to the fact that individual lines in the include cannot be debugged (on Unidata). Declarations like EQUates and common blocks are best uses for includes. The need to break apart big routines due to some arbitrary limit (i.e. 32K) is no longer a valid argument and without the ability to debug included code, any gains quickly become lost. Plus, what happens if you ever want to update that code? If it's INCLUDEd in twenty different files, you need to recompile the lot - that is if you even know what files include it! (And don't say you can search, you're quite likely to miss something). If it's a subroutine, you know one recompile and you've caught all instances. Cheers, Wol ___ 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] Building an Excel File
The CSV format is really pretty simple. Commas between fields. If a field contains a comma or quote it should be quoted. If a field contains a quote the quote should be doubled. Will is right that you have to use a character-stepping algorithm to parse it properly. But with these two rules in mind it's not hard to build. On Mon, Feb 6, 2012 at 4:46 PM, Wjhonson wjhon...@aol.com wrote: Commas embedded in text data should not be an issue for csv files. It's just an issue for those programmers who aren't using char-stepping routines to parse the data. You have to step char by char, not field by field as the state transition matrix is defined to parse only on strings quoted on both sides. Unfortunately programmers do things their own way and blame the format. The long and short is, the Iphone's built in viewer can handle embedded commas without any problem in the rendering, since we have them embedded in some fields as well and the rendering is not corrupted by that. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Feb 6, 2012 3:27 pm Subject: Re: [U2] Building an Excel File I have always tried to avoid csv files because we have all kinds of characters n our descriptions (commas, double and single quotes, etc.) It is also very asy to build a row of data with 254 delimiters, then simply convert @FMs to abs. That being said, do you have a good subroutine to build csv rows that will not et confused with commas or quotes in the data? I am willing to give this a ry. John Israel Sent from my iPhone On Feb 6, 2012, at 5:28 PM, Wjhonson wjhon...@aol.com wrote: Rebuild the files as csv files and they will open on the Iphone without any urther intervention This is what we do. ohn Israel enior ERP Developer Dayton Superior Corporation 125 Byers Rd Miamisburg, OH 45342 ffice: 937-866-0711 x44380 ax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the ntended recipient(s) and may contain information that is privileged, onfidential or proprietary. If you are not an intended recipient, please notify he sender, and then please delete and destroy all copies and attachments, and e advised that any review or dissemination of, or the taking of any action in eliance on, the information contained in or attached to this message is rohibited. Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Feb 6, 2012 2:25 pm Subject: Re: [U2] Building an Excel File No, the Smart Phones can not open the XML at all. The txt and xls files can e pened, but they are just text. Managers want to be able to read the files leanly. I am guessing the issue is that when a smart phone opens a true Excel file, it s not running Excel, but some sort of emulator. The emulator does not have ll he bells and whistles that a full blown version of Excel has, thus undesirable esults. John -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] n Behalf Of George Gallen ent: Monday, February 06, 2012 4:45 PM o: U2 Users List ubject: Re: [U2] Building an Excel File Can they open an XML file coded for Excel, but without formatting and colors nd uch? f so, you may just have to have two files produced, one for the phones and one or desktops. I haven't checked, but are there any perl modules that can convert an XML file o an .xls file This would require unix, but not any user intervention. -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] n Behalf Of Israel, John R. ent: Monday, February 06, 2012 4:40 PM o: 'U2 Users List' ubject: [U2] Building an Excel File We are running UniData on a UNIX platform. We create tab-delimited txt files and tab delimited txt files with xls extensions) all the time that users open ith Excel. Many of these jobs are run in the middle of the night or in a rigger program. In all cases, there is no direct user interaction building hese files. We also have some XML files that are coded so that Excel opens them with ormatting, colors, filters, etc. Unfortunately, our BB users and iPhone users can not open these files up in a eaningful way. Is there a way to build a TRUE Excel file without any user intervention from niData or UNIX? John John Israel enior ERP Developer Dayton Superior Corporation 125 Byers Rd Miamisburg, OH 45342 ffice: 937-866-0711 x44380 ax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the ntended recipient(s) and may contain information that is privileged, onfidential or proprietary. If you are
Re: [U2] UniVerse Import XML data [not-secure]
I agree with Brian, the documentation is atrocious. If one follows the examples in the documentation, shouldn't *something *work? But not so with the XDOM stuff. Awful, awful docs. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.2.8 Printer Anomaly
Thanks for the input guys, appreciate it. Tom, thanks for posting that link; I had forgotten about that one, but I suspect it's a different situation than what I'm seeing here. In that case the printer wasn't being assigned when it should; in this case the PRINTER OFF in Unidata appears to be doing a PRINTER CLOSE but only if it's following the SETPTR/SP.CLOSE combination and *only* if there's been an EXECUTE after the PRINTER OFF. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 7.2.8 Printer Anomaly
I have a client running an SB+ application who has been experiencing a very strange issue with Unidata 7.2.8. The situation is a little complex, but let me try to explain. We have this program that issues this SETPTR command and then captures the hold file number: SETPTR 0,132,66,0,0,3,NFMT,NHEAD,BANNER UNIQUE,BRIEF,OPEN This hold file is then generated and once it has been closed with: PRINTER OFF PRINTER CLOSE EXECUTE 'SP.CLOSE' ... the hold file is picked up and sent to a forms processor (Unform) for formatting, barcodes, and release to a specific printer. All this is working just fine by itself. Following this (within the same SB+ login session), if the client runs any report (written in BASIC or SB+ /RD), the PCL for the report and the report content are sent to the printer in two separate spooler files, but only for the first run. The printer receives the PCL document, sets up the printer, then there's nothing after that so it resets the printer, the next job prints without the PCL header and the fonts are the printer default rather than what was requested by the PCL. If the report is run a second time, the PCL and content are output to the same spooler file and the report prints with the correct font. If the customer drops to the colon TCL prompt between the first report and the second, the second report prints to a single hold file without any problems. We have traced this to the following: a) The subroutine that prints the report calls another subroutine that calls SH.PRINT.MANAGER which does a PRINTER ON, sends the PCL at the start of the job, and then PRINTER OFF (but no PRINTER CLOSE). This subroutine then issues a PRINTER ON for the coming report. The parameters sent into SH.PRINT,MANAGER basically cause the printer select window to be displayed where the printer and options can be selected. b) Back in the main subroutine, an EXECUTE 'GET-LIST something*' *is executed. c) The program then processes the records and prints the output. When the first PRINT statement occurs, a second spooler entry is opened. Now here's where it gets weird. If that first report with the SETPTR/SP.CLOSE combination is not run immediately before the second report, the second report will print to a single spooler file as expected. Also, if the main program does not issue the EXECUTE command - any EXECUTE command (I've tried several) - the PCL and content are output in the same spooler file. Note that the EXECUTE is happening after the PRINTER ON, though I have tried a PRINTER OFF before the EXECUTE with a PRINTER ON after it with the exact same (2 spooler file) result. I have also tried temporarily relocating the PRINTER ON to follow the EXECUTE, and it still creates two spooler files. The subroutine that is being called from this report program is a vendor-written routine that is literally called from all over the system. We have no ability to change this routine (other than for limited testing), at least not without impacting dozens if not hundreds of reports that use this routine. Besides, the routine itself doesn't seem to have any issue. Rather, the problem comes when there is a PRINTER ON followed by a PRINTER OFF followed by another PRINTER ON, but *only* if that original SETPTR/SP.CLOSE command was used to capture the hold file immediately prior to running any report. I've checked SETPTR at various stages of this testing and have found that the SETPTR settings when it works (generating a single spooler file) is identical to the SETPTR settings when it doesn't (generating two printer files). Furthermore, the SETPTR settings when running the second report alone, without running this other one first, are identical to the settings if the SETPTR/SP.CLOSE report is run first. So if you've stuck with me for this long, please allow me to ask a couple of direct questions: * What is SP.CLOSE *really* doing? * Could it be that the original SETPTR or SP.CLOSE command is setting some flag somewhere in memory that is causing the next PRINTER OFF (i.e. the one in SH.PRINT.MANAGER that outputs the PCL) to implicitly do a PRINTER CLOSE? Any input or assistance would be most appreciated. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Corrupted compiled code
This is a long shot, but Wally's mention of malloc made me wonder... could there be any software (virus checking or otherwise) that's working on memory objects, not disk files? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Corrupted compiled code
I've seen a similar thing happen on UV with catalog pointers that just stop working, but never on UD. I wonder if there's some virus control software on the server that might be fixing the object somehow? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TAB.TO.UNIVERSE
+1 for what David said. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1 Unresponsive UO Connection
Will, Tony, John, Symeon, etc., I agree with all of it except for the part that seems to trigger an ongoing conflict between Will and Tony. Agree to disagree my brothers, and let us work together for the common good. There is nothing proprietary or even all that clever about this approach. It was an approach borne out of necessity and may provide a foundation for others to build upon and do something really incredible. This is why I'm writing it up for the magazine. My goal is to get some folks thinking, give some options to folks who may feel they have none (which is how I felt going into this), and hopefully spur everyone on to be more involved with the web (and mobile technology). And for those who can make it to Spectrum in April, please look me up and let's get a group think going to really dig into this topic. If we have enough folks interested, Nathan might even give us a room (cage?) just to debate our respective positions! :) On Fri, Dec 2, 2011 at 5:18 PM, Wjhonson wjhon...@aol.com wrote: Or the model could be, better instructions But Tony we've had this conversation before. I'd like to give the power directly into the hands of the public. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 2, 2011 3:37 pm Subject: Re: [U2] Unidata 7.1 Unresponsive UO Connection I smell a troll, here and in your other posts today. As I've aid here before, it's not about getting smarter - we pay for free software with time or with money. Invest some time to earn how things work. If you make the choice not to do that, ou are free to pay someone (who has made the investment) to each you or to implement for you. That's the model. If you on't get it, that's unfortunate, but there's not much more nyone can say to help. Next topic... T From: Wjhonson The problem I see is that telling people that they could make free beer, is quite different in practice from making free beer. I know that Tony feels like people should just get smarter, but I'm not the only one who has pointed out that there simply are no good install manuals for any of the various free options. Yes there are installation instructions, but they quickly spiral off into the level of geek speak that you have to already know, in order to understand. At which point most people give up. ___ 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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1 Unresponsive UO Connection
John's description of the two Apache method was spot on as was his description of my rationale for coming up with it: I think Kevin's goals in this scenario above, were to keep it simple, and make it cross platform, while still getting good performance. Having waited YEARS for a PHP connector into U2, I finally got tired of waiting. This notion that the vendor (and I mean ANY vendor, myself included) is the commander of all solutions and we the community should just wait patiently for whatever is handed down, well, that's as outdated as most MV licensing models or party-based political systems. Note that I'm making no claims about the two Apache method except that it demonstrates we have the ability today to connect to U2, QM, and I suspect (but have not proven) other MV databases. It is hopefully a foundation that we as a community can build upon and improve Multivalue's visibility in the connected world. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1 Unresponsive UO Connection
Not focusing on connection pooling at this point but that may be a consideration for the future. I've found that the overhead of the two Apache method is so small that most of the gains offered by connection pooling are minimized. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1 Unresponsive UO Connection
Symeon, I'm working on an article series for Spectrum that over the next three installments will be writing a general purpose web connector using a little bit of PHP, a little bit of BASIC, and a couple of Apache instances. I'm also speaking at the Spectrum conference in April on the same topic. Perhaps this could be of some use for you with your current traffic level? In our tests we can get a lot more throughput through this connector than we ever could with UO. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1 Unresponsive UO Connection
Twice a day? Holy crap, what version of Unidata is that on? On Nov 26, 2011 11:59 AM, Symeon Breen syme...@gmail.com wrote: Yes - we have to do this at least twice a day Do showud - one of the processes is the unirpcd process, do a kill -9 on this process to kill it , then do startunirpcd -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: 26 November 2011 15:11 To: U2 Users List Subject: Re: [U2] Unidata 7.1 Unresponsive UO Connection Way late I guess... But on uv you can do this by logging in as root... Go into the UV home account and use the menu to restart rpc daemon. On 11/25/11, dean.armbrus...@ferguson.com dean.armbrus...@ferguson.com wrote: I am not certain about AIX, we run on hpux, but I believe unirpcd can be restarted on AIX also. We do it occasionally for just the symptoms you describe a few times a year. From a system prompt stopunirpcd startunirpcd The rest of UniData keeps on running fine. No disruption. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, November 25, 2011 1:46 PM To: U2 Users List Subject: [U2] Unidata 7.1 Unresponsive UO Connection I have a Unidata system (7.1.16) on AIX 5.3 where Uniobjects just stopped responding. I've rebooted the client running UO with no resolution to the problem and am suspecting that perhaps the unirpcd daemon on the server might need to be restarted. Can this service be restarted on an AIX system without a full shutdown of Unidata? If so, how? -- -Kevin http://www.PrecisOnline.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 -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1411 / Virus Database: 2092/4039 - Release Date: 11/25/11 ___ 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] Unidata 7.1 Unresponsive UO Connection
I have a Unidata system (7.1.16) on AIX 5.3 where Uniobjects just stopped responding. I've rebooted the client running UO with no resolution to the problem and am suspecting that perhaps the unirpcd daemon on the server might need to be restarted. Can this service be restarted on an AIX system without a full shutdown of Unidata? If so, how? -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Old tricks for old dogs
Or how about: TOTAL.PAGES = INT(KEY.COUNT / 5) + (MOD(KEY.CNT,5) NE 0) Yours is more brief but that -1 threw me (mentally) for a moment. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData AIX commands for commands like LIST.READU and LIST.QUEUE?
Ah, good thinking. Thanks for the tip! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE?
Are there AIX equivalent commands for the following Unidata TCL commands: PORT.STATUS LIST.READU LIST.QUEUE LLOCKS Also, is there any AIX command that will show that a particular telnet session is no longer active (i.e. user X'd out incorrectly or network dropped them)? -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE?
My apologies on the LLOCKS; Steve's right, that's a Prelude-ism. And while I could write a script to start up udt, the problem here is that if all of the udt licenses are in use, there's no way to get this kind of information in AIX to figure out what might be going on with the system (i.e. a deadlock). And PORT.STATUS is definitely not the same as ps; while both have their place, I'm not entirely certain how I would get the CALL.STACK option from PORT.STATUS out of ps. Jeff, if you have a solution for that one, I'm all ears. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?
To followup to what Tony said, we do this with PHP by creating a JSON-formatted extract out of Unidata, then ftp it to the other system, then use Apache to kick off a job to post the file into MySQL and PostgreSQL. Works like a champ for small to medium data sets. For large datasets we do something significantly more complicated using triggers and a publisher that publishes changes to the Unidata files using the callHTTP interface to send data to a PHP script running on Apache. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Rocket Authorization Page
Is anyone able to access https://u2tc.rocketsoftware.com/ today? -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket Authorization Page
Oh well, I'll have to authorize my new licenses tomorrow. Glad this isn't a crisis situation. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket Authorization Page
Thanks Wally. I wonder, however, if you weren't watching the list, how would one know this information? This is not a crisis for me, but I wonder how I would have known that information - other than posting here and getting your response - if it was? On Sun, Sep 18, 2011 at 8:35 PM, Wally Terhune wterh...@rocketsoftware.comwrote: If it is a crisis, call the U2 Support 800-729-3553 number. It is manned 7/24 - either by Follow-the-Sun or pager. You can always get authorized - regardless of the situation of the web server. You always have at least 10 days after installation to run before you must get the server license authorized. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Sunday, September 18, 2011 8:21 PM To: U2 Users List Subject: Re: [U2] Rocket Authorization Page Oh well, I'll have to authorize my new licenses tomorrow. Glad this isn't a crisis situation. -Kevin http://www.PrecisOnline.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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.22 Index Issue
Thanks Wally. In this situation we suspect that the index was rebuilt while some users had the file open (via SB+ cached file buffers) and those users were the ones entering transactions that didn't get updated into the index. We logged everyone off last night and rebuilt the index and so far today things appear to be better. On Fri, Sep 9, 2011 at 6:30 AM, Wally Terhune wterh...@rocketsoftware.comwrote: Kevin: The things you need to review: 1) LIST.INDEX WO ALL DETAIL - to examine the index definitions and details of keys in the file 2) From the shell, without the file being updated: guide_ndx -x3,all WO Review the output file GUIDE_XERROR.LIS for physical or logical corruption 3) UDT.OPTIONS active (per Mecki's comment about leading 0s) Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 9:09 PM To: U2 Users List Subject: Re: [U2] Unidata 7.1.22 Index Issue What can I get you Wally? We did a CREATE.INDEX WO SHOP.CODE NO.NULLS followed by BUILD.INDEX WO SHOP.CODE. The index seems to work fine immediately after. If the shop code in the record changes, however, the index does not seem to reflect the change. This is evidenced by: DISABLE INDEX WO SELECT WO WITH SHOP.CODE = 09 21 items selected CLEARSELECT ENABLE.INDEX WO SELECT WO WITH SHOP.CODE = 09 19 items selected CLEARSELECT DISABLE.INDEX WO SELECT WO WITH SHOP.CODE = 09 21 items selected What else can I get you? On Thu, Sep 8, 2011 at 5:58 PM, Wally Terhune wterh...@rocketsoftware.comwrote: Not enough information. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 5:42 PM To: U2 Users List Subject: [U2] Unidata 7.1.22 Index Issue We have a customer on Unidata 7.1.22 running the Prelude application. They have an index on a field in a file that looks like this: Top of SHOP.CODE in DICT WO, 9 lines, 82 characters. *--: P 001: V 002: EXTRACT(@RECORD,110,2,0) 003: 004: Shop Code 005: 2L 006: S 007: 008: SHOP.CODEýýEXTRACT(@RECORD,110,2,0) 009: WO Bottom. Because this field is extracting from @RECORD, we should be able to index it without problems, right? However, the reality is starkly different. The other data indexes work fine, but this derived index does not seem to be getting updated properly. -Kevin http://www.PrecisOnline.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 -- -Kevin http://www.PrecisOnline.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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.22 Index Issue
Am I understanding you correctly Wally that if an index becomes corrupted for any reason the index is to be deleted, then recreated, and THEN rebuilt? And in a related question, am I understanding you to say that an index cannot (should not) be rebuilt without being deleted and recreated? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Lock Status
Is there anything in Unidata that would report the line of code that set a particular record lock? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
That's useful for determining where that port is, but we have a process leaving rogue locks lying around. Anything that tells what updated the lock table? On Thu, Sep 8, 2011 at 9:10 AM, Daniel McGrath dmcgr...@rocketsoftware.comwrote: Once you know the pid of the program with the lock, you can use PORT.STATUS to determine this. You just need to use the CALL.STACK option. IIRC (It's been a few months) it would be like: PORT.STATUS PID the progs pid here CALL.STACK Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 9:06 AM To: U2 Users List Subject: [U2] Lock Status Is there anything in Unidata that would report the line of code that set a particular record lock? -Kevin http://www.PrecisOnline.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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
Dave: Two Words: Vendor App. Good idea, but not possible in this case. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
Unfortunately, no love there either John. I even went to the GETREADU( .. ) function in BASIC.. nothing there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
Kudos for the novel ideas Dan! However, in this case we're trying to track down a program that left a lock. And being an SB+ application, a lot of stuff runs under the same PID. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
Yes, Steve, but being an SB+ application... the program never stops completely until the person logs off. Meanwhile, they end up dragging mines.. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
We do suspect it is from a custom BASIC subroutine, recently installed. So knowing the file we're looking back through any code that was compiled within the past 2 weeks and manually searching for READU's that don't WRITE, DELETE, or RELEASE. Sure would be nice if the lock table would report the line of code that set the lock. Just sayin'. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
Thank you goes out to everyone for the input. We were able to identify (and as of this moment it would appear correct) a couple of suspects by looking at the code that had been compiled within the last 2 weeks and evaluating each routine separately. I still think it'd be cool to be able to see which program set which locks retrospectively, though I completely understand Wally's perspective about the effort involved to make that happen. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 7.1.22 Index Issue
We have a customer on Unidata 7.1.22 running the Prelude application. They have an index on a field in a file that looks like this: Top of SHOP.CODE in DICT WO, 9 lines, 82 characters. *--: P 001: V 002: EXTRACT(@RECORD,110,2,0) 003: 004: Shop Code 005: 2L 006: S 007: 008: SHOP.CODEýýEXTRACT(@RECORD,110,2,0) 009: WO Bottom. Because this field is extracting from @RECORD, we should be able to index it without problems, right? However, the reality is starkly different. The other data indexes work fine, but this derived index does not seem to be getting updated properly. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.22 Index Issue
What can I get you Wally? We did a CREATE.INDEX WO SHOP.CODE NO.NULLS followed by BUILD.INDEX WO SHOP.CODE. The index seems to work fine immediately after. If the shop code in the record changes, however, the index does not seem to reflect the change. This is evidenced by: DISABLE INDEX WO SELECT WO WITH SHOP.CODE = 09 21 items selected CLEARSELECT ENABLE.INDEX WO SELECT WO WITH SHOP.CODE = 09 19 items selected CLEARSELECT DISABLE.INDEX WO SELECT WO WITH SHOP.CODE = 09 21 items selected What else can I get you? On Thu, Sep 8, 2011 at 5:58 PM, Wally Terhune wterh...@rocketsoftware.comwrote: Not enough information. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, September 08, 2011 5:42 PM To: U2 Users List Subject: [U2] Unidata 7.1.22 Index Issue We have a customer on Unidata 7.1.22 running the Prelude application. They have an index on a field in a file that looks like this: Top of SHOP.CODE in DICT WO, 9 lines, 82 characters. *--: P 001: V 002: EXTRACT(@RECORD,110,2,0) 003: 004: Shop Code 005: 2L 006: S 007: 008: SHOP.CODEýýEXTRACT(@RECORD,110,2,0) 009: WO Bottom. Because this field is extracting from @RECORD, we should be able to index it without problems, right? However, the reality is starkly different. The other data indexes work fine, but this derived index does not seem to be getting updated properly. -Kevin http://www.PrecisOnline.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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job won't run
I agree on checking permissions on the executable. That aside have you
considered adding a EXECUTE COMO ON TEST or something similar to the top
of the program to capture any output it might be producing?
On Fri, Aug 5, 2011 at 10:23 AM, Dan Fitzgerald dangf...@hotmail.comwrote:
And it _does_ get past the udt program; i.e., it actually sends the file,
and updates the log?
I'd look at lsuser for the id running the ud program, and the permissions
on the program executable. I'd take a direct look at the user and program
groups; maybe an admin somewhere changed the user's group list, or someone
recompiled the ud pgm changed ownership, ...
You're sure that it doesn't even get into the ud program? Could it be
trying to open a file that it can't for some reason (again, a group change
would do this) near the top of the program (or trying to execute a sub,
etc), then exiting the program, returning to the script before it clears the
old file?
To: u2-users@listserver.u2ug.org
From: charles_shaf...@ntn-bower.com
Date: Fri, 5 Aug 2011 11:04:08 -0500
Subject: Re: [U2] Job won't run
George
Since you say it's sending the same file each day, then it's not
just the Unibasic that is not running, the rm isn't working either,
otherwise, you would be sending a blank file over and over.
The remove and touch affect the log file. The data file is cleared in
the
program. Since the program doesn't execute, the file doesn't change.
* Clear the output file
OUTPUT = /NTN/DATA/CORPORATE/FILES_AS400/BOWER_FPO
PCPERFORM rm :OUTPUT
PCPERFORM touch :OUTPUT
How are you running this script from the AS400? rsh? If so, has
The actual command on the AS400 is:
RUNRMTCMD CMD('/NTN/DATA/CORPORATE/PROCESSES/fpo_as400')
RMTLOCNAME('xx.xxx.xxx.xx' *IP) RMTUSER() RMTPWD()
I looked into this one time and the AS400 is running an rsh underneath.
has the user that running it on the AS400 changed?
They say no and I believe them because it would have affecteed many jobs.
This is Redhat and the default shell is bsh. We run lots of ksh scripts
on it. They were ported over from Tru64 many years ago.
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
George Gallen ggal...@wyanokegroup.com
Sent by: u2-users-boun...@listserver.u2ug.org
08/05/2011 10:34 AM
Please respond to U2 Users List
To: U2 Users List u2-users@listserver.u2ug.org
cc:
Subject:Re: [U2] Job won't run
Since you say it's sending the same file each day, then it's not
just the Unibasic that is not running, the rm isn't working either,
otherwise, you would be sending a blank file over and over.
How are you running this script from the AS400? rsh? If so, has
the user that running it on the AS400 changed? Could they be logging
in under the C Shell? I don't know if Korn scripts will run under csh,
never really tried it.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Friday, August 05, 2011 11:27 AM
To: U2 Users List
Subject: [U2] Job won't run
I have run into something I have never seen before. We exchange a lot
of
data with an AS400 in Chicago. For many years we have taken the
approach
that the AS400 would submit a job to our UNIX box that would run a
script.
Many of the scripts run a Unibasic program and send the resulting file
back to the AS400. This happens several times a day and we have been
doing this for many years.
One job has started doing something odd. It runs the script and
transfers
the file, but never runs the Unibasic program, so it has been resending
an
old version of the file. This seems to have started happening 3 days
ago.
I can log in manually using the same credentials as the remote job,
and
run the script by typing it in at the command line. It runs perfectly.
Unibasic program runs, new file is sent to the AS400. There is joy.
I have checked permissions. Nothing has changed at the AS400 end.
Nothing
has changed here. (That we know of). I have rechecked the code of he
script and the Unibasic program. Looks good. I am stumped. Here is
the
script code.
#!/usr/bin/ksh
#Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO
LOG=/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG
rm $LOG
touch $LOG
cd /NTN/DATA/CORPORATE
echo `date` Extracting Firm Planned Orders to BOWER_FPO $LOG
$UDTBIN/udtEOD$LOG
RUN GD-BPGM EXTRACT_FPO -N
bye
EOD
echo Sending Firm Planned Orders to AS400 730 $LOG
/usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO
echo `date` Finished sending Firm Planned Orders $LOG
This runs perfectly when run from CL, but not when submitted from the
AS400. And ideas?
Re: [U2] AIX uname and Redback
Tony, are you sure Redback isn't setting some $PATH that's running something other than the AIX uname (/usr/bin/uname)? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SOAP Header
I'm confused. Exactly what is setting the Host: http header in the SOAP request? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JSON
And those kinds of relationships (as Rex pointed out) can be a beautiful thing. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JSON
At the risk of correcting Doug, if this is your input:
TEST
part1this/part1
part2is/part2
part3a/part3
part4 vm=1mv/part4
part4 vm=2test/part4
/TEST
...in JSON there could be represented a few different ways. It could be as
simple as:
[this,is,a,[mv,test]]
Or as complex as:
{TEST:{part1:this,part2:is,part3:a,part4:[mv,test]}
..or even..
{TEST:{part1:this,part2:is,part3:a,part4:{vm1:mv,vm2:test]}
...or other variations as agreed upon by sender and receiver. For MV, a
simple nested array or a simple name/value object can work beautifully.
The point is that there are several options for how the values are presented
and that flexibility can be a wonderful thing.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JSON
Ah drat, I knew I should have validated before posting. That's what
confidence'll get ya.. :)
The first one was valid. The second is missing a } at the end, and the
third one should have ended in }}} instead of ]}.
Regarding this:
[{IdCode:178,CusName:U2Logic,ContactName:[[David Aitken],[Doug
Averch],[Ed Karlo]]}]
I'm wondering why the names are in nested arrays instead of a single array
with three names?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Why Pick U2 ?
I'm a fan of U2 - MV in general even. But in this case I have to agree with Rob: We really need to quantify what it means to win otherwise the words do little more than tickle an emotional response. Having had some time with several MV systems as well as several SQL systems, there are areas of each that in a head-to-head comparison, one would win over the other based on price, performance, flexibility, scalability, and reliability. And it's not always U2/MV and it's not always SQL. For getting right to work without extensive tuning, I'd say U2 holds the upper hand. In terms of indexing and application of multiple indexes to queries, I'd put PostgreSQL over MySQL and both over U2. For clustering, Oracle. For the GUI, SQL Server. For that matter, I'd rank the flexibility of triggers in Unidata over triggers in Universe, and they're both MV. So it's a complex task to assign a winner carte blanche without looking deeply into the eyes of specific areas of the products and their applicability to specific problems to be solved. My personal opinion is that there are benefits to all of it. So in that way picking a winner really doesn't do much more than polarize. I know if I were creating an application from scratch today, the criteria I might use to make the decision would be different from anyone else making the same decision even if it were the same application. There is better and there is worse but all of it must be considered in the larger context of the problem to be solved to mean anything at all. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Why Pick U2 ?
+1 for what David said. Yes, there's the limitation that BASIC is the only native supported language (not factoring external connectors), but as a language native to the environment, this BASIC is really pretty rich by comparison to the stored procedure languages of other DBs. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record Locks - How long should they last for? (Opinion)
Tony, wouldn't READL in Unidata count? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record Locks - How long should they last for? (Opinion)
Ah... thank you for clarifying - and gently at that! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Convert to Numeric
What does A26S.GET.GLS.INFO line 212 say? Yes, you can force values numeric but at what expense? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about updating customer's systems...
We typically recommend that customers have at minimum two accounts, a test account and a live account which are virtually identical and share nothing. This allows us to install to the test account and have them test the code and then we take the same ravel files and roll it up to their production environment. For those customers where we develop on their system, we also recommend having a development account separate from the other two. We then roll from DEV - TEST - production. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Installing UniObjects on Windows 2008 64 bit
Were you logged in as an administrator when you installed UO? We have UO installed on our Windows 2008 R2 64 server with no problem, and I don't recall that we had any problems when it was installed. I do not, however, recall what version of UO it was. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uv 2 ud
I for one am absolutely blown away at the price/performance of QM. Just getting started with it here but looking forward to seeing how far I can push this. On Tue, May 31, 2011 at 12:21 PM, Bob McGrath b...@rm-consulting.biz wrote: Symeon Breen symeonb at gmail.com writes: Under these circumstances, another alternative is to migrate to OpenQM, which is very mature, low cost, and very feature rich. bobm... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
Symeon said For mobile dev i think the way forward for many is html5 and css3. I wholeheartedly agree. While the bragging rights may be different for creating a webapp vs. a true mobile app in Java, C, etc., the features, portability, and maintainability available today with frameworks like jQuery Mobile are just astounding. And the price ain't bad either. Then again, being able to create a respectable mobile webapp with nothing more than a simple editor is all so... Multivalue. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
I'm interested to know more about how folks are using UOJ with PHP. I've tried making that connection numerous times but .. just haven't been successful yet. Big fan of PHP but using the UO connection on Windows is ... less than optimal for my needs. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error 4 22 from PHP exec of uv on AIX
When John and I were working on this we noticed that the LDR_CNTRL
environment variable wasn't set at all on a normal telnet login. When we
DID set it manually on the telnet session, Universe wouldn't start with the
4 22 message. So the simplest version the script was basically like this
(and forgive me as I'm reciting from memory):
?php
$current = getenv('LDR_CNTRL');
putenv('LDR_CNTRL=');
exec('/u1/uv/bin/uv');
putenv('LDR_CNTRL=' . $current);
?
John has been working on this more after we got this far so I'll defer to
him for more details. Note that all this script was proving was the ability
to start UV successfully from a PHP script invoked through Apache. There is
more going on with moving data in and out of UV using JSON, which allows
massive amounts of structured data to be moved into and out of the
environment.
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye... Reasons not to say goodbye.
For me the issue comes down to all the free stuff out there just ripe for the pickin'. Integrating any of the Google APIs (Google Charts is a pretty cool API, actually) is easy to do in web programming but is not likely to be something we'll see in SBClient. Maybe with SB/XA they'll do something like that, but XA has its own issues to grow through first. With our database abilities and all this amazing free UI stuff out there, we could conquer the world! But will we? THAT's the question. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Maybe it's just me, but I put the web interfaces in between the speed of a character based app (truly the most speedy) and a GUI app (which may be much less so). GUI may be pretty but WOW how it has slowed down the speed of data entry. With web-based entry, I feel we're finally moving back towards the right direction in terms of performance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Allen, I believe it's possible but for one significant stumbling block: threads. And given that we're not likely to get native thread support in U2, I think closely integrating U2 into something like Apache (which does support threading) could be a Very Good Thing. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
I'm with Symeon, if this were Facebook I'd like George Land's comment. But that brings me to my point: We need to be the ones creating the next Facebook or whatever that is. Until our applications fully embrace web technology as a primary infrastructure instead of a bolt-on to green screen applications, we'll always be thought of as old school. The only thing that I see holding us back is the maturity of our connectivity options, and fortunately, there is some attention being given to that issue. The question that remains is whether the lot of us can break out of a lifetime of green-screen mentality to embrace and thrive in this brave new world? And as to dot-net... why complicate the hell out of a good thing like the web? :) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Brian, I respect your disagreement, and - to a point - disagree with it. You are correct we have a plethora of connectivity options, but I disagree that UO is the best connector bar none. You are coming from Universe, I am coming from Unidata, and from Unidata, UO has historically been a mess, especially the delay on first connect issue. Maybe these issues are being corrected/updated/improved, but I haven't seen it yet. And perhaps UV works better with UO than Unidata? Regarding the XML tools in Unidata, again, it's a mess - at least in terms of the XDom. You can force it to work by horking up the namespaces in the XML, but even following the examples in the documentation results in utter failure a lot of times. Much attention is given to the dot-net crowd, and I don't disparage that in the least but what about us in the PHP and Python camp? Whether the vendors wish to admit it or not, there is an ever expanding world beyond the walls of Microsoft wrecknologies, or even Java for that matter. So yes, our future is largely the product of our ambition, but I disagree that we have the best connectors available. -K On Tue, Apr 26, 2011 at 2:38 PM, Brian Leach br...@brianleach.co.uk wrote: Kevin The only thing that I see holding us back is the maturity of our connectivity options It's not often I disagree with you, but here I must.. We don't lack mature interfaces. We have UO.Net; UOJ; web services - now both XML and JSON; WebDE - not to mention third party alternatives. Without even mentioning OleDb, ODBC, JDBC, ADO.Net .. I've been programming Windows since before Microsoft bought VB, most of my work is in Windows or Web and I earn my crust on both U2 and SQL Server. In my limited time I've used VB, Delphi, C#, PHP, ASP, ASP.NET and even java - urgh - all with U2. With that in mind I have to say that UniObjects is the best API I have ever worked with, bar none. It offers a clean, fast interface that other models just can't compete with and for any business logic the U2 subroutine is king. Give me U2 basic and UO or WebDE over the likes of ADO.NET and SQL any day, however you dress it up. There is no reason other than lack of ambition for U2 applications to look old. The technology is there, and has been there for a decade. Let's stop talking it down. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
John, just spent a couple minutes on the site. Nice job! Isn't jQuery just amazing? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very Weird Trigger Behavior
Shaun, have you checked the trigger code on that file? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Karl, I never knew thee, but I wish you the absolute best. Whatever your career takes you, own your future! -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData memory errors
Have you looked at any of the log files that it's naming? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
Unidata or Universe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does anyone have an MV BASIC cheatsheet?
I never made much money from writing and selling the SB+ Solutions book, but the good will of being the guy who wrote the book has been priceless in keeping me working since. Then again, I never set out to write a book. Like most things, the book - and nearly everything to follow - has been a serendipitous accident. Hoping for another one sometime. :) -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata bit depth
Is there any command in Unidata that will show the bit depth of the Unidata executable (on AIX, preferably)? -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata bit depth
You know, like 32-bit vs. 64-bit? And perhaps it is I who is being ignorant; if a system is 64-bit AIX does that mean that it's running 64-bit Unidata? And does 64-bit Unidata get past the 2G file size limitations of 32-bit? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata bit depth
So what's the added value of a 64-bit Unidata? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] HMAC SHA256
I know you said you didn't want to use PHP but there's a simple function (hash_hmac) in PHP to generate the value; should be simple enough to send values in and get values back out through a OS level PHP call, if UV won't do it natively. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does anyone have an MV BASIC cheatsheet?
Didn't Malcolm have this at one time? On Wed, Mar 23, 2011 at 2:15 PM, George Gallen ggal...@wyanokegroup.comwrote: Wasn't there something inside the old D3 pick basic manual cover? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, March 23, 2011 4:14 PM To: 'U2 Users List' Subject: Re: [U2] Does anyone have an MV BASIC cheatsheet? I have one in my head ;) From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: 23 March 2011 18:17 To: U2 Users List Subject: [U2] Does anyone have an MV BASIC cheatsheet? I have cheatsheets for JavaScript, HTML, and CSS for training student interns but do not have one for MV BASIC. It's a long shot, but just in case anyone has one, I'd love to see and use it. Thanks. --dawn -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database: 1498/3524 - Release Date: 03/23/11 ___ 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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects and java
I agree with Brian for all of the reasons mentioned plus the performance can be much better on the server for processing when the server can simply do what it needs to do without an ongoing I/O dialogue with the client. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
Wow Dave, you really opened up a discussion on this one. We shall call you Pandora... :) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
What Martin said. It would be better to extract to temporary 1-attribute variables and loop through those rather than looping through the 101st attribute repeatedly. Especially for the prior prior year when LY.CNT = 24. So I say aye. This can definitely be improved. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [SPAM?]Re: silly company names
Ah how I miss the caveman days when you could name your kids awk, grep, and sed and people wouldn't stare... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interactive FTP commands when shelling out from UniData ECL with !cmd
You are correct that it is over telnet. However, I believe that most people access their Unidata servers via telnet, right? With all due respect, you are incorrect with this statement, however: I don't think you have ever been able to get the prompting and responses back thru the layers when you start a UniData session in telnet. Scripting the ftp command worked fine in 7.1, or *maybe* what worked better was the ftp client on WinXP? Unfortunately, having changed both Windows versions and Unidata versions at the same time, it's hard to know exactly what fell down. Like I said in that other post, I think what set me off was the end of the response where it was stated there is no problem. Had they suggested filezilla or winscp or something else, I would have respected that. But for someone to tell me that my now broken program is not a problem, well, I beg to differ. Thank you Wally for your diligence in offering additional insight and assistance. It is MOST appreciated! -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
Jeff, so you're saying that if the ftp script was created by the batch file instead of being created by something else, this works? Gee, that could be the entire issue right there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
