[U2] [UV] Programmatic Verification of Globally Cataloged Subroutine

2014-01-27 Thread Perry Taylor
Does anyone know of a good method in UniVerse BASIC to be able to verify if a 
subroutine is globally cataloged?

Thanks.
Perry Taylor
Senior MV Architect
Office (877) 494-7633 ext. 4392
Direct (502) 779-4392
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] INPUTTRAP Statement

2013-12-23 Thread Perry Taylor
Has anyone ever used the INPUTTRAP statement in UniVerse BASIC?  I want to be 
able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3), 
or any other character for that matter.  The UniVerse BASIC Commands 
documentation provides no examples on its use.

Anybody done anything like this?  Any sample code you're willing to share?

Thanks.
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] INPUTTRAP Statement

2013-12-23 Thread Perry Taylor
I have a couple of routines the move files from one account to another. If the 
user wants to quit before everything is completed I need to know that is the 
case do to clean up and restoration of permissions.

Perry 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, December 23, 2013 12:56 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] INPUTTRAP Statement


I don't think you can use *any* of the chars that are pre-trapped like ctrl-c 
(Break)
That is, chars that actually make the op-sys wake up and act in immediate mode


If you are trying to *trap* the break so you can see when someone is trying to 
use it, there is another way, although the other way of which I'm thinking 
doesn't *prevent* its use, it just *records* its use.

Maybe you could go into more detail about why you're trying to trap ctrl-c



-Original Message-
From: Perry Taylor perry.tay...@zirmed.com
To: U2-Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 23, 2013 11:41 am
Subject: [U2] [UV] INPUTTRAP Statement


Has anyone ever used the INPUTTRAP statement in UniVerse BASIC?  I want to be 
able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3), 
or any other character for that matter.  The UniVerse BASIC Commands 
documentation provides no examples on its use.

Anybody done anything like this?  Any sample code you're willing to share?

Thanks.
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
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 Training

2013-10-25 Thread Perry Taylor
I've signed up for it a couple of times in the past only to have it cancelled 
due to lack of participation :(

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ladd, Ryan
Sent: Friday, October 25, 2013 8:53 AM
To: U2-Users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Training

I believe the internals class you are referring to is now called UV910 - 
Universe theory and practice.  I've included a link, but it doesn't look like 
they are offering it anytime soon.

http://www.rocketsoftware.com/u2-training-uv910-universe-theory-and-practice

Ryan


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Pflugfelder
Sent: Friday, October 25, 2013 8:25 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] UniVerse Training

Does anyone know if the UniVerse internals class is being offered anymore?  It 
something that I've always wanted to attend, but I was never able to get 
approved.  I think I can get it approved now, but it seems like the course 
isn't being taught anymore.  If it's not available, is there any option to get 
the course materials?  I've tried reaching out to 
u2train...@rocketsoftware.commailto:u2train...@rocketsoftware.com and haven't 
gotten any response.

On a somewhat similar topic, does anyone know anything about U2 UniVersity?  
The information on their web page (http://www.rocketsoftware.com/u2-university) 
is a little out of date, mentioning University 2012.  Nothing about 2013 or 
2014.

Thanks!
-Mike


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

Note: The information contained in this message may be privileged and 
confidential and protected from disclosure. If the reader of this message is 
not the intended recipient, or an employee or agent responsible for delivering 
this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication is strictly 
prohibited. If you have received this communication in error, please notify us 
immediately by replying to the message and deleting it from your computer.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

2013-08-27 Thread Perry Taylor
That is awesome information Troy!  Thanks for that!

(Now if I could just get my production environment upgrade to 11.1x :D )

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy 
(Contractor, Logitek Systems)
Sent: Tuesday, August 27, 2013 10:03 AM
To: U2 Users List
Subject: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

Regarding the recent discussion of using indexes as triggers, I use the 
following to update timestamps of record changes to a master item stats file 
that we use for controlling updates to a business warehouse (BW).   Without 
modifying hundreds of legacy programs to support proper timestamps in the 
primary records, I added the following indexed Idescriptors to files I need to 
track.   We are on universe 11.1.1 and this has been working well for over a 
year.

DICT AR-INVOICE INDEX..MODIFIEDZ
0001 I
0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F0,)
0004 \
0005 1L
0006 S
0049 used to create item created, modified, delete in zitemstats file - create 
index with this and no.nulls keyword
EOI 216 bytes

In this example, we have a AR-INVOICE header record and a related ARLI line 
item file.   For our purposes to keep in sync with the BW, we want to timestamp 
the corresponding header record whenever a line item is updated so the ARLI 
dict item also updates AR-INVOICE header ZITEMSTATS with an I indirect update 
flag.

DICT ARLI INDEX..MODIFIEDZ
0001 I
0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, 
ARLI!:F0,):SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F1,I)
0004 \
0005 1L
0006 S
0049 used to create item created, modified, delete in zitemstats file - create 
index with this and no.nulls keyword
EOI 264 bytes

Alternate Key Index Summary for file ARLI
File... ARLI
Indices 3 (0 A-type, 0 C-type, 0 D-type, 3 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field num/I-type
INDEX..MODIFIEDZ INot Reqd  No Yes  SL NSUBR(ZIDESC.ITE
MSTATS.UPDATE,
ARLI!:F0,):S
UBR(ZIDESC.ITEM
STATS.UPDATE, 
AR-INVOICE!:F1,
I)


Subroutine ZIDESC.ITEMSTATS.UPDATE:

0001 SUB (RETURN.VALUE, ZITEMSTATS.ID, OPTIONS)
0002 * updates zitemstats with timestamps; create, modified, deleted
0003 *
0004 * Revision history:
0005 *
0006 * tdb.1190 2012-04-22_1602 new
0007 *
0008 *
0009 * input:  ZITEMSTATS.ID item id to use for ZITEMSTATS file
0010 * OPTIONS
0011 *I  update attb 5 with I for indirect 
reference
0012 *
0013 * output: RETURN.VALUE  NULL
0014 *
0015 * common vars: /ZITEMSTATS/
0016 *
0017 * called by:  INDEX..MODIFIEDZ dictionary items
0018 * calls:
0019 *
0020 * notes:
0021 *
0022 *
0023 $OPTIONS TIME.MILLISECOND
0024 *
0025 * @idx.iotype = 0 - Not being used from an index;
0026 * 1 - INSERT (new) record;
0027 * 2 - DELETE record;
0028 * 3 - Derive old index value;
0029 * 4 - Derive new index value;
0030 *
0031 COMMON /ZITEMSTATS/ F.ZITEMSTATS, ZITEMSTATS.FLAG.OPEN, ZITEMSTATS.WHO
0032 *
0033 EQU NUL TO 
0034 *
0035 RETURN.VALUE = NUL
0036 *
0037 * the following handles initial call and logto commands
0038 *
0039 IF NOT(ZITEMSTATS.FLAG.OPEN) OR (@WHO # ZITEMSTATS.WHO) THEN
0040   OPEN ZITEMSTATS TO F.ZITEMSTATS ELSE
0041 RETURN ;*  to caller.
0042   END
0043 *
0044   ZITEMSTATS.FLAG.OPEN = 1
0045   ZITEMSTATS.WHO   = @WHO
0046 END
0047 *
0048 LOG.TYPE = NUL
0049 *
0050 BEGIN CASE
0051   CASE @IDX.IOTYPE = 0
0052 *
0053   CASE @IDX.IOTYPE = 1
0054 LOG.TYPE = C ;* new - created - easier to see than 'N' new
0055 *
0056   CASE @IDX.IOTYPE = 2
0057 LOG.TYPE = D ;* delete
0058 *
0059   CASE @IDX.IOTYPE = 3
0060 *
0061   CASE @IDX.IOTYPE = 4
0062 LOG.TYPE = M ;* modified
0063 *
0064 END CASE
0065 *
0066 IF LOG.TYPE # NUL THEN
0067 *
0068   DATE.NOW = DATE()
0069   TIME.NOW = TIME()
0070 *
0071 * handle instance of midnight between date/time functions
0072 *
0073   IF DATE.NOW # DATE() AND TIME()  TIME.NOW THEN DATE.NOW = DATE()
0074 *
0075   TIMESTAMP = DATE.NOW * 86400 + TIME.NOW
0076 *
0077   READU ZITEMSTATS$ FROM F.ZITEMSTATS, ZITEMSTATS.ID ELSE ZITEMSTATS$ = NUL
0078 *
0079   INDIRECT.FLAG = COUNT(OPTIONS, I)
0080 *
0081   IF INDIRECT.FLAG THEN
0082 ZITEMSTATS$1 = M ;* modified
0083   END ELSE
0084 ZITEMSTATS$1 = LOG.TYPE
0085   END
0086 *
0087 * created
0088 *
0089   IF INDIRECT.FLAG ELSE
0090 IF LOG.TYPE = C THEN
0091   ZITEMSTATS$2 = TIMESTAMP
0092 END
0093   END
0094 *
0095 * modified
0096 *
0097   ZITEMSTATS$3 = TIMESTAMP

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-05 Thread Perry Taylor
Rocket added an @variable (don't recall the name of it) that tells which call 
is being made.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Saturday, August 03, 2013 9:40 AM
To: U2 Users List
Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using 
DEBUG or RAID with them? Was: Universe Triggers

David,

I didn't understand your 1st clause, Now that (from UV10.1) Index-based 
triggers are officially supported,

By index-based triggers,  I assume you mean the trick of indexing an 
I-descriptor that calls a subroutine that updates some other file, which 
is generally not the sort of thing you expect such a subroutine to do.

What is this official support?  Did I miss an announcement, a change 
in the documentation, or a whitepaper?

And  by support  -  just to get my hopes up beyond all reason - does 
that mean they've introduced some mechanism (@variable?) to help 
distinguish among calls of the subroutine for insert (where indexing 
calls the subroutine once, to find the new value to index) delete (where 
indexing calls the subroutine 1x, to find the value to delete), and 
change (where indexing calls the subroutine 2x, once with the old 
version of the record, once with the new, to see whether the indexed 
value has changed and, if so,  what to delete, what to add.
Distinguishing these has always been tricky for the general case.

Hope springs eternal,
Chuck

On 8/1/2013 12:32 PM, Hona, David wrote:
 Now that (from UV10.1) Index-based triggers are officially supported, can 
 these replace your SQL-based triggers? These have less functionality and less 
 overhead, but that's the price you have to pay

 Can't say I had a chance to try it for myself...yet...!



 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
 Sent: Saturday, 27 July 2013 5:32 AM
 To: U2 Users List
 Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using 
 DEBUG or RAID with them? Was: Universe Triggers

 How many people avoid using triggers BECAUSE of the virtual impossibility of 
 using RAID with Triggers?

 On 7/26/2013 12:33 PM, Phil Walker wrote:
 I won't be holding my breath Charles ;-)

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
 Stevenson
 Sent: Friday, 26 July 2013 9:22 p.m.
 To: U2 Users List
 Subject: Re: [U2] Universe Triggers

 re. triggers  Raid,  I could not agree with Phil more.  Well said.
 Come on, Rocket!

 On 7/19/2013 1:32 AM, Phil Walker wrote:
 Ken,

 I am glad you raised the issue about debugging a program with a file which 
 has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for 
 ages about fixing this pushing for the ability to be able to step into the 
 trigger code, but at a VERY MINIMUM being able to debug the program and 
 perform the write on the file, and in effect step over the trigger 
 subroutine and carry on debugging. The issue is the trigger subroutine 
 cannot support input, so what UV have done is basically say you are using 
 the debugger so you are inputting debug commands so you will abort. They 
 need to turn this restriction off for debugging so that either of the above 
 two scenarios is supported.

 In a Microsoft world I can debug anything through the connected world of 
 web/databases etc..

 Have had no feedback from UV

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
 Sent: Friday, 19 July 2013 9:48 a.m.
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Universe Triggers

 Dan,
 In addition to the other responses you have received, I suggest the 
 following:
 1. Have one master file trigger subroutine (globally catalogued) that calls 
 subroutines (locally catalogued) tailored to individual files.  This means 
 you don't have to stop and restart Universe when a new trigger is required 
 or a change to an existing one.  If the master subroutine changes, you do 
 have to restart Universe.
 2. Use a control record that records the subroutine name and state of the 
 trigger for each file having a trigger.
 3. Use a program to change the state of a trigger, using the control 
 records in 2 above.
 4. Make sure all background processes that have a file with a trigger open 
 are logged out when recompiling the subroutine for that file trigger.
 5. Remember that you can't do anything to a file with an active trigger 
 whilst in the RAID debugger (it will crash).  Rather, if you are testing a 
 file trigger subroutine, drop the trigger and use a trigger testing program 
 that calls the subroutine after taking a copy of the record being changed, 
 pausing whilst you change it in another session, and then resuming, calling 
 

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-29 Thread Perry Taylor
That and the expense of their usage.

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Friday, July 26, 2013 1:32 PM
To: U2 Users List
Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG 
or RAID with them? Was: Universe Triggers

How many people avoid using triggers BECAUSE of the virtual 
impossibility of using RAID with Triggers?

On 7/26/2013 12:33 PM, Phil Walker wrote:
 I won't be holding my breath Charles ;-)

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
 Sent: Friday, 26 July 2013 9:22 p.m.
 To: U2 Users List
 Subject: Re: [U2] Universe Triggers

 re. triggers  Raid,  I could not agree with Phil more.  Well said.
 Come on, Rocket!

 On 7/19/2013 1:32 AM, Phil Walker wrote:
 Ken,

 I am glad you raised the issue about debugging a program with a file which 
 has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for 
 ages about fixing this pushing for the ability to be able to step into the 
 trigger code, but at a VERY MINIMUM being able to debug the program and 
 perform the write on the file, and in effect step over the trigger 
 subroutine and carry on debugging. The issue is the trigger subroutine 
 cannot support input, so what UV have done is basically say you are using 
 the debugger so you are inputting debug commands so you will abort. They 
 need to turn this restriction off for debugging so that either of the above 
 two scenarios is supported.

 In a Microsoft world I can debug anything through the connected world of 
 web/databases etc..

 Have had no feedback from UV

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford
 Sent: Friday, 19 July 2013 9:48 a.m.
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Universe Triggers

 Dan,
 In addition to the other responses you have received, I suggest the 
 following:
 1. Have one master file trigger subroutine (globally catalogued) that calls 
 subroutines (locally catalogued) tailored to individual files.  This means 
 you don't have to stop and restart Universe when a new trigger is required 
 or a change to an existing one.  If the master subroutine changes, you do 
 have to restart Universe.
 2. Use a control record that records the subroutine name and state of the 
 trigger for each file having a trigger.
 3. Use a program to change the state of a trigger, using the control records 
 in 2 above.
 4. Make sure all background processes that have a file with a trigger open 
 are logged out when recompiling the subroutine for that file trigger.
 5. Remember that you can't do anything to a file with an active trigger 
 whilst in the RAID debugger (it will crash).  Rather, if you are testing a 
 file trigger subroutine, drop the trigger and use a trigger testing program 
 that calls the subroutine after taking a copy of the record being changed, 
 pausing whilst you change it in another session, and then resuming, calling 
 the subroutine.

 If you would like samples of any of the software mentioned above, let me 
 know, and I can send them to you.

 Regards,
 Ken Ford
 Universe Software Developer
 t 07 3013 8605 | f 07 3002 8400
 e ken.f...@firstmac.com.au | w firstmac.com.au


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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] CentOS with Universe?

2013-07-17 Thread Perry Taylor
The only concern I might have is if you have to bring Rocket in for support... 
will they support it.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis
Sent: Wednesday, July 17, 2013 7:42 AM
To: U2 Users List
Subject: [U2] CentOS with Universe?

We have a VAR who would prefer to load Universe and their application on a
supported platform, but we would prefer not to pay for RHEL 6. I searched
the list and found a few tidbits, but does anyone have a good list of what
changes might be required to successfully run Universe 11.1 on CentOS? How
much pain would we be introducing for ourselves and our VAR, if they were
willing to play along?

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Auto Starting Applications

2013-07-11 Thread Perry Taylor
Thanks to everyone for your input...

While I can definitely modify uv.rc to call whatever script/program I need I 
really didn't want to hack uv.rc because of the complications with upgrades. 
What I was really wanting was a built-in facility in uv.rc that would 
conditionally fire off a script, if found at a configurable location, only when 
UniVerse is started up.  

Perhaps something like...

if [ -s $uvhome/uv.rc.local ]; then
UV.RC.LOCAL=$(cat $/uvhome/uv.rc.local)
else
UV.RC.LOCAL=''
fi




case $1 in
'start')



[ -x $UV.RC.LOCAL ]  $UV.RC.LOCAL




In short something that does not require customizing uv.rc.  

Hrm... looking at my current uv.rc there is no explicit start mode.  Only 
stop and anything defaults to startup...

Case $1 in
'start')
# shut down
...
*)  # default: start up processes
...


My script would have to be smart enough to know if universe had previously been 
started so as to not duplicate.

I really was looking for something to keep my life simple :(

Thanks.
Perry



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco
Sent: Wednesday, July 10, 2013 7:53 PM
To: U2 Users List
Subject: Re: [U2] [UV] Auto Starting Applications


I use /etc/rc.local, if you vi the file you will see:

#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

to not just start up universe processes, but linux ones as well 
(glassfish, mysql, and a couple of perl programs as welletc )

dougc


 What techniques are you folks using to start up apps when UniVerse on
 Linux is started?  Obviously hooking into uv.rc is an option.  Are
 there others?

 Thanks.
 Perry
 ** IMPORTANT MESSAGE *
 This e-mail message is intended only for the addressee(s) and contains 
 information which may be
 confidential.
 If you are not the intended recipient please advise the sender by return 
 email, do not use or
 disclose the contents, and delete the message and any attachments from your 
 system. Unless
 specifically indicated, this email does not constitute formal advice or 
 commitment by the sender
 or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its 
 subsidiaries.
 We can be contacted through our web site: commbank.com.au.
 If you no longer wish to receive commercial electronic messages from us, 
 please reply to this
 e-mail by typing Unsubscribe in the subject line.
 **



 ___
 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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] Auto Starting Applications

2013-07-10 Thread Perry Taylor
What techniques are you folks using to start up apps when UniVerse on Linux is 
started?  Obviously hooking into uv.rc is an option.  Are there others?

Thanks.
Perry

Perry Taylor
Senior MV Architect
Office (877) 494-7633 ext. 4392
Direct (502) 779-4392
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-11 Thread Perry Taylor
I have several *very* large files on which I need to perform some file sizing 
diagnostics.  Rather than repeatedly running HASH.AID against these files is 
there a good way to sample say 2-3 million records to copy into a test file?  
SAMPLE will only grab the first n records in hash order and I'm thinking that 
would not necessarily be a good representative sample of the file's contents.  
Am I up in the night thinking this is the case?  Is there a better way to get a 
good sample of records for this purpose?

Thanks.
Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-11 Thread Perry Taylor
Great minds!

Wow I knew about SAMPLED but it didn't occur to me that it could be used 
concurrently with SAMPLE.  Nice!  I'll give that try.

Thanks guys!

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah
Sent: Tuesday, June 11, 2013 10:21 AM
To: U2 Users List
Subject: Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

I probably hit Send within milliseconds of you. :-)
Charlie

On 06-11-2013 11:15 AM, Charles Stevenson wrote:
 SAMPLED keyword with a D on the end will go thru the entire file.
 SAMPLED 1000  will get every thousandth record as it reads through the file.
 SAMPLED 1000 SAMPLE 2000  will do the same, but then stop after it builds a
 list of 2000. That is, after it's read thru the 1st 2 million keys.


 On Tue, Jun 11, 2013 at 11:01 AM, Perry Taylor perry.tay...@zirmed.comwrote:

 I have several *very* large files on which I need to perform some file
 sizing diagnostics.  Rather than repeatedly running HASH.AID against these
 files is there a good way to sample say 2-3 million records to copy into a
 test file?  SAMPLE will only grab the first n records in hash order and I'm
 thinking that would not necessarily be a good representative sample of the
 file's contents.  Am I up in the night thinking this is the case?  Is there
 a better way to get a good sample of records for this purpose?

 Thanks.
 Perry

 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/



 CONFIDENTIALITY NOTICE: This e-mail message, including any
 attachments, is for the sole use of the intended recipient(s)
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is
 prohibited. ZirMed, Inc. has strict policies regarding the
 content of e-mail communications, specifically Protected Health
 Information, any communications containing such material will
 be returned to the originating party with such advisement
 noted. If you are not the intended recipient, please contact
 the sender by reply e-mail and destroy all copies of the
 original message.
 ___
 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] Recognition for Rocket and Rocket's U2 in dual rankings today!

2013-06-04 Thread Perry Taylor
Don't forget about Reynolds and Reynolds (UniVerse) in the automotive dealer 
space.  I think between ADP and RR have 80% of the market collectively.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, June 04, 2013 10:20 AM
To: donr_w...@yahoo.com; u2-users@listserver.u2ug.org
Subject: Re: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today!

The auto dealership software should be ADP Dealer Services
Do they have 80% ?

Or is there another automobile dealership software that runs on Multi Value ?


 

 

 

-Original Message-
From: Don Robinson donr_w...@yahoo.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Jun 4, 2013 7:16 am
Subject: Re: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today!


Daniel,
 
In the View from the Top by Andy Youniss, he list the following;
 
40% of US institutions of higher education
80% of Mexico’s emergency response systems
70% of North America’s largest independent insurance agencies
80% of automobile dealerships in North America
55% of Fortune 100 companies
50% of the top 400 energy-products companies
 
Except for the Fortune 100 companies, it would seem that the others might be 
using packaged software.
A list of these packages might be interesting.
 
I'm not disputing the numbers but some explanation of how they were calculated 
would be nice to know.
 
I have a vague idea about the auto dealers and higher education but not the 
others. I think this illustrates the I never heard of Pick/multi-value 
software comments we hear a lot of because the database is hidden from the 
users.
 
BTW, maybe auto parts and many other wholesalers and retailers should be added 
to this list.
 
Just my 2 cents,

Don Robinson



From: Daniel McGrath dmcgr...@rocketsoftware.com
To: U2 Users List (u2-users@listserver.u2ug.org) 
u2-users@listserver.u2ug.org 

Sent: Monday, June 3, 2013 4:59 PM
Subject: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today!


If you haven't seen it already, U2 got dual mentions today in top ranks.

First: The UniData and UniVerse databases from Rocket Software have been listed 
for the first time in the database ranking site DB-Engines, making 45/169 (top 
27%)  on debut.

http://db-engines.com/en/ranking

Second: Rocket has been listed in the 'DBTA 100: The Companies That Matter Most 
in Data' with a big mention of the U2 databases from our CEO, Andy Youniss.

http://www.dbta.com/Articles/Editorial/Trends-and-Applications/View-from-the-Top-Rocket-Software-89919.aspx

http://www.dbta.com/Articles/Editorial/News-Flashes/DBTA-100-The-Companies-That-Matter-Most-in-Data-89876.aspx

Regards,
Dan

___
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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

2013-05-30 Thread Perry Taylor
Thanks to everyone for all the great feedback!  I think I have a much better 
understanding of the available options.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Peters 
Bluefinity
Sent: Wednesday, May 29, 2013 10:12 AM
To: U2 Users List
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

And from Bluefinity we certainly welcome Dan's endorsement to technology that 
enhances the use of U2 and makes for happy, long term users as this is great 
for everyone.  There are certainly a lot of happy mv.NET customers in that 
category.

Regards
David Peters, Sales Manager at Bluefinity

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: 29 May 2013 15:27
To: U2 Users List
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

Thanks for the reply Tony,

I can't speak for anyone but Rocket, but we definitely don't feel threatened 
and encourage everyone to write great applications and share the story, 
regardless of what technology you use to connect U2 to your front-end.

Did I mention share the story? :)

Cheers,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Tuesday, May 28, 2013 1:52 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

 From: Daniel McGrath
 Tony, out of curiosity, have you looked at UO.NET's replacement: U2 
 Toolkit for .NET?

Not recently bud. Once I settle on a toolkit that works well, my research in 
that specific area slows down. How much research do we continue to do on cars 
after we've made a purchase? Do we keep house hunting after we move into a new 
home? It's appropriate to be informed about what's happening in our industry, 
but I have dozens of platforms, frameworks, toolkits, and related versions that 
I need to keep up with - that still means time needs to be allocated for 
hundreds of permutations of all of these blasted software packages that are all 
supposed to save us time. Like everyone else here, I need to use whatever 
free time I have to hone my skills with the latest versions of the tools I 
already use, rather than continue to look into replacements. Despite 
professional curiosity, at some point we need to stop playing with tools and 
just hunker down to write real code.

I'd like to say that at some point I'll cycle back around for another look at 
the U2 toolkit, but remember that for my purposes of writing applications that 
are the same across all MV platforms,  a platform-specific tool is generally 
off of my radar. Sure, it would be nice to save my clients money using free 
tools, but I have U2 clients that have been running a single license of mv.NET 
for years. The tiny cost of the tool is trivial in the big picture. People need 
to think hard about exactly how much free costs them, or how adverse they are 
to buying a low-cost license for something that will last years.

And that's just the cost of the tool. When a U2 site posts a job ad for someone 
to do UI work or web services, they might say must know
U2 Toolkit for .NET. If they have a tool that anyone in the MV industry can 
use, the scope of candidates broadens to include U2 developers And everyone 
else. .NET developers have already broadened their scope to the outside world. 
Once they/we have made that jump, there's no reason anymore to limit one's self 
to a single MV platform and related tools. A company that is going in this 
direction should think hard about branching out and then snapping right back 
again to platform-specific tools. Sure, you're going to find someone who does 
U2-only work with .NET, but why limit your scope to U2-only people?
The non-end-user developers that I know who use mv.NET aren't interested in 
limiting themselves to one platform anymore.  It doesn't make sense to not have 
access to that pool of talent just because you want to use a free tool.

And no, the DBMS vendors shouldn't feel threatened by this - we're enhancing 
applications for everyone, not the competition. It's the end-users that win 
here as well as their up-line channel. So Rocket Software and Tiger Logic and 
Ladybridge and everyone else should be encouraging their developer channel to 
use mv.NET rather than somehow feeling threatened by it.

(More than I expected to write on that one, sorry.) T

Tony Gravagno   
Nebula Research and Development 
TG@ remove.pleaseNebula-RnD.com 
Nebula RD sells mv.NET worldwide   
and provides related development services   
http://Nebula-RnD.com/blog  
http://Twitter.com/TonyGravagno 


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

Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

2013-05-30 Thread Perry Taylor
Hello Robert.

Thanks for the info.  I will definitely be having a look at the videos.

BTW... what is your licensing model?

Thanks.
Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben
Sent: Thursday, May 30, 2013 9:30 AM
To: U2 Users List
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

Hi Perry,

I'm a bit late to the party, but we (FusionWare) have a Managed Provider 
(ADO.NET) that works with U2 and is portable to other MultiValue platforms.  If 
you're looking at options, you might as well have them all.  Here are some 
YouTube playlists that show how our Managed Provider works:

http://www.youtube.com/user/fusionwareInt/videos?flow=gridview=1

We've been around for a long time, having released an ODBC driver for 
MultiValue back in 1992.  We have customers who still use both the ODBC, OLEDB, 
JDBC, and our Managed Provider and have seen some very innovative extensions of 
MultiValue with 3rd party apps over the years.

Thank you,

Robert Houben
Chief Technology Officer
FusionWare Integration Corp.
An IBM Advanced Business Partner
p: 604-777-4254 x158
f: 604-608-5544
http://www.fwic.net
http://twitter.com/fusionwareint
https://www.linkedin.com/in/roberthouben

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Thursday, May 30, 2013 7:34 AM
To: U2 Users List
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

Thanks to everyone for all the great feedback!  I think I have a much better 
understanding of the available options.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Peters 
Bluefinity
Sent: Wednesday, May 29, 2013 10:12 AM
To: U2 Users List
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

And from Bluefinity we certainly welcome Dan's endorsement to technology that 
enhances the use of U2 and makes for happy, long term users as this is great 
for everyone.  There are certainly a lot of happy mv.NET customers in that 
category.

Regards
David Peters, Sales Manager at Bluefinity

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: 29 May 2013 15:27
To: U2 Users List
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

Thanks for the reply Tony,

I can't speak for anyone but Rocket, but we definitely don't feel threatened 
and encourage everyone to write great applications and share the story, 
regardless of what technology you use to connect U2 to your front-end.

Did I mention share the story? :)

Cheers,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Tuesday, May 28, 2013 1:52 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

 From: Daniel McGrath
 Tony, out of curiosity, have you looked at UO.NET's replacement: U2
 Toolkit for .NET?

Not recently bud. Once I settle on a toolkit that works well, my research in 
that specific area slows down. How much research do we continue to do on cars 
after we've made a purchase? Do we keep house hunting after we move into a new 
home? It's appropriate to be informed about what's happening in our industry, 
but I have dozens of platforms, frameworks, toolkits, and related versions that 
I need to keep up with - that still means time needs to be allocated for 
hundreds of permutations of all of these blasted software packages that are all 
supposed to save us time. Like everyone else here, I need to use whatever 
free time I have to hone my skills with the latest versions of the tools I 
already use, rather than continue to look into replacements. Despite 
professional curiosity, at some point we need to stop playing with tools and 
just hunker down to write real code.

I'd like to say that at some point I'll cycle back around for another look at 
the U2 toolkit, but remember that for my purposes of writing applications that 
are the same across all MV platforms,  a platform-specific tool is generally 
off of my radar. Sure, it would be nice to save my clients money using free 
tools, but I have U2 clients that have been running a single license of mv.NET 
for years. The tiny cost of the tool is trivial in the big picture. People need 
to think hard about exactly how much free costs them, or how adverse they are 
to buying a low-cost license for something that will last years.

And that's just the cost of the tool. When a U2 site posts a job ad for someone 
to do UI work or web services, they might say must know
U2 Toolkit for .NET. If they have a tool that anyone in the MV industry can 
use, the scope of candidates broadens to include U2 developers And everyone 
else

[U2] [UV] UniObjects.Net vs Thrid-party Products

2013-05-27 Thread Perry Taylor
I'm investigating the pros and cons to using UniObjects.Net vs third-party 
products such as MV.Net, etc.  Anyone care to chime in with your experiences?

Thanks.
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Perry Taylor
If your record key is comprised of something meaningful you might want to query 
against it.  For example if your key is say  STATE: '*': CITY and you want all 
the records for a given state ... SELECT FILE WITH @ID FL*] .

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
Sent: Friday, May 24, 2013 8:52 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?

Maybe I am missing something, but why would you want an index on @ID?

JRI

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, May 24, 2013 10:18 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?

YUP.

I just isolated it to the index of @ID.

I changed the original filename, recreated a new file Copied all the data 
Copied all the dict And finally, recreated the index (@ID)

Testing the sampling on each step, all went well until I recreated the index, 
then it bombed again.

And yes, using the NO.INDEX does fix it.

Does working with an active select list de-activate the @ID Index?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Friday, May 24, 2013 10:10 AM
To: U2 Users List
Subject: Re: [U2] UV File doesn't like being sampled?

George, I checked out system and we have experienced this issue before.

Check if you have built an index on @ID. If you have, this is what is causing 
your issue. Using the NO.INDEX keyword will give you correct results. I don't 
have an explanation for the behavior. Let us know how it goes.

Regards,

Dan McGrath
Managing Director, U2 Servers Lab
Rocket Software


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, May 24, 2013 7:52 AM
To: U2 Users
Subject: [U2] UV File doesn't like being sampled?

OK.

Any Ideas? I have a Type 30 file that if I use the SAMPLE modifier in the 
SELECT still returns the entire file, However, if I use the SAMPLE modifier in 
a LIST command on that same file, it only returns the sample amount.

Now, it gets stranger, If I do a SELECT with the SAMPLE modifier, it returns 
the whole file as an active list, and if I Do another SELECT with the SAMPLE 
modifier on that active list, it only returns the the sample amount.
So what, the file is just toying with me? I guess if I really want that sample, 
I have to ask twice?

SELECT FILENAME SAMPLE 10

929347 record(s) selected to SELECT list #0.
SELECT FILENAME  SAMPLE 10

10 record(s) selected to SELECT list #0.


This seems to be the only file that is behaving this way. There are no 
dictionary items in the file that would Interfere with the UV selection.

My next step will be to create a new file, and copy over the contents, just in 
case there is something that Is corrupted in the file.

This is on UV 10.0.2 / RH Linux
___
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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Relative Path for SET.INDEX in Universe

2013-05-07 Thread Perry Taylor
Tried it at 10.3.9 and there were some problems.  I don't recall exactly what 
it was but I had to revert back to absolute pathing.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Monday, May 06, 2013 1:59 PM
To: 'U2 Users List'
Subject: [U2] Relative Path for SET.INDEX in Universe

I was told, at one point, that it was possible to use a relative path in the 
SET.INDEX command for UV.

If anyone knows that syntax, please advise!

Thanks,
Rick Nuckolls
Lynden Inc
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] RESIZE INPLACE

2013-05-06 Thread Perry Taylor
I had contact with U2 Support who confirmed that the INPLACE option was not 
stable at our release (10.3.9) so I steered clear.  I actually had the luxury 
of being able to create a new file and copying records so that is what I ended 
up doing.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Monday, May 06, 2013 7:25 AM
To: U2 Users List
Subject: Re: [U2] [UV] RESIZE INPLACE

So, Perry, did you do it?
Chuck

On 4/25/2013 3:09 PM, Perry Taylor wrote:
 Before I go and resize a 144GB file has anyone had any experiences with the 
 INPLACE option of RESIZE in UniVerse?  Good, bad, ugly???

 Thanks.
 Perry

 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/


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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] RESIZE INPLACE

2013-04-29 Thread Perry Taylor
We actually do this with many of our big active files.  Many benefits to 
distributed files when it comes to maintenance :)

The file in question here is a deep archive file which will see little activity 
and, once it's sized properly, will *hopefully* never change again.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes
Sent: Sunday, April 28, 2013 2:46 AM
To: U2 Users List
Subject: Re: [U2] [UV] RESIZE INPLACE

Hi,

Given the risk of manipulating a file of this size, I recommend the use of 
distributed files (DEFINE.DF).
Just as effective, if not better, each part file is administered individually 
(backups, resizing, indexing, !accessing, locking,...)

Procedure :

1 - analyse the keys to build a distribution algorythm ; at worst use hashing 
algorythm ; don't forget a elsewhere partnumber (1 ) 

2 - create part files (define how many, size, ...,  by analysing number 
key-records, time growing ,...)

3 - define distributed file ; DICT adress the original DICT

4 - copy all record from orig.file to df.file (do it one time before live to 
check if all keys can be processed by your algorythm)

5 - edit VOC orig.file to adress df.file as data file

6 - resize all part file individually.

7 - delete the orig.DATA file index from os ; to get back your 144gb

My two pence
manu

 -Message d'origine-
 De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] De la part de Perry Taylor
 Envoyé : jeudi 25 avril 2013 22:10
 À : U2-Users List
 Objet : [U2] [UV] RESIZE INPLACE
 
 Before I go and resize a 144GB file has anyone had any experiences with the
 INPLACE option of RESIZE in UniVerse?  Good, bad, ugly???
 
 Thanks.
 Perry
 
 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/
 
 
 
 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
 for the sole use of the intended recipient(s) and may contain confidential and
 privileged information.  Any unauthorized review, use, disclosure or 
 distribution
 is prohibited. ZirMed, Inc. has strict policies regarding the content of 
 e-mail
 communications, specifically Protected Health Information, any
 communications containing such material will be returned to the originating
 party with such advisement noted. If you are not the intended recipient, 
 please
 contact the sender by reply e-mail and destroy all copies of the original
 message.
 ___
 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] [UV] RESIZE INPLACE

2013-04-25 Thread Perry Taylor
Before I go and resize a 144GB file has anyone had any experiences with the 
INPLACE option of RESIZE in UniVerse?  Good, bad, ugly???

Thanks.
Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] RESIZE INPLACE

2013-04-25 Thread Perry Taylor
make a backup first   Comforting!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey
Sent: Thursday, April 25, 2013 2:37 PM
To: U2 Users List
Subject: Re: [U2] [UV] RESIZE INPLACE

make a backup first
- Original Message - 
From: Perry Taylor perry.tay...@zirmed.com
To: U2-Users List u2-users@listserver.u2ug.org
Sent: Thursday, April 25, 2013 2:09 PM
Subject: [U2] [UV] RESIZE INPLACE


 Before I go and resize a 144GB file has anyone had any experiences with 
 the INPLACE option of RESIZE in UniVerse?  Good, bad, ugly???

 Thanks.
 Perry

 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/



 CONFIDENTIALITY NOTICE: This e-mail message, including any
 attachments, is for the sole use of the intended recipient(s)
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is
 prohibited. ZirMed, Inc. has strict policies regarding the
 content of e-mail communications, specifically Protected Health
 Information, any communications containing such material will
 be returned to the originating party with such advisement
 noted. If you are not the intended recipient, please contact
 the sender by reply e-mail and destroy all copies of the
 original message.
 ___
 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] uvbackup linux command line - multiple specific files

2013-04-17 Thread Perry Taylor
cd to the directory where the files live then...

find -maxdepth 1 -name 'BUY.[ST]MF*' -print | uvbackup 

Should get 'em.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: Wednesday, April 17, 2013 1:51 PM
To: U2-Users@listserver.u2ug.org
Subject: [U2] uvbackup linux command line - multiple specific files

Unix 'find' is failing me and I have not found documentation on 
specifically what I'm trying to do.
I need to use uvbackup from the command line to back up 4 specific 
Universe files to one archive so they can be restored to a different 
platform without all the fnuxi stuff. I need to pick up the following 
files only.

./BUY.SMF
./BUY.TMF
./BUY.SMF.LAST
./BUY.TMF.FIND

Help me Mr. uvbackupWizard!
-- 

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Large File Operations Kill Linux

2013-02-05 Thread Perry Taylor
I have engaged Redhat Support and it has already been escalated to their Kernel 
team so at least it seems I have their attention :).  I'll provide updates as 
they become available.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
Sent: Monday, February 04, 2013 3:32 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Large File Operations Kill Linux


Other users could have been hanging at malloc. With a swappiness of 100 (on 
some kernels) or 100 (on others) or not 0 or 100(not sure which behavior you 
get on 2.6.18), pages wouldn't be getting freed up quickly enough duing the 
creation/copying of a large file.
 
Another thing to look at (although I prefer the support route, since you have 
it), is /sys/kernel/mm/transparent_hugepage/defrag. Other people who have had 
this problem alleviated it by setting this to never.
 
Of course, others fixed it by updating the kernel. My aged eyes read what you 
have as 2.6.8.1...
 
 Date: Mon, 4 Feb 2013 21:15:25 +
 From: antli...@youngman.org.uk
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
 On 04/02/13 21:05, Dan Fitzgerald wrote:
  
  What's the value in /proc/sys/vm/swappiness?
 
 How will that make any difference? 2.6.18-348 SOUNDS like an ancient (in
 linux terms) kernel. Are you on RedHat support?
 
 This is a problem with the linux kernel that was addressed recently,
 iirc. Large amounts of io from a single process can swamp the queue, and
 the latest kernels have it fixed.
 
 If you've got RH support, see if you can find out if that's been
 backported into your kernel.
 
 Cheers,
 Wol
   
  From: perry.tay...@zirmed.com
  To: u2-users@listserver.u2ug.org
  Date: Mon, 4 Feb 2013 20:53:13 +
  Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
  We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram.
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org 
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
  Sent: Monday, February 04, 2013 9:23 AM
  To: 'U2 Users List'
  Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
   A few questions - What linux version/distro are you on and what type of
  file system, and how much ram do you have
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
  Sent: 04 February 2013 15:57
  To: U2-Users List
  Subject: [U2] [UV] Large File Operations Kill Linux
 
  Looking for some ideas on how to keep Linux from becoming largely
  unresponsive when creating large files.  What happens is as the new file is
  being created the I/O buffer cache quickly fills up with dirty buffers.
  Until the kernel can flush these out to disk there is no avail buffers for
  I/O operations from other processes.  .  The most troubling manifestation 
  of
  this is the transaction logging check point daemon gets *way* behind 
  putting
  us as risk if we were to have a failure of some kind.
 
  I have tried using ionice and renice to slow the file creation down as much
  as possible.  This help a little but is still a big problem.  Any ideas how
  to get CREATE.FILE/RESIZE to play nice on Linux?
 
  Thanks.
  Perry
  Perry Taylor
  Senior MV Architect
  ZirMed
  888 West Market Street, Suite 400
  Louisville, KY 40202
  www.zirmed.comhttp://www.zirmed.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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Large File Operations Kill Linux

2013-02-05 Thread Perry Taylor
Here's the one I'm using for the test...

[root@qauv2 zmopsx]# ls  -l /data/traxnl3/trax2011/ERA.DET
-rw-rw 1 perryt trax 123736145920 Feb  5 15:53 
/data/traxnl3/trax2011/ERA.DET

So yeah.. they're pretty big.  (There are others even bigger)  

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera
Sent: Tuesday, February 05, 2013 3:51 PM
To: U2 Users List
Subject: Re: [U2] [UV] Large File Operations Kill Linux

Perry

I'm curious how large large is for you?

Jeff Butera
--
A tree falls the way it leans.
Be careful which way you lean.
The Lorax

On Feb 5, 2013, at 5:45 PM, Perry Taylor perry.tay...@zirmed.com wrote:

 I have engaged Redhat Support and it has already been escalated to their 
 Kernel team so at least it seems I have their attention :).  I'll provide 
 updates as they become available.
 
 Perry
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
 Sent: Monday, February 04, 2013 3:32 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
 
 Other users could have been hanging at malloc. With a swappiness of 100 (on 
 some kernels) or 100 (on others) or not 0 or 100(not sure which behavior 
 you get on 2.6.18), pages wouldn't be getting freed up quickly enough duing 
 the creation/copying of a large file.
 
 Another thing to look at (although I prefer the support route, since you have 
 it), is /sys/kernel/mm/transparent_hugepage/defrag. Other people who have had 
 this problem alleviated it by setting this to never.
 
 Of course, others fixed it by updating the kernel. My aged eyes read what you 
 have as 2.6.8.1...
 
 Date: Mon, 4 Feb 2013 21:15:25 +
 From: antli...@youngman.org.uk
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
 On 04/02/13 21:05, Dan Fitzgerald wrote:
 
 What's the value in /proc/sys/vm/swappiness?
 
 How will that make any difference? 2.6.18-348 SOUNDS like an ancient (in
 linux terms) kernel. Are you on RedHat support?
 
 This is a problem with the linux kernel that was addressed recently,
 iirc. Large amounts of io from a single process can swamp the queue, and
 the latest kernels have it fixed.
 
 If you've got RH support, see if you can find out if that's been
 backported into your kernel.
 
 Cheers,
 Wol
 
 From: perry.tay...@zirmed.com
 To: u2-users@listserver.u2ug.org
 Date: Mon, 4 Feb 2013 20:53:13 +
 Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
 We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram.
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
 Sent: Monday, February 04, 2013 9:23 AM
 To: 'U2 Users List'
 Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
 A few questions - What linux version/distro are you on and what type of
 file system, and how much ram do you have
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
 Sent: 04 February 2013 15:57
 To: U2-Users List
 Subject: [U2] [UV] Large File Operations Kill Linux
 
 Looking for some ideas on how to keep Linux from becoming largely
 unresponsive when creating large files.  What happens is as the new file is
 being created the I/O buffer cache quickly fills up with dirty buffers.
 Until the kernel can flush these out to disk there is no avail buffers for
 I/O operations from other processes.  .  The most troubling manifestation 
 of
 this is the transaction logging check point daemon gets *way* behind 
 putting
 us as risk if we were to have a failure of some kind.
 
 I have tried using ionice and renice to slow the file creation down as much
 as possible.  This help a little but is still a big problem.  Any ideas how
 to get CREATE.FILE/RESIZE to play nice on Linux?
 
 Thanks.
 Perry
 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.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
 
 CONFIDENTIALITY NOTICE: This e-mail message, including any 
 attachments, is for the sole use of the intended recipient(s) 
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is 
 prohibited. ZirMed, Inc. has strict policies regarding the 
 content of e-mail communications, specifically Protected Health 
 Information, any communications containing such material will 
 be returned

[U2] [UV] Large File Operations Kill Linux

2013-02-04 Thread Perry Taylor
Looking for some ideas on how to keep Linux from becoming largely unresponsive 
when creating large files.  What happens is as the new file is being created 
the I/O buffer cache quickly fills up with dirty buffers.  Until the kernel can 
flush these out to disk there is no avail buffers for I/O operations from other 
processes.  .  The most troubling manifestation of this is the transaction 
logging check point daemon gets *way* behind putting us as risk if we were to 
have a failure of some kind.

I have tried using ionice and renice to slow the file creation down as much as 
possible.  This help a little but is still a big problem.  Any ideas how to get 
CREATE.FILE/RESIZE to play nice on Linux?

Thanks.
Perry
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Large File Operations Kill Linux

2013-02-04 Thread Perry Taylor
We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, February 04, 2013 9:23 AM
To: 'U2 Users List'
Subject: Re: [U2] [UV] Large File Operations Kill Linux

 A few questions - What linux version/distro are you on and what type of
file system, and how much ram do you have

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: 04 February 2013 15:57
To: U2-Users List
Subject: [U2] [UV] Large File Operations Kill Linux

Looking for some ideas on how to keep Linux from becoming largely
unresponsive when creating large files.  What happens is as the new file is
being created the I/O buffer cache quickly fills up with dirty buffers.
Until the kernel can flush these out to disk there is no avail buffers for
I/O operations from other processes.  .  The most troubling manifestation of
this is the transaction logging check point daemon gets *way* behind putting
us as risk if we were to have a failure of some kind.

I have tried using ionice and renice to slow the file creation down as much
as possible.  This help a little but is still a big problem.  Any ideas how
to get CREATE.FILE/RESIZE to play nice on Linux?

Thanks.
Perry
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health Information,
any communications containing such material will be returned to the
originating party with such advisement noted. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message.
___
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: 2012.0.2238 / Virus Database: 2639/5579 - Release Date: 02/03/13

___
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] [UV] Large File Operations Kill Linux

2013-02-04 Thread Perry Taylor
70.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
Sent: Monday, February 04, 2013 2:06 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Large File Operations Kill Linux


What's the value in /proc/sys/vm/swappiness?
 
 From: perry.tay...@zirmed.com
 To: u2-users@listserver.u2ug.org
 Date: Mon, 4 Feb 2013 20:53:13 +
 Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
 We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram.
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
 Sent: Monday, February 04, 2013 9:23 AM
 To: 'U2 Users List'
 Subject: Re: [U2] [UV] Large File Operations Kill Linux
 
  A few questions - What linux version/distro are you on and what type of
 file system, and how much ram do you have
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
 Sent: 04 February 2013 15:57
 To: U2-Users List
 Subject: [U2] [UV] Large File Operations Kill Linux
 
 Looking for some ideas on how to keep Linux from becoming largely
 unresponsive when creating large files.  What happens is as the new file is
 being created the I/O buffer cache quickly fills up with dirty buffers.
 Until the kernel can flush these out to disk there is no avail buffers for
 I/O operations from other processes.  .  The most troubling manifestation of
 this is the transaction logging check point daemon gets *way* behind putting
 us as risk if we were to have a failure of some kind.
 
 I have tried using ionice and renice to slow the file creation down as much
 as possible.  This help a little but is still a big problem.  Any ideas how
 to get CREATE.FILE/RESIZE to play nice on Linux?
 
 Thanks.
 Perry
 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/
 
 
 
 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
 for the sole use of the intended recipient(s) and may contain confidential
 and privileged information.  Any unauthorized review, use, disclosure or
 distribution is prohibited. ZirMed, Inc. has strict policies regarding the
 content of e-mail communications, specifically Protected Health Information,
 any communications containing such material will be returned to the
 originating party with such advisement noted. If you are not the intended
 recipient, please contact the sender by reply e-mail and destroy all copies
 of the original message.
 ___
 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: 2012.0.2238 / Virus Database: 2639/5579 - Release Date: 02/03/13
 
 ___
 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] [UV] Large File Operations Kill Linux

2013-02-04 Thread Perry Taylor
Yes we are on RH support.  I'll run it by them and see.

Thanks.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Monday, February 04, 2013 2:15 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Large File Operations Kill Linux

On 04/02/13 21:05, Dan Fitzgerald wrote:
 
 What's the value in /proc/sys/vm/swappiness?

How will that make any difference? 2.6.18-348 SOUNDS like an ancient (in
linux terms) kernel. Are you on RedHat support?

This is a problem with the linux kernel that was addressed recently,
iirc. Large amounts of io from a single process can swamp the queue, and
the latest kernels have it fixed.

If you've got RH support, see if you can find out if that's been
backported into your kernel.

Cheers,
Wol
  
 From: perry.tay...@zirmed.com
 To: u2-users@listserver.u2ug.org
 Date: Mon, 4 Feb 2013 20:53:13 +
 Subject: Re: [U2] [UV] Large File Operations Kill Linux

 We're on RHEL5 (2.6.18-348.el5), ext3 and 132GB ram.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
 Sent: Monday, February 04, 2013 9:23 AM
 To: 'U2 Users List'
 Subject: Re: [U2] [UV] Large File Operations Kill Linux

  A few questions - What linux version/distro are you on and what type of
 file system, and how much ram do you have

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
 Sent: 04 February 2013 15:57
 To: U2-Users List
 Subject: [U2] [UV] Large File Operations Kill Linux

 Looking for some ideas on how to keep Linux from becoming largely
 unresponsive when creating large files.  What happens is as the new file is
 being created the I/O buffer cache quickly fills up with dirty buffers.
 Until the kernel can flush these out to disk there is no avail buffers for
 I/O operations from other processes.  .  The most troubling manifestation of
 this is the transaction logging check point daemon gets *way* behind putting
 us as risk if we were to have a failure of some kind.

 I have tried using ionice and renice to slow the file creation down as much
 as possible.  This help a little but is still a big problem.  Any ideas how
 to get CREATE.FILE/RESIZE to play nice on Linux?

 Thanks.
 Perry
 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Triggers in Universe

2013-01-25 Thread Perry Taylor
You can globally catalog in a Pick-flavored account.  Copy the CATALOG VOC 
record from the UV account to your Pick-flavored account VOC renaming it 
something like ICATALOG.  We do it all the time for our file-based triggers.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Friday, January 25, 2013 3:03 PM
To: U2 Users List
Subject: Re: [U2] Triggers in Universe

The problem was the locally cataloged program.I was in an account that
is PICK flavor and wouldn't allow global cataloging.  When I catalog the
program globally from the UV account the CREATE TRIGGER now works.   Thanks!





On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob bob_woodw...@k2sports.comwrote:

 In Unidata the problem would be that the trigger has to be cataloged
 globally, not locally.  I'm not sure how to do that in Universe, though.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:
 u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
 Sent: Friday, January 25, 2013 1:33 PM
 To: U2 Users List
 Subject: [U2] Triggers in Universe

 I'm up against a wall here - trying to use triggers for the first time, on
 Universe.  Can't seem to get my test to work -

 Universe on AIX:

  RELLEVEL
 001 X
 002 11.1.9
 003 PICK
 004 PICK.FORMAT
 005 11.1.9

 BASIC BDW TRIGTEST
 Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST'
 *

 Compilation Complete.

 CATALOG BDW TRIGTEST
 TRIGTEST cataloged.

 .L TRIGTEST

  TRIGTEST
 001 V
 002 BDW.O/TRIGTEST
 003 B
 004 BNP
 005
 006 PICK.FORMAT
 007 S²N²P²I²A²E²H
 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP
 009 BDW.O


 CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR
 EACH ROW CALLING 'TRIGTEST';
 Unable to locate trigger program BDW.O/TRIGTEST.
 


 --

 

 *Bobby D. Worley*

 IT Applications Developer

 Coburn Supply Company

 o: 903.753.8613 | m: 214.676.9825

 bwor...@coburns.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




-- 



*Bobby D. Worley*

IT Applications Developer

Coburn Supply Company

o: 903.753.8613 | m: 214.676.9825

bwor...@coburns.com

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Inverting/Pivoting a table

2012-09-11 Thread Perry Taylor
Just a little curiosity... ADP, in their flavor of Reality, has a user exit 
that did exactly this kind of transformation.  Was kind of handy.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Tuesday, September 11, 2012 11:49 AM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

SPLICE ... now THAT'S a cool little tool! I'll have to do some testing
with null attributes and values, but this just may work!

Thank you Rex and Stuart!

Sincerely,
David Laansma

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar
Sent: Tuesday, September 11, 2012 1:08 PM
To: U2 Users List
Subject: Re: [U2] Inverting/Pivoting a table

Not a function, but there are some subroutines that flip posted on
PickWiki:

http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col

AND

http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col_II

rex
___
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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Running a command in a different account

2012-07-27 Thread Perry Taylor
I do this all the time...

READV ACCT.PATH FROM F.UV.ACCOUNT, ACCOUNT.NAME, 11 ELSE STOP 202, ACCOUNT.NAME

CMD = sh -c\cd ': ACCT.PATH: '  : SYSTEM(32): /bin/uv : PROGRAM.NAME: 
\

EXECUTE CMD CAPTURING OUTPUT


Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com
Sent: Friday, July 27, 2012 9:42 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Running a command in a different account

Greetings!

 

We have a program that runs in one account, but under certain conditions it
is becoming necessary for that program to execute a command in another
account, and then continue on its merry way doing other things.  One fairly
simplistic example might be that the process might find it necessary to
create a file in another account.

 

We have come up with a number of different ways of accomplishing this, but
all involve a phantom LOGTO of some sort -whether it be through working
with the UV.ACCOUNT file, the LOGIN paragraph, or some combination of the
above.  While this will do what is necessary, there are timing issues to
consider, control and response issues, error checking, etc.  It can be done,
but it's not pretty.

 

Does anyone have a more elegant and efficient way of accomplishing this?

 

Thanks in advance!

 

Brian F. Paige



 


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _

The information transmitted is intended only for the person or entity to which 
it is addressed and may contain confidential and/or privileged material not 
intended for Public use.  
Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is 
strictly prohibited. If you received this communication in error, please notify 
the sender and delete the material from any and all computers or devices.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

2012-06-04 Thread Perry Taylor
If someone has already suggested this then forgive me as I haven't been 
following this discussion in great detail.

Since you are handling the records in a dimensioned array you can RAISE() each 
element, process each element as attributes where field caching will come into 
play, then LOWER() them prior to writing them to disk.  You should be amazed at 
how much faster this can be.

Assuming all elements of the array are multivalued (if not you'll have to hard 
code which elements are multivalued) ...

MATREADU DX FROM .
DX.ELEMENTS = INMAT()   
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = RAISE(DX(AMC))
NEXT AMC
... Process them as attribute-delimited arrays
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = LOWER(DX(AMC))
NEXT AMC

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, June 04, 2012 2:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)


Equating doesn't reserve a spot, so I assume you mean dimensioning reserves 
a spot
All equating does is, at compile time, it replaces one variable name with 
another.
It has no effect at run time.



-Original Message-
From: Nick Gettino nick.gett...@enroute911.com
To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org
Sent: Mon, Jun 4, 2012 1:07 pm
Subject: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)



s John stated we use dimensioned arrays but we also equate each attribute which 
eserves a spot for the piece of data making it tremendously faster updating.

Nicholas M Gettino, Director of Professional Services  Support, EnRoute 
mergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, 
uite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX 
678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of u2-users-requ...@listserver.u2ug.org
ent: Friday, June 01, 2012 3:00 PM
o: u2-users@listserver.u2ug.org
ubject: U2-Users Digest, Vol 38, Issue 1
Send U2-Users mailing list submissions to
u2-users@listserver.u2ug.org
To subscribe or unsubscribe via the World Wide Web, visit
http://listserver.u2ug.org/mailman/listinfo/u2-users
r, via email, send a message with subject or body 'help' to
u2-users-requ...@listserver.u2ug.org
You can reach the person managing the list at
u2-users-ow...@listserver.u2ug.org
When replying, please edit your Subject line so it is more specific
han Re: Contents of U2-Users digest...

oday's Topics:
   1. Monthly Multivalue Inserts and Speed (Dave Laansma)
  2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.)
  3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
  4. Re: Monthly Multivalue Inserts and Speed (Dave Davis)
  5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
  6. Re: Monthly Multivalue Inserts and Speed (Wols Lists)
  7. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  8. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
 10. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
 11. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
 12. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)

-
Message: 1
ate: Fri, 1 Jun 2012 10:29:55 -0400
rom: Dave Laansma dlaan...@hubbardsupply.com
o: U2-Users@listserver.u2ug.org
ubject: [U2] Monthly Multivalue Inserts and Speed
essage-ID:
071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com
ontent-Type: text/plain;charset=us-ascii
I have a file that is taking a very long time to update, seemingly
onger and longer each month. Here is briefly how the attributes are
rganized, a relatively simple example:
 
Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
2-03 etc.
Attributes 2 through 30 are dependent on attribute 1 and contain a
ariety of dollar amounts that are accumulated for the respective period
n attribute 1.
 
At the end of each month, a new G/L Period is inserted into the
ultivalued position of attribute 1 as well as each of the respective
ultivalued positions in attributes 2 through 30. Nothing complicated.
 
My question is this and is aimed largely at the technicians at Rocket
..
 
If, at the beginning of the year, I were to insert each of the
2-periods into their respective multivalues in attribute 1 and insert
espective null multivalues into attributes 2 through 30, thus
erforming all of the 'inserts' at once, will the processing each month
un faster as numbers are simply accumulated into attributes 2 through
0 and no inserting of new multivalues will have to be performed?
 
A couple

Re: [U2] YYMMDD easy way?

2012-04-25 Thread Perry Taylor
RHEL5

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Wednesday, April 25, 2012 8:30 AM
To: U2 Users List
Subject: Re: [U2] YYMMDD easy way?

me:  Win 2003
Perry? 10.2? 10.3?  Redhat?

I'd sure like to know what makes the difference.
I'd hate to get bit - again! - in a migration or upgrade.
The worst fall-out I ever had in an upgrade was when they changed an 
obscure FMT code without telling anyone.

On 4/25/2012 9:07 AM, Rick Nuckolls wrote:
 If not flavor, then hardware/os?

 (Sparc/Solaris)

 -Rick

 On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote:

 On my UV10.2.10 it behaves properly only with [2'',2''], as Richard
 Perry describe.

 OCONV( 16187, DYMD['',''] )   = 2012425
 OCONV( 16187, DYMD[2'',2''] ) = 120425

 Like Rick, I find flavor does not matter.
 On 4/24/2012 7:38 PM, Rick Nuckolls wrote:
 That was my thought, but the flavor does not seem to affect it on my 
 version.

 -Rick

 On Apr 24, 2012, at 5:36 PM, Richard Lewis wrote:

 Or maybe it's my Pick flavor.

 Richard Lewis

 On Tue, Apr 24, 2012 at 6:27 PM, Rick Nuckollsr...@lynden.com   wrote:

 Hmmm,

 That must be a change at UV 11.  10.2.x still produces 2 digit months and
 days without the extra 2's.

 -Rick


 On Apr 24, 2012, at 5:21 PM, Richard Lewis wrote:

 On UV 11.1.3 this leaves single-digit months as a single digit.

 OCONV(TODAY, 'DYMD[2,2,2]') does the job correctly.  The brackets
 allow
 format modifiers to the parameters that follow the D conversion code, in
 this case, 'YMD'.  The 2's specifiy how many characters to display, and
 the
 empty quotes specify the 'text' with which to separate the elements.
 There's about 80 lines that describe it when you do HELP CONV D at TCL.

 Richard Lewis


 On Tue, Apr 24, 2012 at 6:08 PM, Rick Nuckollsr...@lynden.com   wrote:

 Or, a bit more simply:

 OCONV(TODAY, D2YMD['' , ''])
 On Apr 24, 2012, at 4:58 PM, Perry Taylor wrote:

 OCONV(TODAY, 'DYMD[4,2,2]')


 - Original Message -
 From: Lunt, Bruce [mailto:bl...@shaklee.com]
 Sent: Tuesday, April 24, 2012 07:55 PM
 To: 'U2 Users List'u2-users@listserver.u2ug.org
 Subject: Re: [U2] YYMMDD easy way?

 On Unidata try: OCONV(TODAY,'DYMD')

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
 Sent: Tuesday, April 24, 2012 4:52 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] YYMMDD easy way?



 YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')

 easier way to do this? ___


 ___
 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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] YYMMDD easy way?

2012-04-24 Thread Perry Taylor
OCONV(TODAY, 'DYMD[4,2,2]')


- Original Message -
From: Lunt, Bruce [mailto:bl...@shaklee.com]
Sent: Tuesday, April 24, 2012 07:55 PM
To: 'U2 Users List' u2-users@listserver.u2ug.org
Subject: Re: [U2] YYMMDD easy way?

On Unidata try: OCONV(TODAY,'DYMD')

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, April 24, 2012 4:52 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] YYMMDD easy way?



YYMMDD = OCONV(TODAY,'DY2'):OCONV(TODAY,'DM'):OCONV(TODAY,'DD')

easier way to do this? ___
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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Case Statement with only two cases

2012-04-20 Thread Perry Taylor
I wonder if we've already wasted more electrical  biological energy by 
me writing this email, dispersing it around the globe, and you reading 
it, than all the machine cycles wasted executing the 2 worthless tests 
in all the object scattered around the universe that Rocket could 
theoretically optimize.  cds

Amen!

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Friday, April 20, 2012 7:28 AM
To: U2 Users List
Subject: Re: [U2] Case Statement with only two cases

A respectful correction, Brian.

On 4/20/2012 4:50 AM, Brian Leach wrote:
 it's all the same to the compiler.
 -Original Message-
 BEGIN CASE
CASE A = TEST; GOSUB DO.SOMETHING
CASE 1; GOSUB DO.SOMETHING.ELSE
 END CASE
 versus this
 IF A = TEST THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE
-

Since we seem to be finding every nit in the bottom of this empty 
barrel, here's one more.
There are 2 compiler difference as shown by VLIST (UV10.2):

1: BEGIN CASE

2:CASE A = TEST; GOSUB DO.SOMETHING
2 0 : 06E eq A TEST  = $R0
2 8 : 2DE testfw $R0 00020:
2 00010 : 0A4 gosub  00060:


3:CASE 1; GOSUB DO.SOMETHING.ELSE
3 00018 : 0C2 jump   00038:
3 00020 : 2DE testfw 1 00038: -- Extra 
worthless test
3 00028 : 0A4 gosub  00062:

4: END CASE
4 00030 : 0C2 jump   00038: -- Extra worthless 
jump (to next line)
   
(Source lineup is goofy.  This jump is really part
 
of source line 3.   RAID is confusing, too.
A 
discussion for a different thread.)

5: IF A = TEST THEN GOSUB DO.SOMETHING ELSE GOSUB DO.SOMETHING.ELSE
5 00038 : 06E eq A TEST  = $R0
5 00040 : 2DE testfw $R0 00058:
5 00048 : 0A4 gosub  00060:
5 00050 : 0C2 jump   00060:
5 00058 : 0A4 gosub  00062:

6: STOP
6 00060 : 190 stop


With the speed of today's machines it would be hard to find a place 
where that performance makes a difference.

Rocket could theoretically clean up both (or either independently) if 
the compiler was smart enough:

1. to know that a logical test outcome was predestined at compile time 
(It already does that sort of thing in other situations.).  Then it 
could  compile only 1 of the 2 paths the testfw takes.  (e.g. 0020x).  
Same for IF,  WHILE, or UNTIL constructs.

2. To recognize the final CASE before the END CASE never needs to jump 
(e.g., 0030x).

I wonder if we've already wasted more electrical  biological energy by 
me writing this email, dispersing it around the globe, and you reading 
it, than all the machine cycles wasted executing the 2 worthless tests 
in all the object scattered around the universe that Rocket could 
theoretically optimize.

cds


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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] COMMON Size MisMatch

2012-04-12 Thread Perry Taylor
Do you need to use LOGTO.ABORT perhaps instead of LOGTO?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, April 12, 2012 1:08 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] COMMON Size MisMatch


If you *do* use CLEARCOMMON you have to be alert to gremlins as well.
LOGTO is not expecting to have to reinitialize the system and so probably 
doesn't.
You need to review what the Login process is doing as well.
You may end up wiping out control information such as the user's port, name, 
login time, functions they can and can't do, menu access, default printer, and 
so on and so forth.

All depends on how complex the login processor has become at your site.
Some sites don't do a darn thing.  Some have thousands of lines of code at 
Login.  Some of which set common (read environment) variables, that you 
*don't want* to clear, or at least that you want to reset if you do clear them.





-Original Message-
From: Bill Brutzman bi...@hkmetalcraft.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, Apr 12, 2012 11:52 am
Subject: Re: [U2] COMMON Size MisMatch


Eating my own dog food... I cranked CLEARCOMMON into the LOGTO SandBox   and  
OGTO LIVE   paragraph commands.
--Bill
From: u2-users-bounces at listserver.u2ug.org
mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of
on_Bausili at hcsc.net
ent: Thursday, July 16, 2009 10:17 AM
o: u2-users at listserver.u2ug.org
ubject: [U2] Fw: COMMON misMatch
Since all common variables are cleared when you exit UniVerse, and
liminates the error, is it possible your user used a LOGTO command to
witch environments that have different versions of the subroutine
OP.R87?
We had both a Test and a Prod environment on the same box, and
xperienced problems when enhanced code in Test was being staged for
romotion into Prod.  Executing a program in Test that had changes to
ts COMMON, and then logging into Prod resulted in the size mismatch
rror when running the unchanged program.
Our solution was to insert CLEARCOMMON in the LOGIN paragraphs.
Don
 Forwarded by Don Bausili/OK/HCSC on 07/16/2009 09:09 AM -
Brutzman, Bill BillB at hkMetalCraft.com Sent by:
2-users-bounces at listserver.u2ug.org
7/15/2009 06:55 PM
lease respond to
U2 Users List u2-users at listserver.u2ug.org

o
U2 Users List u2-users at listserver.u2ug.org
c
Subject
e: [U2] COMMON misMatch



A user here obtained an error message...
 COMMON size mismatch in subroutine HOP.R87.
Upon logging out and then logging back in again... The HOP program was
ble to launch without this error.
Help with a diagnosis and more reliable cure would be appreciated.
This user is WinXP / Dynamic Connect / UniVerse 10.1 / HP-Ux 11i v2.
--Bill
___
2-Users mailing list
2-Users at listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
The information contained in this communication is confidential,
rivate,
roprietary, or otherwise privileged and is intended only for the use of
he addressee.  Unauthorized use, disclosure, distribution or copying is
trictly prohibited and may be unlawful.  If you have received this
ommunication in error, please notify the sender immediately at (312)
53-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
klahoma; or (972)766-6900 in Texas.
__
2-Users mailing list
2-Users at listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
revious message: [U2] Fw: COMMON misMatch
ext message: [U2] Universe Retrieve
essages sorted by: [ date ] [ thread ] [ subject ] [ author ]
ore information about the U2-Users
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Bill Brutzman
ent: Thursday, April 12, 2012 2:40 PM
o: U2 Users List
ubject: [U2] COMMON Size MisMatch
... in subroutine named XYZ.R1.
While I would like to pass parameters back-and-forth invoking bona fide 
external 
ubroutines using commands such as... CALL *MY.SUB.R2(param1, param2, 
rrorString)
...I have a few big old legacy programs with nasty COMMON tentacles.
How can I make these pesky COMMON messages go away?
--Bill
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 

[U2] [UV] Install as root vs uvadm

2012-01-20 Thread Perry Taylor
I'm getting ready to install UniVerse on a new server and am questioning my 
past decision to install as uvadm rather than root.  I'm not sure that 
installing as uvadm has really been of any benefit.  Anyone want to comment on 
your experiences using uvadm vs root?

Thanks.

Perry
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Install as root vs uvadm

2012-01-20 Thread Perry Taylor
Thanks to all for your thoughts.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Friday, January 20, 2012 12:59 PM
To: U2 Users List
Subject: Re: [U2] [UV] Install as root vs uvadm

And yes the Rocket installer, should do all this crap for you, but, it
doesn't, shame on them :(

On Fri, Jan 20, 2012 at 2:53 PM, John Thompson jthompson...@gmail.comwrote:

 Assuming you are on a *nix system...

 If you want to install as uvadm, do the following:

 Create a user called uvsql
 (In RHEL, use the GUI.  In AIX, use smit)

 Create a user called uvadm.
 (In RHEL, use the GUI.  In AIX, use smit)

 If a group called uvadm, did not get created with the user, create a group
 called uvadm.
 (In RHEL, use the GUI.  In AIX, use smit)

 Then create the /usr/uv directory.
 mkdir /usr/uv

 Now set the permissions for it:
 chown -R uvadm:uvadm /usr/uv

 Now set the sgid, to control the group ownership of files that get created
 in the /usr/uv directory.
 chmod g+s /usr/uv

 Now login as uvadm and run the install process.

 When it completes it will have you do the last little bit as root.
 Simply login as root and do what it tells you.

 Now when you add your account data/files/programs, do the following.

 Create your users.
 Create a group called uvusers.

 Make your directory where your accounts reside.
 For example:
 mkdir -p /uvdata/accts/SOMEACCOUNT

 chown -R username:uvusers /uvdata/accts/SOMEACCOUNT
 chmod -R 774 /uvdata/accts/SOMEACCOUNT
 chmod g+s /uvdata/accts/SOMEACCOUNT

 Wala, permissions problems solved :)

 On Fri, Jan 20, 2012 at 2:37 PM, Bertrand, Ron bertran...@ghc.org wrote:

 We had multiple permission problems when we installed universe 11.3 as
 uvadm. Had to emergency re-install as root.

 Ron Bertrand | ANALYST,AP SYS 3
 ISD, Group Health Cooperative
 PHONE 206-901-4519
 CELL 206-605-9027
 E-MAIL bertran...@ghc.org

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:
 u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
 Sent: Friday, January 20, 2012 11:12 AM
 To: U2 Users List
 Subject: [U2] [UV] Install as root vs uvadm

 I'm getting ready to install UniVerse on a new server and am questioning
 my past decision to install as uvadm rather than root.  I'm not sure that
 installing as uvadm has really been of any benefit.  Anyone want to comment
 on your experiences using uvadm vs root?

 Thanks.

 Perry
 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/



 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
 is for the sole use of the intended recipient(s) and may contain
 confidential and privileged information.  Any unauthorized review, use,
 disclosure or distribution is prohibited. ZirMed, Inc. has strict policies
 regarding the content of e-mail communications, specifically Protected
 Health Information, any communications containing such material will be
 returned to the originating party with such advisement noted. If you are
 not the intended recipient, please contact the sender by reply e-mail and
 destroy all copies of the original message.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users

 GHC Confidentiality Statement

 This message and any attached files might contain confidential
 information protected by federal and state law. The information is intended
 only for the use of the individual(s) or entities originally named as
 addressees. The improper disclosure of such information may be subject to
 civil or criminal penalties. If this message reached you in error, please
 contact the sender and destroy this message. Disclosing, copying,
 forwarding, or distributing the information by unauthorized individuals or
 entities is strictly prohibited by law.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users




 --
 John Thompson




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


[U2] [UV} PORT.STATUS Instruction Number

2011-12-12 Thread Perry Taylor
Does anyone know what it means when PORT.STATUS provides a ridiculously high 
instruction number?  Here is an example...

  Pid  User name.  Printer Segment  Last command 
processed
28044  perryt  0xACEB9274  PTEST [ PTEST @ 0xF7746390 ]

VLIST of PTEST reveals that the highest instruction number is 0x8B0.  Is 
PORT.STATUS just stupid or does this big number mean something?

Thanks.

Perry
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/




CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] I-Type question in PH

2011-11-29 Thread Perry Taylor
If you don't want to mess with the nuances of the PH ID you can call a 
subroutine which does an OPENSEQ then uses STATUS to get the modification date 
right from the file system.

Perry

- Original Message -
From: Charles Stevenson [mailto:stevenson.c...@gmail.com]
Sent: Tuesday, November 29, 2011 05:20 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: Re: [U2] I-Type question in PH

You can also get elapsed time by subtracting that ID date-time stamp 
from the os's date-time-modified stamp, which is when the job ended. (if 
the job writes to the PH log as it ends.)

On 11/29/2011 4:01 PM, John Thompson wrote:
 Yep... need more sleep.  Thanks.

 On Tue, Nov 29, 2011 at 4:58 PM, Wjhonsonwjhon...@aol.com  wrote:

 Third field, not second field
 FIELD(@ID,'_',3)









 -Original Message-
 From: John Thompsonjthompson...@gmail.com
 To: U2 Users Listu2-users@listserver.u2ug.org
 Sent: Tue, Nov 29, 2011 1:54 pm
 Subject: [U2] I-Type question inPH


 So I thought I would build an I-type to get the date of thePH  items in
 niverse so I could more easily purge them...
 The item id looks like so:
 AUTOMATED.UPDATE.REO_23400_15641
 The friendly manual says that the item id is:
 hantomverb_time_date
 So my I-type looks like so:
 001 I
 02 FIELD(@ID,'_',2)
 03
 04 Date
 05 10
 06 R
 And of course, I have not put in the conversion code yet...
 The output of the I-type is this:
 ID..
 Date..
 AUTOMATED.UPDATE.REO_23400_15641 23400.0
 What am I missing?
 Shouldn't Date be 15641?
 --
 ohn Thompson
 __
 2-Users mailing list
 2-us...@listserver.u2ug.org
 ttp://listserver.u2ug.org/mailman/listinfo/u2-users

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




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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] Suppress not found in RetrieVe

2011-11-15 Thread Perry Taylor
Does anyone know of a RetrieVe option that will suppress the ' not found' 
messages?

Thanks.

Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Suppress not found in RetrieVe

2011-11-15 Thread Perry Taylor
That's the idea.  The problem I have is records are being deleted from the file 
at all times of the day.  What happens is the initial select picks up records 
that get deleted before they are output.  I was hoping there was some option 
that would suppress these messages.  If there is not I'll probably have to 
rewrite this query in BASIC where I have control.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, November 15, 2011 2:01 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Suppress not found in RetrieVe


I think he means as in

SELECT VOC SAMPLE 100
LIST CUSTOMER
'A' not found
'F2' not found


And I don't know a way to suppress the messages, but I know a way to not GET 
the messages :)
Try this

SELECT VOC SAMPLE 100
SELECT CUSTOMER
do other selects or other processing now and you won't get that message




-Original Message-
From: John Thompson jthompson...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Nov 15, 2011 10:57 am
Subject: Re: [U2] [UV] Suppress not found in RetrieVe


Do you mean on a SELECT or LIST?  (Maybe I'm asking the obvious)
On Tue, Nov 15, 2011 at 1:43 PM, Perry Taylor perry.tay...@zirmed.comwrote:
 Does anyone know of a RetrieVe option that will suppress the ' not
 found' messages?

 Thanks.

 Perry

 Perry Taylor
 Senior MV Architect
 ZirMed
 888 West Market Street, Suite 400
 Louisville, KY 40202
 www.zirmed.comhttp://www.zirmed.com/



 CONFIDENTIALITY NOTICE: This e-mail message, including any
 attachments, is for the sole use of the intended recipient(s)
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is
 prohibited. ZirMed, Inc. has strict policies regarding the
 content of e-mail communications, specifically Protected Health
 Information, any communications containing such material will
 be returned to the originating party with such advisement
 noted. If you are not the intended recipient, please contact
 the sender by reply e-mail and destroy all copies of the
 original message.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users


-- 
ohn Thompson
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

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


Re: [U2] UniBasic Question

2011-10-24 Thread Perry Taylor
I have gotten around this lack of control in BASIC by EXECUTEing a program that 
does the display.  If the user gets to the end of the listing or they quit out 
control comes back to the main program in any case.  Not very elegant but I 
don't think there is a way to trap when a user Quits out.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
Sent: Monday, October 24, 2011 9:29 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniBasic Question


The subroutine does an execute 'Select ', then it processes each record 
using a LOOP/READNEXT structure, seleectively printing lines that meet my 
criteria - so no LIST is executed.  It would definitely seem that HEADING is 
the culprit.  Any UDT.OPTIONS that migth be influencing the behavior?
  From: syme...@gmail.com
 To: u2-users@listserver.u2ug.org
 Date: Mon, 24 Oct 2011 16:20:10 +0100
 Subject: Re: [U2] UniBasic Question
 
 Is this unibasic doing an execute and the 'report' done using a List command
 ?
 
 
 
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
 Sent: 24 October 2011 16:13
 To: u2-users@listserver.u2ug.org
 Subject: [U2] UniBasic Question
 
 
 
 
 
 Unidata 7.1 on RHEL, Pick mode. I have a subroutine that displays parts with
 declining sales.  I am using a HEADI\NG command for multiple pages.
 Everything is fine, except if the user chooses to stop a multi-page listing
 early by typing Q to Enter New line to continue... prompt. In that case,
 the subroutine AND the calling program terminate and I find myself at ECL.
 WTF!
 Can anyone help explain this behavior or offer a workaround that saves me
 from handling it with line counters and printing my own
 headings?Cheers,Kebbon  
 ___
 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: 1522/3970 - Release Date: 10/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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Question about accessing external SQL database

2011-10-05 Thread Perry Taylor
We used EasySoft's ODBC driver with good success and I think it was quite a bit 
less expensive than the bridge.

Perry
Zirmed. Inc

- Original Message -
From: Jason Lin [mailto:temp...@ucla.edu]
Sent: Wednesday, October 05, 2011 08:01 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: [U2] Question about accessing external SQL database

Hi,

I am exploring a good way to access data on an external SQL database  
from our Universe (10.2.7) environment running on HP-UX (11.23).

I personally prefer to use SOAP API in Universe BASIC to query the  
database provided the appropriate web service is available.  However,  
the owner of the SQL database prefer not to create web services for  
this purpose because his dept will need to maintain an additional web  
server.  (Alternatively, we could create our own web service on a  
Windows 2003 server which can connect to the SQL database server  
directly).

Instead, he offers two options: direct database connection to SQL  
database (possibly via ODBC) or RPC.

I'm not familiar RPC in Universe but after reading documentation on  
RPC.CONNECT and RPC.CALL functions, it looks like they were designed  
for Universe to Universe (or Universe to Unidata) type of remote  
procedure call.  Is that correct?

So the only other option is to use SQL/ODBC.  After reading some  
archived message from this mailing list, it looks we would need to  
install a third party ODBC bridge/manager.  Several messages  
recommended Easysoft ODBC-ODBC Bridge but Easysoft lists its price at  
$2000!

Does anyone know if there any other ways of accessing external SQL  
database from Universe?

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-13 Thread Perry Taylor
Hrm... no bites??

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Thursday, September 08, 2011 10:11 AM
To: U2 Users List
Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE

I have a need to add an additional value to a multi-valued field on a bunch of 
records.  I was hoping I could do this using SQL UPDATE but it appears you have 
to explicitly list all the muli-values...

UPDATE FILE SET MVFIELD = 'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE';

Anyone know of way to append a new value using UPDATE?

Thanks.

Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
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] [UV] Adding a multi-value using SQL UPDATE

2011-09-13 Thread Perry Taylor
Yeah I figured I could do it with a prestore in the editor... I was just hoping 
there was away to do it using SQL.

Thanks.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes
Sent: Tuesday, September 13, 2011 7:33 AM
To: 'U2 Users List'
Subject: Re: [U2] [UV] Adding a multi-value using SQL UPDATE

Perry,

Using the AE editor, you could create a pre-stored command that will execute in 
a loop.

This assumes that you will append a specific string constant or same numeric 
value to the same field, in every record.

If you need help loading a prestore, then executing in a loop, feel free to tap 
me off line (unless others want to read or contribute to this thread).

Thank you.
-Baker



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Tuesday, September 13, 2011 8:27 AM
To: U2 Users List
Subject: Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

Hrm... no bites??

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Thursday, September 08, 2011 10:11 AM
To: U2 Users List
Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE

I have a need to add an additional value to a multi-valued field on a bunch of 
records.  I was hoping I could do this using SQL UPDATE but it appears you have 
to explicitly list all the muli-values...

UPDATE FILE SET MVFIELD = 'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE';

Anyone know of way to append a new value using UPDATE?

Thanks.

Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Adding a multi-value using SQL UPDATE

2011-09-13 Thread Perry Taylor
Wow!  Thank you Andy.  I was focused in on UPDATE and never thought to look 
into INSERT for updating an existing record.

Thank you so much!

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum
Sent: Tuesday, September 13, 2011 10:25 AM
To: U2 Users List
Subject: Re: [U2] [UV] Adding a multi-value using SQL UPDATE

Perry,


You need to do this by using the Dynamic Normalisation and INSERT.


INSERT INTO FILE_MVFIELD (@ID, MVFIELD) VALUES ('KEY', 'THE.NEW.VALUE')


More details can be found in the SQL User Guide Chapter 5.


HTH,

Andy






From: Perry Taylor perry.tay...@zirmed.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tuesday, 13 September 2011, 14:26
Subject: Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

Hrm... no bites??

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Thursday, September 08, 2011 10:11 AM
To: U2 Users List
Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE

I have a need to add an additional value to a multi-valued field on a bunch of 
records.  I was hoping I could do this using SQL UPDATE but it appears you have 
to explicitly list all the muli-values...

UPDATE FILE SET MVFIELD = 'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE';

Anyone know of way to append a new value using UPDATE?

Thanks.

Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
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] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-08 Thread Perry Taylor
I have a need to add an additional value to a multi-valued field on a bunch of 
records.  I was hoping I could do this using SQL UPDATE but it appears you have 
to explicitly list all the muli-values...

UPDATE FILE SET MVFIELD = 'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE';

Anyone know of way to append a new value using UPDATE?

Thanks.

Perry

Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.comhttp://www.zirmed.com/



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - Experiences?

2011-09-01 Thread Perry Taylor
I can't speak to 11.1 but we are running 10.2.7 just fine on RHEL 64bit.

Perry

- Original Message -
From: John Thompson [mailto:jthompson...@gmail.com]
Sent: Thursday, September 01, 2011 06:02 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: [U2] Red Hat Enterprise Linux 64 bit and Universe 11.1.4 - 
Experiences?

I'm looking to migrate from AIX 5.3 to RHEL.  Basically because IBM is
putting the hatchet to regular support on AIX 5.3 in May 2012.

Has anyone had any experiences/challenges running Universe 11.1.4 on Red Hat
Enterprise 6 - 64bit?

I'm guessing I may get crickets on this one, since accroding to U2
Techconnect, 11.1.4 has only been out about a week...

https://u2tc.rocketsoftware.com/buildmatrix.asp

Kudos to Rocket for getting it to run on RHEL 6.

I'm just scared if I go with RHEL 5, then I'll be in the obsolescence boat
two years from now.

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Stuck getting started with DataVu

2011-08-24 Thread Perry Taylor
I had the very same problem when I last tried it a few weeks ago.  Got 
discouraged and gave up :(

Perry

- Original Message -
From: Oaks, Harold [mailto:harold.o...@clark.wa.gov]
Sent: Wednesday, August 24, 2011 11:56 AM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: [U2] Stuck getting started with DataVu

Anybody using DataVu?  Rocket's free data viewer?  I think this is a
tool my users might like, if I can only get it to work!

But I can't get past a seemingly beginning point...

I have created a repository.
I can now define a new U2 data source.  After entering the server name,
Universe login and password, testing that the connection is good, I am
then able to pick an account as the data source (The list shown surely
comes from the UV.ACCOUNT file).  Fine.  Seemingly the data source is
now defined, call it MyDataSource.

The 'repositories' view shows this tree:

[-] MyRepository
[-] U2 Data Sources
[-] MyDataSource
[+] Files

Now, if I click on the [+] next to Files, I expect it to expand with the
available files making use of the VOC file to know what these are.  But
it simply flashes 'pending' for about 1/2 a second and becomes 'Files'
with no [-] or [+] next to it.

What step am I missing?  Does there need to be some special VOC record
created in the account?

I am thinking perhaps the JDBC drivers are not known to DataVu, and that
is the problem.  The documentation states that U2 DataVu does not
include JDBC drivers, however it states that one can import the JDBC
library settings file.  To do this, it says, one clicks on File -
Import - Connection and JDBC Library Settings, etc.  However! After
clicking on File, there is no Import selection available at all in the
drop down.  (I just hate it when the documentation doesn't match the
product!).  

Has anyone gotten past these issues?  Does anyone actually use this
product?
I might mention that I am also looking at the Web Services product from
Rocket.  After specifying an account and clicking on Database Files it
instantly displays all the available files in the account.  Which is
good.

Thanks-
Harold Oaks
Clark County IT
Clark County, WA







This e-mail and related attachments and any response may be subject to public 
disclosure under state law.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Microsoft Team Foundation Server for Source Control

2011-08-23 Thread Perry Taylor
Thanks to everyone for some very interesting points.  I am particularly 
intrigued by Stuart's handling of dictionaries using triggers.  One particular 
challenge I may face is one particular hashed file (not a dictionary) which 
contains 2 1/2 million records that are under source control today.  Copying 
them out to a directory might pose some problems with inode consumption.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Friday, August 19, 2011 11:10 PM
To: U2 Users List
Subject: Re: [U2] [UV] Microsoft Team Foundation Server for Source Control

Hi Perry,
I use Perforce (P4) - similar (but different). Not sure what best practice is 
for TFS repositories is but with P4 and other Source Control (SC) systems 
something like the following should work.

//function/branch/path/item

1. Starting with a functional area - a project or a defined set of artefacts 
which make a up a particular system (eg Payroll)
2. branch - this is usually MAIN (eg the current, main or head version) - we 
occasionally have different branch versions for Australia  NZ or for a release 
branch. A commercial software developer would probably keep their major 
releases in different branches.
3. path - you should probably just start at the account directory. So if your 
complete path to the payroll account was: /usr/uvaccs/dev/perry/payroll/.. you 
would start at the *../payroll/..* level of the path and ignore the stuff 
before it. 
Not sure how TFS maps to the workspace, but I guess that you are able to give 
it a relative path like most SC systems.
4. The item under control.

So you might end up with //Payroll/MAIN/PAYROLL/PAY.BP/PRINT.PAYSLIPS

Also, not sure how TFS handles case sensitivity - this would be an issue if it 
regards Payslip  PAYSLIP as the same item.

As far as hashed item go: convert everything you need to control to type 19 
directory files (except dictionaries - see below). 
Why? Because you should only need to do this in dev. For all other environments 
the items should only be copied in (deployed) from a release file - so will be 
able to be plonked into hashed files by UV copy.

If you can't convert them for some reason (like you have binary in them?!), 
you'll probably need to put a trigger onto your hashed files to manage the 
controlled items.

Dictionaries - have to be hashed because otherwise I-types won't compile or 
work. So, I have a trigger for the dictionary that writes out the item to a 
type 19 file under source control. It truncates the I-type attributes after 
about att 10 so you don't get the binary in the repository. It also manages 
which SB+ items get put in and out of SC.
If the item is not checked out from SC for edit before you try to edit the 
dictionary, the trigger will rollback the copy and gracefully tell you that you 
need to check out the item before editing it. On save it updates the type 19 
copy after which it needs to be checked in.
In my case I have 1 file set up for all the dictionary items. I use an assigned 
key and a lookup file to manage them. The thinking behind it was to reduce the 
number of folders to manage in SC. In practice it probably doesn't matter, if 
you have lots of dictionary folders or one folder with lots of items as we do.

Release strategy. I use a program, but we also looked at make and the 
Perforce equivalent. These are nice because they can check dependencies - 
however, it was overkill for us so I just have a program that copies everything 
from a 'drop' location into the target system and compiles and runs any setup 
programs.

Hope that helps,
Stuart

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Saturday, 20 August 2011 00:57
To: U2-Users List
Subject: [U2] [UV] Microsoft Team Foundation Server for Source Control

Has anyone had any experience using Microsoft's Team Foundation Server for 
source control with UniVerse on a Linux server?  I have the command line client 
functional and talking to the TFS server.  I know I'll have to write some kind 
of interlude to manage those items in hashed files to get them out into the 
file system where they will be visible to the TFS client and to do the reverse 
upon checkout.  What I'm looking for are some ideas for organizing in the TFS 
repository.  Also, we're looking for a one-button deployment solution to be 
able to deploy our Windows/.NET software to the respective Windows servers 
along with the UniVerse software to the UniVerse server(s), run processes to 
create/delete files, index, etc. and compile and catalog BASIC programs.  I 
know I'll probably have to build this thing to make this happen as I 
seriously doubt there is anything available off the shelf capable of doing 
this.  Anyone been down this path?

Thanks.
Perry Taylor
Zirmed, Inc.


CONFIDENTIALITY NOTICE: This e-mail message

Re: [U2] [UV] Microsoft Team Foundation Server for Source Control

2011-08-23 Thread Perry Taylor
Not source but code lists which are updated at different intervals.  Some 
examples: ZIP, CPT, ICD9, etc.


- Original Message -
From: Boydell, Stuart [mailto:stuart.boyd...@spotless.com.au]
Sent: Tuesday, August 23, 2011 07:49 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Microsoft Team Foundation Server for Source Control

What source are you keeping that has 2.5 million records

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Wednesday, 24 August 2011 01:39
To: U2 Users List
Subject: Re: [U2] [UV] Microsoft Team Foundation Server for Source Control

Thanks to everyone for some very interesting points.  I am particularly 
intrigued by Stuart's handling of dictionaries using triggers.  One particular 
challenge I may face is one particular hashed file (not a dictionary) which 
contains 2 1/2 million records that are under source control today.  Copying 
them out to a directory might pose some problems with inode consumption.

Perry


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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] Microsoft Team Foundation Server for Source Control

2011-08-19 Thread Perry Taylor
Has anyone had any experience using Microsoft's Team Foundation Server for 
source control with UniVerse on a Linux server?  I have the command line client 
functional and talking to the TFS server.  I know I'll have to write some kind 
of interlude to manage those items in hashed files to get them out into the 
file system where they will be visible to the TFS client and to do the reverse 
upon checkout.  What I'm looking for are some ideas for organizing in the TFS 
repository.  Also, we're looking for a one-button deployment solution to be 
able to deploy our Windows/.NET software to the respective Windows servers 
along with the UniVerse software to the UniVerse server(s), run processes to 
create/delete files, index, etc. and compile and catalog BASIC programs.  I 
know I'll probably have to build this thing to make this happen as I 
seriously doubt there is anything available off the shelf capable of doing 
this.  Anyone been down this path?

Thanks.
Perry Taylor
Zirmed, Inc.


CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Comparing numeric strings

2011-08-12 Thread Perry Taylor
Try concatenating a non-numeric character to each..

IF FOO: 'X' EQ BAR: 'X' THEN 


Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers
Sent: Friday, August 12, 2011 6:15 AM
To: U2 Users List
Subject: [U2] Comparing numeric strings

Say you have two strings that happen to be nuneric:

FOO = 401.0101
BAR = 401.0101000

Since UniBasic is untyped, even though I've wrapped each value in quotes ,
they are treated as numbers.  As a result, FOO EQ BAR evaluates to @TRUE.

In most dynamically typed languages, there's an intuitive way to coerce the
values at run-time (e.g, foo.to_s, foo.ToString, Str(foo)).  I can't seem to
figure out a good way to do this in UniBasic.  In the manual, there's a
function called SCMP that is supposed to be handy for comparing numeric
strings, but it doesn't appear to work in UniData 7.2.

# First try SCMP
IF SCMP(FOO, BAR) THEN
  CRT Not Equal
END ELSE
  CRT Equal
END

# Now try EQ
IF FOO EQ BAR THEN
  CRT Equal
END ELSE
  CRT Not Equal
END

Result:
Equal
Equal

Also, the tip in the manual seems to be untrue:

Numbers specified in quotation marks are string data type. Numbers
specified without quotation marks are numeric data type. The data type in a
variable is determined by the data first loaded into it.

Quotation marks appear to have absolutely no bearing on data type.

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] errlog API

2011-07-11 Thread Perry Taylor
Does anyone know if there is any exposed API to enable a BASIC program to make 
entries to the UniVerse errlog?

Thanks.

Perry Taylor
Zirmed, Inc.

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Coversion Code for Date

2011-06-03 Thread Perry Taylor
Another variation...

OCONV(THE.DATE, 'DYMD-[4,2,2]')


- Original Message -
From: Bill Brutzman [mailto:bi...@hkmetalcraft.com]
Sent: Friday, June 03, 2011 03:52 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: Re: [U2] Coversion Code for Date

Consider something like...

Today = date()

This.Date = oconv(Today, 'DD')
This.Month = oconv(Today, 'DM')
This.Year = oconv(Today, 'DY')

This.Long = This.Year : '-' : This.Month : '-' : This.Date

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube
Sent: Friday, June 03, 2011 3:47 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Coversion Code for Date

All

This may be a noob question, but here it goes!

Does anyone know what the conversion code is for a date field if I want to 
format the date as follows?

-MM-DD

Sincerely,

Nathan Dube
Network Administrator
Jerry Pate Turf  Irrigation




CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for 
use by the addressee(s) named herein and may contain information that is 
confidential, privileged, or proprietary. Distribution to anyone other than the 
addressee is prohibited. If you are not the intended recipient, you are not 
authorized to read, print, retain, copy or disseminate this message, any part 
of it, or any attachments. If you have received this message in error, please 
permanently delete this message and any attachments without reading the content 
and notify the sender immediately of the inadvertent transmission.
___
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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why should we NOT upgrade to UV11.1.1 ?

2011-05-18 Thread Perry Taylor
Hello Chuck.

You might want to watch out for some issues with permissions being set 
incorrectly within a couple of the packages in 10.3.9.  These cause an upgrade 
to fail.  This has been addressed with U2 Support.  This might not be a problem 
on a clean install rather than an upgrade.

Perry

- Original Message -
From: Charles Stevenson [mailto:stevenson.c...@gmail.com]
Sent: Wednesday, May 18, 2011 10:01 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: [U2] Why should we NOT upgrade to UV11.1.1 ?

UV11.1 has been available for AIX for 7 month; for Linux only 3..
I don't know how widely used it is yet.
I have not seen a rash of complaints about 11.1.

We are currently on 10.2.10 / Windows and contemplating migrating to Linux.
UV choices are:  10.3.9   11.1.1.

We do not have a burning need for any new 11.1 functionality.  The main 
motivation would be to be able to put off future upgrades longer by 
making this jump bigger.

Linux choices are RedHat or SuSE.  Your thoughts?

Any warnings or endorsements re. UV version /or Linux choices would be 
much appreciated.

Chuck Stevenson
Tolt Service Group

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Marking New Index as Built

2011-05-06 Thread Perry Taylor
In the end I took down the application that updates the indexed field
and did a BUILD.INDEX at 1am.  It took approximately one hour to build
but unfortunately another process that accesses that file shutdown in
error as the BUILD.INDEX had the FX lock on the file.  No harm done but
again without a truly online build this will continue to be a messy
operation for 7X24 shops.  Sure wish Rocket would take this seriously
and give us a better tool.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
Stevenson
Sent: Thursday, May 05, 2011 9:21 PM
To: U2 Users List
Subject: Re: [U2] [UV] Marking New Index as Built

So, Perry,  what did you finally decide to do?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] Purposefully Breaking a UniVerse File

2011-05-05 Thread Perry Taylor
I'm trying to determine the various error and warning messages that
might be presented by uvbackup.  I think I have determined most of them
but I don't know what uvbackup would say when it encounters a broken
file.  Is there an easy way to break a file in a way that would be
interpreted as such by uvbackup?

Thanks.
Perry Taylor
Senior MV Architect
ZirMed
888 West Market Street, Suite 400
Louisville, KY 40202
www.zirmed.com http://www.zirmed.com/  





CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Marking New Index as Built

2011-04-29 Thread Perry Taylor
Yup... works on type 30...

CREATE.FILE ITEST 1 1,1,30
Creating file ITEST as Type 30.
Creating file D_ITEST as Type 18, Modulo 1, Separation 1.
Added @ID, the default record for RetrieVe, to D_ITEST.
CREATE.INDEX ITEST @ID
LIST.INDEX ITEST ALL
Alternate Key Index Summary for file ITEST
File... ITEST
Indices 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0
S-type)
Index Updates.. Enabled, No updates pending

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
@ID  DNot Reqd  YesYes  SL N0

Perry
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Friday, April 29, 2011 9:39 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Marking New Index as Built

On 29/04/11 02:37, Perry Taylor wrote:
 This is on a fairly old release 10.1.21...

:-)

I'm not sure what the latest version I really played with on this score
was. Most of my experience was 9.6 and 10.0. The other thing is, I've
normally only ever used type 30 files ...

So does it work on 18s but not 30s, or has it been fixed, or or or ...?

Cheers,
Wol
 
 CREATE.FILE ITEST 1 1
 Creating file ITEST as Type 18, Modulo 1, Separation 1.
 Creating file D_ITEST as Type 18, Modulo 1, Separation 1.
 Added @ID, the default record for RetrieVe, to D_ITEST.
 CREATE.INDEX ITEST @ID
 LIST.INDEX ITEST ALL
 Alternate Key Index Summary for file ITEST
 File... ITEST
 Indices 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0
 S-type)
 Index Updates.. Enabled, No updates pending
 
 Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
 num/I-type
 @ID  DNot Reqd  YesYes  SL N0
 
 
 However if there are any records in the file...
 
 DELETE.INDEX ITEST @ID
 Removing index file @ID.
 COPY VOC RELLEVEL
 TO:(ITEST
  1 RELLEVEL copied to RELLEVEL in file ITEST.
 
 
 1 record copied.
 CREATE.INDEX ITEST @ID
 LIST.INDEX ITEST ALL
 Alternate Key Index Summary for file ITEST
 File... ITEST
 Indices 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0
 S-type)
 Index Updates.. Enabled, No updates pending
 
 Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
 num/I-type
 @ID  DRequired  YesYes  SL N0
 
 Perry
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
 Sent: Thursday, April 28, 2011 5:24 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] [UV] Marking New Index as Built
 
 On 29/04/11 00:08, Perry Taylor wrote:
 Actually I think UV does this.  If I create an index on an empty file
 the index does not have to be built.

 Are you sure? Or have they changed it recently?
 
 I went from Prime to UV, and that was one of the things I noticed very
 quickly. To the best of my knowledge it was never fixed. Anyways, I've
 always built an index on UV after creating it, even with an empty
file,
 and always because UV complained and demanded I do it.
 
 Perry
 
 Cheers,
 Wol
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 CONFIDENTIALITY NOTICE: This e-mail message, including any 
 attachments, is for the sole use of the intended recipient(s) 
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is 
 prohibited. ZirMed, Inc. has strict policies regarding the 
 content of e-mail communications, specifically Protected Health 
 Information, any communications containing such material will 
 be returned to the originating party with such advisement 
 noted. If you are not the intended recipient, please contact 
 the sender by reply e-mail and destroy all copies of the 
 original message.
 ___
 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] [UV] Marking New Index as Built

2011-04-28 Thread Perry Taylor
Hey Chuck.

The CONCURRENT option is actually there although it's not documented
(and I suspect not officially supported).  All it really does it not
lock the file which doesn't happen until the select is completed anyway.
One would have to make sure no updates were being made to the file until
the select finishes or the index build may not be complete and accurate
or may include entries for deleted records.  At this point not taking a
file lock on the data file seems less useful as the index file is going
to be cleared prior to population and the population doesn't really take
all that long in comparison to the select in most cases.  In any event
seems very messy to me.

Traditional relational databases have the option to build/rebuild
indexes while the table is in use.  In the end it seems to me that
Rocket needs to come up with a completely new strategy for
building/rebuilding an index.

Perry
 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
Stevenson
Sent: Thursday, April 28, 2011 10:53 AM
To: U2 Users List
Subject: Re: [U2] [UV] Marking New Index as Built

That should work.
And then you can write your own update program to back-populate the 
index w/o having to do a build at all.

But if your  my connivings are true, then why doesn't RocketSQ give 
that to us as a concurrent build option?   A few years ago they (as IBM)

declared that 7x24 uptime was a big goal for U2.

Warm regards,
Chuck

On 4/27/2011 2:24 PM, Perry Taylor wrote:
 I have a need in UniVerse to add a new index on a large file which has
 existing indexes.  I don't have a time window in the coming days in
 which to build the index but need to use the index for new records
which
 will be added to the file after the index has been created.   Is there
a
 way to force UniVerse to think that the index has been built so that
it
 can be used for newer records allowing me to defer the build to a
later
 date?

 Thanks.
 Perry Taylor
 Zirmed, Inc.




 CONFIDENTIALITY NOTICE: This e-mail message, including any
 attachments, is for the sole use of the intended recipient(s)
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is
 prohibited. ZirMed, Inc. has strict policies regarding the
 content of e-mail communications, specifically Protected Health
 Information, any communications containing such material will
 be returned to the originating party with such advisement
 noted. If you are not the intended recipient, please contact
 the sender by reply e-mail and destroy all copies of the
 original message.
 ___
 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] [UV] Marking New Index as Built

2011-04-28 Thread Perry Taylor
Actually I think UV does this.  If I create an index on an empty file the index 
does not have to be built.

Perry

- Original Message -
From: Wols Lists [mailto:antli...@youngman.org.uk]
Sent: Thursday, April 28, 2011 05:57 PM
To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Marking New Index as Built

On 28/04/11 17:53, Charles Stevenson wrote:
 That should work.
 And then you can write your own update program to back-populate the
 index w/o having to do a build at all.
 
 But if your  my connivings are true, then why doesn't RocketSQ give
 that to us as a concurrent build option?   A few years ago they (as IBM)
 declared that 7x24 uptime was a big goal for U2.
 
Another thing they should do, is what Prime did long ago.

INFORMATION actually checked whether there were any records in the file!
It's a right pain to have to rebuild all your new indices when you
create a file, add the indices, and then add the data, in that order.
INFORMATION just enabled the index and marked it up to date on
creation if there were no records in the file.

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Marking New Index as Built

2011-04-28 Thread Perry Taylor
This is on a fairly old release 10.1.21...

CREATE.FILE ITEST 1 1
Creating file ITEST as Type 18, Modulo 1, Separation 1.
Creating file D_ITEST as Type 18, Modulo 1, Separation 1.
Added @ID, the default record for RetrieVe, to D_ITEST.
CREATE.INDEX ITEST @ID
LIST.INDEX ITEST ALL
Alternate Key Index Summary for file ITEST
File... ITEST
Indices 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0
S-type)
Index Updates.. Enabled, No updates pending

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
@ID  DNot Reqd  YesYes  SL N0


However if there are any records in the file...

DELETE.INDEX ITEST @ID
Removing index file @ID.
COPY VOC RELLEVEL
TO:(ITEST
 1 RELLEVEL copied to RELLEVEL in file ITEST.


1 record copied.
CREATE.INDEX ITEST @ID
LIST.INDEX ITEST ALL
Alternate Key Index Summary for file ITEST
File... ITEST
Indices 1 (0 A-type, 0 C-type, 1 D-type, 0 I-type, 0 SQL, 0
S-type)
Index Updates.. Enabled, No updates pending

Index name  Type  BuildNulls  In DICT  S/M  Just Unique Field
num/I-type
@ID  DRequired  YesYes  SL N0

Perry
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Thursday, April 28, 2011 5:24 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Marking New Index as Built

On 29/04/11 00:08, Perry Taylor wrote:
 Actually I think UV does this.  If I create an index on an empty file
the index does not have to be built.
 
Are you sure? Or have they changed it recently?

I went from Prime to UV, and that was one of the things I noticed very
quickly. To the best of my knowledge it was never fixed. Anyways, I've
always built an index on UV after creating it, even with an empty file,
and always because UV complained and demanded I do it.

 Perry

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] Marking New Index as Built

2011-04-27 Thread Perry Taylor
I have a need in UniVerse to add a new index on a large file which has
existing indexes.  I don't have a time window in the coming days in
which to build the index but need to use the index for new records which
will be added to the file after the index has been created.   Is there a
way to force UniVerse to think that the index has been built so that it
can be used for newer records allowing me to defer the build to a later
date?

Thanks.
Perry Taylor
Zirmed, Inc.




CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] Marking New Index as Built

2011-04-27 Thread Perry Taylor
I think I have found an unsupported way to doing this.  It appears
there is a flag in the INDEX.MAP file that controls this and flipping it
does the trick.  I'm hoping there is an official way to do this so I
don't have any surprises when I muck with the internals.  Any ideas?

Thanks.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Wednesday, April 27, 2011 1:24 PM
To: U2-Users List
Subject: [U2] [UV] Marking New Index as Built

I have a need in UniVerse to add a new index on a large file which has
existing indexes.  I don't have a time window in the coming days in
which to build the index but need to use the index for new records which
will be added to the file after the index has been created.   Is there a
way to force UniVerse to think that the index has been built so that it
can be used for newer records allowing me to defer the build to a later
date?

Thanks.
Perry Taylor
Zirmed, Inc.




CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
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] [UV] XML Parser

2011-02-24 Thread Perry Taylor
Thanks to everyone who offered their suggestions.  The xpath
command-line executable which ships with the perl XML::XPath package
looks promising for my needs.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Wednesday, February 23, 2011 6:50 AM
To: U2 Users List
Subject: [U2] [UV] XML Parser

Can someone recommend an XML parser to run on RHEL?  I'm tired of
fighting trying to get the XML support in BASIC  to work.  Any
suggestions?

Thanks.

Perry Taylor
Zirmed, Inc.


CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
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] [UV] XML Parser

2011-02-23 Thread Perry Taylor
Can someone recommend an XML parser to run on RHEL?  I'm tired of
fighting trying to get the XML support in BASIC  to work.  Any
suggestions?

Thanks.

Perry Taylor
Zirmed, Inc.


CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] UniVerse Uptime

2011-02-17 Thread Perry Taylor
Does anyone have a good method for determining how long UniVerse has
been running?

Thanks.

Perry Taylor
Zirmed, Inc.


CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] cpio: premature end of file

2010-12-09 Thread Perry Taylor
Any chance your cpio file has exceeded the 2GB limit?

Perry

- Original Message -
From: doug chanco [mailto:d...@chancofamily.com]
Sent: Thursday, December 09, 2010 09:39 PM
To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
Subject: [U2] cpio: premature end of file

I am 95% sure this is being caused by the cpio options being different 
between unix/linux (in this case suse enterprise server) in the STARTUP 
script.

What I cannot remember is which flag it is, can anyone refresh me?  I am 
trying to install the personal edition of universe 10.3.3. on suse linux 
11 enterprise server.

thanks

dougc


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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [EMPLOYMENT] UniVerse Technical Lead

2010-12-03 Thread Perry Taylor
Zirmed, Inc., a leader in the Healthcare Revenue Cycle Management space,
has an opening for a UniVerse Technical Lead at our corporate
headquarters in Louisville, Kentucky.  Interested individuals are
encouraged to apply online at http://www.zirmed.com by clicking on the
Company tab, then Join our Team! View opportunities.

Here are the details...

POSITION:  MV TECHNICAL LEAD

REPORTS TO: IT DEVELOPMENT MANAGER

PURPOSE OF THE POSITION: 

This person will be responsible for working with the Technology and
Business teams to design, build, test, implement, and maintain various
process applications. This person will be required to mentor lower level
team members to assist and train on Universe, as well as how project
requests that are received impact our overall system. The MV Technical
Lead also assists in troubleshooting and resolving technical issues.

POSITION FUNCTIONS: 

* Responsible for setting an example of how each Engineer should conduct
themselves
* Proposes new technical frameworks to Architecture Committee
* Responsible for ensuring development team follows ZirMed Engineering
Standards by conducting code reviews
* Responsible for developing, documenting and/or approving Technical
Specifications for the other Engineers on the team
* Responsible for developing/augmenting applications based on functional
and technical specifications Assists in identifying areas in the
application  that need to be refactored
* Responsible for leading the team when troubleshooting and resolving
critical technical issues
* Participate in the Project Portfolio process by providing guidance and
high level estimates on proposed projects
* Participates in the project planning process by attending Business
planning meeting and assisting the Systems Analyst to ensure all
requirements have been collected
* Actively participate in weekly Technical Lead meetings
* Responsible for communicating progress to appropriate personal
* Provide feedback for Engineer performance reviews
* Mentor other team members to provide expertise, project assessment,
assist in tech specs, and code reviews of other team members.
* Perform other duties and/or projects as assigned by management within
the area of responsibility and control.

RELATIONSHIP AND SCOPE:

Key Interfaces: Software Vendors (IBM, Rocket, etc,); ZirMed Product
Development; ZirMed Product Support Teams; Other ZirMed software
engineering Teams with MV team members.

KNOWLEDGE AND SKILLS REQUIRED:

EDUCATION: 
* Bachelors Degree Desired

EXPERIENCE (AND OTHER QUALIFICATIONS): 

* 5 years multi-value database programming experience with preference
for UniVerse given
* 3 years multi-value database query experience, including but not
limited to the use of RetrieVe, dictionaries of varying types, indexes,
etc
* Excellent written and verbal communication skills.
* Highly self-motivated.
* Ability to work both in team and solo environments
* Ability to mentor and train other developers
* Demonstrates leadership
* Hands on experience working with Universe database
* Unit Testing


Perry Taylor
www.zirmed.com


CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Is there a file limit size to OPENSEQ?

2010-09-03 Thread Perry Taylor
I think this might be a limit of the OS.  I'm on 10.2.7 on RHEL5 and I
can OPENSEQ a file that is 3,648,692,224 bytes in size.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, September 03, 2010 11:19 AM
To: U2 Users List
Subject: Re: [U2] Is there a file limit size to OPENSEQ?

Guess I'll have to split into 2g pieces...since I'm on 10.0 

Seems odd, since sequentially, your not reading the entire file...
   not worth upgrading over that one issue however.

Thanks

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso
 Sent: Friday, September 03, 2010 1:14 PM
 To: U2 Users List
 Subject: Re: [U2] Is there a file limit size to OPENSEQ?
 
 Hi.
 
 I guess that it is a UV-version matter.
 
 If you have a Linux box with Universe version prior to 10.2.x then you
 can't
 open any file over 2 Gb (sequential or not sequential).
 
 Regards
 --
 Augusto Alonso
 IT Manager
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Is there a file limit size to OPENSEQ?

2010-09-03 Thread Perry Taylor
I was curious and tried this on a 10.1.21 RHEL5 system Works there
too.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, September 03, 2010 11:26 AM
To: U2 Users List
Subject: Re: [U2] Is there a file limit size to OPENSEQ?

Your at UV 10.2, I'm on UV 10.0 - seems those pesky little tenths make a
world of a difference

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
 Sent: Friday, September 03, 2010 1:24 PM
 To: U2 Users List
 Subject: Re: [U2] Is there a file limit size to OPENSEQ?
 
 I think this might be a limit of the OS.  I'm on 10.2.7 on RHEL5 and I
 can OPENSEQ a file that is 3,648,692,224 bytes in size.
 
 Perry
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George
 Gallen
 Sent: Friday, September 03, 2010 11:19 AM
 To: U2 Users List
 Subject: Re: [U2] Is there a file limit size to OPENSEQ?
 
 Guess I'll have to split into 2g pieces...since I'm on 10.0
 
 Seems odd, since sequentially, your not reading the entire file...
not worth upgrading over that one issue however.
 
 Thanks
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso
  Sent: Friday, September 03, 2010 1:14 PM
  To: U2 Users List
  Subject: Re: [U2] Is there a file limit size to OPENSEQ?
 
  Hi.
 
  I guess that it is a UV-version matter.
 
  If you have a Linux box with Universe version prior to 10.2.x then
 you
  can't
  open any file over 2 Gb (sequential or not sequential).
 
  Regards
  --
  Augusto Alonso
  IT Manager
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 CONFIDENTIALITY NOTICE: This e-mail message, including any
 attachments, is for the sole use of the intended recipient(s)
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is
 prohibited. ZirMed, Inc. has strict policies regarding the
 content of e-mail communications, specifically Protected Health
 Information, any communications containing such material will
 be returned to the originating party with such advisement
 noted. If you are not the intended recipient, please contact
 the sender by reply e-mail and destroy all copies of the
 original message.
 ___
 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] Is there a file limit size to OPENSEQ?

2010-09-03 Thread Perry Taylor
Yes, that works fine... do it all the time.

We are on Intel hardware.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso
Sent: Friday, September 03, 2010 11:45 AM
To: U2 Users List
Subject: Re: [U2] Is there a file limit size to OPENSEQ?

Perry,
can you resize a file with the 64BIT option on your 10.1.21?
RESIZE FILENAME * * * 64BIT

It's your RHEL5 Intel or PowerPC?
Regards
--
Augusto Alonso
IT Manager
QUITER SERVICIOS CENTRALES
Zoco Gran Santander, 1ª planta - 39011 Santander - España
Telf: +34 902233323 - Fax: +34 902234280

AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al
usuario de destino, pudiendo contener información confidencial o protegida
legalmente. Si, por un error de envío o transmisión, ha recibido este
mensaje y usted no es el destinatario del mismo, por favor, notifique de
este hecho al remitente y no use, informe, distribuya, imprima, copie o
difunda este mensaje bajo ningún medio . Cualquier opinión en él contenida,
es exclusiva de su autor y no representa necesariamente la opinión de Quiter
Servicios Centrales.

LEGAL WARNING: This e-mail and any attachment, contain information intended
solely for the addressee and may contain confidential information or legally
protected data. If you are not the intended recipient, please notify the
sender and do not use, disclose, distribute, copy, print or rely on this
e-mail under any circumstances. The views and opinions expressed are the
author´s own and do not necessarily reflect those of Quiter Servicios
Centrales.



2010/9/3 Perry Taylor perry.tay...@zirmed.com

 I was curious and tried this on a 10.1.21 RHEL5 system Works there
 too.

 Perry

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
 Sent: Friday, September 03, 2010 11:26 AM
 To: U2 Users List
 Subject: Re: [U2] Is there a file limit size to OPENSEQ?

 Your at UV 10.2, I'm on UV 10.0 - seems those pesky little tenths make a
 world of a difference

  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
  Sent: Friday, September 03, 2010 1:24 PM
  To: U2 Users List
  Subject: Re: [U2] Is there a file limit size to OPENSEQ?
 
  I think this might be a limit of the OS.  I'm on 10.2.7 on RHEL5 and I
  can OPENSEQ a file that is 3,648,692,224 bytes in size.
 
  Perry
 
  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org
  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George
  Gallen
  Sent: Friday, September 03, 2010 11:19 AM
  To: U2 Users List
  Subject: Re: [U2] Is there a file limit size to OPENSEQ?
 
  Guess I'll have to split into 2g pieces...since I'm on 10.0
 
  Seems odd, since sequentially, your not reading the entire file...
 not worth upgrading over that one issue however.
 
  Thanks
 
   -Original Message-
   From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
   boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso
   Sent: Friday, September 03, 2010 1:14 PM
   To: U2 Users List
   Subject: Re: [U2] Is there a file limit size to OPENSEQ?
  
   Hi.
  
   I guess that it is a UV-version matter.
  
   If you have a Linux box with Universe version prior to 10.2.x then
  you
   can't
   open any file over 2 Gb (sequential or not sequential).
  
   Regards
   --
   Augusto Alonso
   IT Manager
  ___
  U2-Users mailing list
  U2-Users@listserver.u2ug.org
  http://listserver.u2ug.org/mailman/listinfo/u2-users
 
  CONFIDENTIALITY NOTICE: This e-mail message, including any
  attachments, is for the sole use of the intended recipient(s)
  and may contain confidential and privileged information.  Any
  unauthorized review, use, disclosure or distribution is
  prohibited. ZirMed, Inc. has strict policies regarding the
  content of e-mail communications, specifically Protected Health
  Information, any communications containing such material will
  be returned to the originating party with such advisement
  noted. If you are not the intended recipient, please contact
  the sender by reply e-mail and destroy all copies of the
  original message.
  ___
  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] [UV] Shared Record Locks

2010-08-31 Thread Perry Taylor
Has anyone a real-world application where UniVerse shared record locks
are used?  I'm struggling with when they would be preferable to using an
update record lock.  Anyone willing to share their experiences?

Thanks.

Perry Taylor
ZirMed
626 West Main St , 6th Floor
Louisville, KY 40202
www.zirmed.com http://www.zirmed.com/ 




CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Copying Universe files with an Index.

2010-07-01 Thread Perry Taylor
Have a look at the SET.INDEX command.  The path to the index files is store in 
the file header and you'll need to use SET.INDEX to change it to reflect the 
new location of the index files.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson
Sent: Thursday, July 01, 2010 7:26 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Copying Universe files with an Index.

Hello all,

I'm using Universe on AIX and I have a need to copy an Universe file from one 
account to another for historical usage. Using the AIX cp command takes 
a couple of minutes but the Index is not useable. Using Universe COPY or Basic 
read and write takes much longer.

I believe the problem is due to Universe storing the full path to the Index 
files in the header of the data file.

Is there anyway to fix the header without corrupting the file?

What's the best way to handle this?
 
Thanks,
Don Robinson
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum

2010-06-09 Thread Perry Taylor
Make sure there is not an index on that file being updated with a key 
255 characters.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Wednesday, June 09, 2010 8:19 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] problem - Attempted WRITE with record ID larger than
file/table maximum


We encountered a problem during our nightly batch processing last night
and it pertains to a specific
record/key. The error that we received in our log is as follows:

--
Program LFBDOPOS: Line 337, Attempted WRITE with record ID larger than
file/table maximum
record ID size of 255 characters.
Program LFBDOPOS: Line 337, FATAL: Unable to do commit of record
15500*60431*EJK in file GENACCTRN_POSTED/DATA.30.
Program LFBDOPOS: Line 337, Rolling back uncommitted transactions
begun within this execution environment.
Attempted WRITE with record ID larger than file/table maximum
record ID size of 255 characters.
--

I checked our MAXKEYSIZE in UniAdmin and it's set to 255. 

I guess my question is why is it saying the ID/primary key is too large
if it should be - 15500*60431*EJK ?

Also, what do we do to fix this? Any help is appreciated, thanks!


Chris

  
_
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars
with Hotmail. 
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=P
ID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] OPENSEQ and Abnormal termination of UV

2010-05-17 Thread Perry Taylor
Just for giggles... what happens if you...

OPENSEQ '/tmp/file.txt' TO FV.TEMP ELSE ...
FILEVARS(1) = FV.TEMP 

??

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rajesh Menon
Sent: Monday, May 17, 2010 2:56 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] OPENSEQ and Abnormal termination of UV

Does anyone knows what is happening here:
I am trying to open a text file (over 4Gb) using OPENSEQ and storing the
file variable into a array as follows:
COMMON /MYPROG/ FILEVARS(10)
OPENSEQ /tmp/file.txt to FILEVARS(1) ELSE ...
This operation results abnormal termination with fault type error 11.
Fault occurred at address 1c (which is the OPENSEQ command.). If the
file size is less than 2147483647 bytes (2Gb), it works.

Opening the same file using a scalar file variable always work
irrespective of the file size.
OPENSEQ /tmp/file.txt TO FV.FILE ELSE ...

Any reason why the first method failing for +2Gb files? Any workarounds?

Universe: 10.2.7
AIX:  5.3

Thanks
Rajesh Menon

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] OPENSEQ and Abnormal termination of UV

2010-05-17 Thread Perry Taylor
I'd call this one a bug.  I just tried the following on 10.2.7 on
RHEL5...

  OPENSEQ '/data/trax/CLM.IDX/OVER.30' TO SEQ.TEST ELSE ABORT

  STATUS FS FROM SEQ.TEST ELSE ABORT

  CLOSESEQ SEQ.TEST

  CRT 'FILE SIZE = ': FS6

I get...

FILE SIZE = 10146506752

But if I run...

  DIM FVARS(10)

  OPENSEQ '/data/trax/CLM.IDX/OVER.30' TO FVARS(1) ELSE ABORT

  STATUS FS FROM FVARS(1) ELSE ABORT

  CLOSESEQ FVARS(1)

  CRT 'FILE SIZE = ': FS6

I get...

Abnormal termination of UniVerse.
Fault type is 11.  Layer type is BASIC run machine.
Fault occurred in BASIC program PTEST at address 5a.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc A
Hilbert
Sent: Monday, May 17, 2010 3:41 PM
To: 'U2 Users List'
Subject: Re: [U2] OPENSEQ and Abnormal termination of UV

What happens wif you open to regular variable then pass it over to the
array:
OPENSEQ  TO FVAR
FILEVARS(1) = FVAR
?
Regards,
Marc


-Mensaje original-
De: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] En nombre de Rajesh Menon
Enviado el: lunes, 17 de mayo de 2010 16:12
Para: U2 Users List
Asunto: Re: [U2] OPENSEQ and Abnormal termination of UV

Yes file system is setup to support +2Gb files. As I mentioned I can
open
the file using a scalar file variable. Problem happening only with the
combination of +2Gb and using array variable.

Thanks,
Rajesh

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble
Sent: Monday, May 17, 2010 12:00 PM
To: 'u2-users@listserver.u2ug.org'
Subject: Re: [U2] OPENSEQ and Abnormal termination of UV

You may want to check with your Systems Administrator to be sure your
file
system is setup to support files larger than 2gig

- Original Message -
From: u2-users-boun...@listserver.u2ug.org
u2-users-boun...@listserver.u2ug.org
To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
Sent: Mon May 17 14:55:30 2010
Subject: [U2] OPENSEQ and Abnormal termination of UV

Does anyone knows what is happening here:
I am trying to open a text file (over 4Gb) using OPENSEQ and storing the
file variable into a array as follows:
COMMON /MYPROG/ FILEVARS(10)
OPENSEQ /tmp/file.txt to FILEVARS(1) ELSE ...
This operation results abnormal termination with fault type error 11.
Fault
occurred at address 1c (which is the OPENSEQ command.). If the file size
is
less than 2147483647 bytes (2Gb), it works.

Opening the same file using a scalar file variable always work
irrespective
of the file size.
OPENSEQ /tmp/file.txt TO FV.FILE ELSE ...

Any reason why the first method failing for +2Gb files? Any workarounds?

Universe: 10.2.7
AIX:  5.3

Thanks
Rajesh Menon

___
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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] SQL Equiv to Save-list?

2010-04-08 Thread Perry Taylor
You might try...

select custname, custaddr, custcity from customerfile where
custid in (select EVAL @RECORD from SAVEDLISTS
'the_saved_list_name');

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, April 08, 2010 8:09 AM
To: U2 Users List
Subject: [U2] SQL Equiv to Save-list?

Is there a way in SQL without resorting to subqueries to select a table,
then save the resulting field,
Then use that list for a future SQL query?

ex. select customerid from invoicefile;
   save the list of customerid for later use

later

  get that list of customerid
  select cust.name , cust.addr , cust.city, etc  from customerfile
where cust.id=(list of customerid) and cust.st='ny'


Or is this one of those pick ain't it great we can do this features?


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] SQL Equiv to Save-list?

2010-04-08 Thread Perry Taylor
Yeah, my way would be overkill where the saved list has keys to the file
against which we want to query.  It does come in very handy when you
have a list of keys from a related file that you want to select a
particular field against...

Let's say you have an ORDERS file that has a sequential key and you want
to select all the ORDERS records which belong to number of customers
from a list of those customer numbers...

Maybe...

SELECT TO SLIST 0 FROM CUSTOMERS WHERE STATE = 'AZ';
SAVE.LIST CUSTOMER.LIST

SELECT * FROM ORDERS WHERE CUSTOMER.ID IN (SELECT EVAL @RECORD FROM
SAVEDLISTS 'CUSTOMER.LIST');

To do this Retrieve you would have to either...

LIST ORDERS WITH CUSTOMER.ID '111' '121' '1231'... etc having to key
them explicitly

-0r-

LIST ORDERS WITH CUSTOMER.STATE = AZ

Where CUSTOMER.STATE is a translate to the CUSTOMERS file.

The downside of the second Retrieve solution is the lookup of
CUSTOMER.STATE for every ORDERS record resulting in a lot of random I/O,
possibly many times for the same customers.

The SQL method allows as sinqle sequential pass thru the CUSTOMERS file
to find all those who are located in AZ, then a single pass thru the
ORDERS file without the translate.

Perry


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton
Oliver
Sent: Thursday, April 08, 2010 3:25 PM
To: U2 Users List
Subject: Re: [U2] SQL Equiv to Save-list?

How about

SELECT CUSTNAME, CUSTADDR, CUSTCITY FROM CUSTOMERFILE SLIST
'saved_list-name';

Regards,

Clif

-- 
W. Clifton Oliver, CCP
CLIFTON OLIVER  ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com


On Apr 8, 2010, at 1:28 PM, Perry Taylor wrote:

 You might try...
 
   select custname, custaddr, custcity from customerfile where
 custid in (select EVAL @RECORD from SAVEDLISTS
 'the_saved_list_name');
 
 Perry
 
 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George
Gallen
 Sent: Thursday, April 08, 2010 8:09 AM
 To: U2 Users List
 Subject: [U2] SQL Equiv to Save-list?
 
 Is there a way in SQL without resorting to subqueries to select a
table,
 then save the resulting field,
 Then use that list for a future SQL query?
 
 ex. select customerid from invoicefile;
   save the list of customerid for later use
 
 later
 
  get that list of customerid
  select cust.name , cust.addr , cust.city, etc  from customerfile
 where cust.id=(list of customerid) and cust.st='ny'
 
 
 Or is this one of those pick ain't it great we can do this features?
 
 
 George Gallen
 Senior Programmer/Analyst
 Accounting/Data Division, EDI Administrator
 ggal...@wyanokegroup.com
 ph:856.848.9005 Ext 220
 The Wyanoke Group
 http://www.wyanokegroup.com
 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 CONFIDENTIALITY NOTICE: This e-mail message, including any 
 attachments, is for the sole use of the intended recipient(s) 
 and may contain confidential and privileged information.  Any
 unauthorized review, use, disclosure or distribution is 
 prohibited. ZirMed, Inc. has strict policies regarding the 
 content of e-mail communications, specifically Protected Health 
 Information, any communications containing such material will 
 be returned to the originating party with such advisement 
 noted. If you are not the intended recipient, please contact 
 the sender by reply e-mail and destroy all copies of the 
 original message.
 ___
 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] [UV] On Linux

2010-03-05 Thread Perry Taylor
We're running 10.1.21 on RHEL5; runs great.

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Friday, March 05, 2010 10:01 AM
To: U2 Users List
Subject: [U2] [UV] On Linux

Hello,

I've it mentioned a few times that Universe is available on Linux.   On
what flavor of Linux is it available ?   Has anyone here been using it
and are there any issues versus how it works on UNIX ?

Jacques



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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] - setHTTPDefault(AUTHENTICATE, value)

2010-02-24 Thread Perry Taylor
I am unable to get the authentication credentials to be recognized by a
web server.  I am issuing the following...

createRequest(URL, 'GET', HDL)

setHTTPDefault('AUTHENTICATE', 'my_userid:my_password')

submitRequest(HDL, NUL, NUL, RESP.HDRS, RESP.DATA, HTTP.STATUS)

... and I always get back a 401 (Unauthorized) http status.

I can use curl, supplying the same credentials and I get a good return.

Any ideas?

Thanks.

Perry Taylor
ZirMed
626 West Main St , 6th Floor
Louisville, KY 40202
www.zirmed.com




CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] [UV] - setHTTPDefault(AUTHENTICATE, value)

2010-02-24 Thread Perry Taylor
Wow! Excellent idea!  Thanks for that.. I'l give it a try.

Perry

- Original Message -
From: u2-users-boun...@listserver.u2ug.org 
u2-users-boun...@listserver.u2ug.org
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Wed Feb 24 15:26:52 2010
Subject: Re: [U2] [UV] - setHTTPDefault(AUTHENTICATE, value)

If you run curl with the -v flag to set it verbose you can see what headers
are being sent and make sure you create the correct one in your code.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: 22 February 2010 20:40
To: U2 Users List
Subject: [U2] [UV] - setHTTPDefault(AUTHENTICATE, value)

I am unable to get the authentication credentials to be recognized by a
web server.  I am issuing the following...

createRequest(URL, 'GET', HDL)

setHTTPDefault('AUTHENTICATE', 'my_userid:my_password')

submitRequest(HDL, NUL, NUL, RESP.HDRS, RESP.DATA, HTTP.STATUS)

... and I always get back a 401 (Unauthorized) http status.

I can use curl, supplying the same credentials and I get a good return.

Any ideas?

Thanks.

Perry Taylor
ZirMed
626 West Main St , 6th Floor
Louisville, KY 40202
www.zirmed.com




CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
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] Dynamic Connect (Wintegrate) 6.1.0 and Vista; Error Pasting Text

2010-01-31 Thread Perry Taylor
I, too, have had this happen since going to Windows 7.

Perry

- Original Message -
From: u2-users-boun...@listserver.u2ug.org 
u2-users-boun...@listserver.u2ug.org
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed Jan 27 00:09:02 2010
Subject: [U2]  Dynamic Connect (Wintegrate) 6.1.0 and Vista;Error Pasting Text

I just found this post in Nabble and I have exactly the same issue with
6.1.0 on Windows Server 2008 (Vista server). Did anyone find a fix?
Stuart

---
Noah Hart - Fri, 13 Feb 2009 16:14:39 -0800
We recently upgraded some workstations to Vista, and notice that when we
paste 
text (control-V) into the terminal window, a ? will randomly appear.
This 
happens about 10% of the time

Has anyone else seen this?

Regards,
- 
Noah Hart 


Stuart Boydell 
BI/Reporting Technical Lead 
Information Services 
Spotless 
T +61 3 9269 7398 
M +61 4 1115 0246 
E stuart.boyd...@spotless.com.au 
W www.spotless.com 



**
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this communication in error, please reply to this e-mail to notify the sender 
of its incorrect delivery and then delete it and your reply.  It is your 
responsibility to check this email and any attachments for viruses and defects 
before opening or sending them on. Spotless collects information about you to 
provide and market our services. For information about use, disclosure and 
access, see our privacy policy at http://www.spotless.com.au
Please consider our environment before printing this email.
**
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] How can I tell a Type 1 from a Type 19

2010-01-21 Thread Perry Taylor
George,

Try using the STATUS statement...

STATUS FS FROM F.FILE ELSE ABORT

FILE.TYPE = FS21

Perry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, January 21, 2010 12:48 PM
To: U2 Users List
Subject: [U2] How can I tell a Type 1 from a Type 19

without shelling to unix to see if a .type1 exists in the file
directory,
is there a way to tell a type 1 from a type 19 from within Universe?

I tried using FILEINFO(file, 3)
   but both type 1 and type 19 return a value 4 (type 1)

George


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Still using wIntegrate to copy files?

2010-01-13 Thread Perry Taylor
We use it extensively. I hoping for no surprises.

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke
Sent: Wednesday, January 13, 2010 11:42 AM
To: 'U2 Users List'
Subject: Re: [U2] Still using wIntegrate to copy files?

Are many people even still using wIntegrate? I saw this on Rocket's
site:

Effective December 31, 2010 the following product versions will move
into
End of Life (EOL) status:
.wIntegrate 6.1 and earlier

Isn't 6.1 the current version? Is there another one coming? It appears
Rocket's deal with IBM included ending support on a lot of the older
versions. Is Rocket planning on using one of its products Bluezone??? To
replace wIntegrate? Or maybe an Eclipse based product like they've been
doing with Admin and UniDebugger??? Don't tell me it's going to be
Dynamic
Connect

Just curious
Colin Alfke
Calgary, Canada

-Original Message-
From: Doug

[ad]
We at U2logic are continually improving our Eclipse based XLr8Editor.
We
just added the 
multiple clip board option about a month ago.  Today you can copy huge
data
sets
from Universe to Universe or Unidata to Unidata or even Universe to
Unidata.
 
We can believe it ourselves.  We just copied 41mb file from a client
using
Unidata to our Universe 
system in under 3 minutes over the Internet.  That file has over 100,000
records and it would be
a many hour process with wIntegrate.
 
For $49.00 a year you can have this functionality.  Go to
www.u2logic.com/tools.html
and purchase a license.  Following the Quick start instructions in
www.u2logic.com/download.html
and you will be ready to copy and paste huge data sets and have finest
editor for Universe or
Unidata databases.
[/ad]
 
Regards,
Doug
___
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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Universe Writeseq Append

2009-11-13 Thread Perry Taylor
Look at the SEEK statement.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Alspach,
Vance
Sent: Friday, November 13, 2009 2:39 PM
To: U2 Users List
Subject: [U2] Universe Writeseq Append

Universe 10.0.14
AIX 5.3


I know that in Unidata, you can use a WRITESEQ ... APPEND to append a
sequential file.  Is there an undocumented way to do this in Universe
(other than a READSEQ loop to position the pointer to the EOF)?

Thanks in advance.


Vance Alspach
John Deere Landscapes



CONFIDENTIALITY. This electronic mail and any files transmitted with it
may contain information proprietary to Deere  Company, or one of its
subsidiaries or affiliates, and are intended solely for the use of the
individual or entity to whom they are addressed, shall be maintained in
confidence and not disclosed to third parties without the written
consent of the sender. If you are not the intended recipient or the
person responsible for delivering the electronic mail to the intended
recipient, be advised that you have received this electronic mail in
error and that any use, dissemination, forwarding, printing, or copying
of this electronic mail is strictly prohibited. If you have received
this electronic mail in error, please immediately notify the sender by
return mail.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] UV/NET - DataStage

2009-10-28 Thread Perry Taylor
We're trying to do an evaluation of DataStage running on Windows
accessing our UniVerse server running on Linux.  I have activated a
license for UV/NET on the UniVerse server.  We have been unable to
import the UniVerse files in DS where we get the following error...

DSR.MetaGeta(GET.FILES): OPEN of DSR.MetaGeta.m2388 took ELSE clause,
STATUS()=-1

I'm suspecting a UV/NET issue.  I tried setting up a remote file in the
DSEngine account and I get the following..

CT VOC JJ

 JJ
0001 F
0002 QAUV2!/home/trax/VOC

SELECT JJ
dsrpc: The TCP/IP connection was refused.
dsrpc: The dsrpcd is probably not running.
Unable to open JJ file.

I checked and the dsrpcd service is running on the DS server.

Any ideas?

Thanks.

Perry Taylor
Zirmed, Inc.



CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any 
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [UV] @Variables in Paragraph

2009-09-16 Thread Perry Taylor
This is probaby one of those duh questions but...

Is there a way in a paragraph to display the value of the supported @ variables?

I.E. 

PA
SELECT FILENAME WITH ...
DISPLAY @SYSTEM.RETURN.CODE

Thanks

Perry Taylor

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any 
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] U2 being sold!

2009-09-15 Thread Perry Taylor
Oh man!  Management is already grumbing.  Here we go again :( 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne
Ackerman
Sent: Tuesday, September 15, 2009 2:19 PM
To: U2 List Server
Subject: [U2] U2 being sold!

September 15, 2009: IBM has signed an agreement to sell the U2 assets to

Rocket Software, a global software development company. Founded in 1990,

Rocket is a provider of OEM software to IBM, HP and other Fortune 500 
companies. Rocket's RD focus has the potential to accelerate the growth

of U2's business.

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any 
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] [EMPLOYMENT] UniVerse Developer-Advanced

2009-08-10 Thread Perry Taylor
Zirmed, Inc., a leader in the Healthcare Revenue Cycle Management space,
has an opening for a UniVerse Developer at our corporate headquarters in
Louisville, Kentucky.  Interested individuals are encouraged to apply
online at http://www.zirmed.com by selecting the Company tab then
following the link on the Careers portion of the page.

Here are the details...

Job Title: UniVerse Software Developer - Advanced
Department: Information Technology
Reports To: IT Development Manager

Position Overview
 
This person will be responsible for working with the Technology and
Business teams to design, build, implement, and maintain various process
applications.  This person will be required to mentor lower level team
members to assist and train on Universe, as well as how project requests
that are received impact our overall system.  

General Responsibilities
*   Design/Develop/Test/Implement improvements or new features to
the ZirMed UniVerse applications.
*   Work with the various departments and team members to design
and/or implement new enhancements to existing applications.  This
includes, but is not limited to, table design and process design written
in UniVerse BASIC.
*   Test all changes in development and work with the
appropriate business and/or technology owner(s) to ensure development
meets business requirements. 
*   Track any changes required by such development using
internal tools and communicate to the QA Technical Coordinator any
special requirements to push the changes from development through the
various stages to production.
*   Communicate development progress daily using an internal
project tracking tool.
*   Assist in the QA process.
*   Participate as required in production code deployments.

*   Troubleshoot and confirm reported application problems,
formulate and implement corrections.

*   Develop and maintain an open and fluid communication
relationship with management.
*   Identify and inform the technology manager of areas of the
application that require new or improved technology solutions.
1   Notify the technology manager of any
problems that negatively impact applications and work to implement a
solution.
*   Mentor other team members from a senior level to provide
expertise, project assessment, assist in tech specs, and code reviews of
other team members. 

Required Skills
*   8 years multi-value database programming experience with
preference for UniVerse given.
*   5 years multi-value database query experience, including but not
limited to the use of RetrieVe, dictionaries of varying types, indexes,
etc.
*   Excellent written and verbal communication skills.
*   Highly self-motivated.
*   Ability to work both in team and solo environments.
*   Ability to mentor and train other developers.


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


Re: [U2] Mass Disabling Triggers

2009-08-06 Thread Perry Taylor
Look at FILEINFO()

- Original Message -
From: u2-users-boun...@listserver.u2ug.org 
u2-users-boun...@listserver.u2ug.org
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Thu Aug 06 11:39:23 2009
Subject: [U2] Mass Disabling Triggers

There are 5 arguments passed with a trigger:
STATUS.FLAG
DICT.FLAG
File Pointer
Key
Record

The File Pointer is a handle to the OPENED file, not the NAME of the file.  How 
would I determine the name of the file that has the trigger assigned to it?

Purpose:
We have MANY triggers.  Due to upgrade/conversion issues, we had to delete all 
the triggers, and will need to re-add them at a later date.  This is a pain!  
We are considering having a single trigger for all these files that would be 
smart enough to dynamically call the real trigger logic (a 2nd subroutine 
that is locally cataloged).  This would allow us to disable the single 
subroutine by simply adding a RETURN at the top of the code.  Once we are ready 
to turn them back on, we would just remove the RETURN.

Other thoughts?


John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Dayton, OH  45342
937-866-0711 x44380

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

CONFIDENTIALITY NOTICE: This e-mail message, including any 
attachments, is for the sole use of the intended recipient(s) 
and may contain confidential and privileged information.  Any 
unauthorized review, use, disclosure or distribution is 
prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health 
Information, any communications containing such material will 
be returned to the originating party with such advisement 
noted. If you are not the intended recipient, please contact 
the sender by reply e-mail and destroy all copies of the 
original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] UniVerse Unit Testing

2009-06-11 Thread Perry Taylor
Brian,
 
You say that you designed all our server code as subroutines such that
all of our subroutines had one of two calling interfaces.  This would
seem to mean that you built and maintained two different versions of
every external subroutine/function.  Is this correct or am I just
missing something?
 
Thanks.
 
Perry



From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Thursday, June 11, 2009 3:19 AM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Unit Testing


Hi
 
 
At my last company, we spent a lot of effort on building an automated
test rig for our software, because we had to support multiple platforms
and all our code required full regression testing. It may be a slightly
different scenario to yours, since we were primarily building tools, and
also this was complicated by the fact that all of our software was
client/server in some way, and usually involved several languages .. but
here is our experience for what it's worth:
 
 
The bad news is that you really need to design these in from the start.
 
We designed all our server code as subroutines such that all of our
subroutines had one of two calling interfaces, either:
 
Subroutine name(InData, OutData, ErrText)
 
or
 
Subroutine name(Action, InData, OutData, ErrText)
 
That meant that we could generate a test rig that could feed the InData
(and Action) and then test for the OutData and log any ErrText values.
For reports, we would capture the report text and do 'spot checks' on
the expected results.
 
 
We also version stamped our routines, so we were certain we were testing
the right versions, and had build scripts to recompile everything.
Nothing left to manual operation since that opens up the opportunity for
something to get forgotten: there is no point testing stuff to QA and
then doing something different when you come to release! Incidentally,
since this was client/server, these involved VBScript scripts for the
client end calling cutting paragraphs on the server along the line.
 
 
Because Universe code doesn't break down into simple blocks, unless you
want to instrument your code and capture all your file I/O - which is
possible - and test for that, your only sensible option is to unit test
at the subroutine/external function level.
 
 
The good news is that because UniVerse caches subroutines in memory, the
overheads to breaking out code are not as high as on systems that do
not. it also means you end up with a more manageable system, better
options for reuse and if you adopt different client front ends, easier
to migrate. You may also find out that your code mass reduces as you
split these out, because there is less duplication (sorry if I'm stating
the obvious here) and so your testing domain is reduced also.
 
 
If you want clean-room regression testing, I highly recommend Virtual PC
is it will support your OS. We kept clean images of all the platforms we
supported, which was a huge time saver. One nice thing about VPC is that
it supports 'undo disks' which means that you can snapshot the image at
a particular point, and then any changes e.g. brought on by software
loads for testing are physically and transparently stored outside the
virtual disk and you choose at the end whether to commit those changes
or not, making it very easy to go back if that version didn't pass.
 
 
Finallly, having a predictable way to load routines from dev to QA and
from QA to live is a must - so I'll put in a very small [AD] for
mvInstaller...
 
Regards
 
Brian
 
 




From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: 10 June 2009 20:33
To: u2-users@listserver.u2ug.org
Subject: [U2] UniVerse Unit Testing



The powers that be have been discussing the possibility of going
to a unit test model for QA.  As I understand the concept, portions of
code are broken down into smaller manageable chunks against which a
dedicated unit test for each may be run.  This seems like a good idea in
an object oriented world where methods of object can be easily invoked.
This would seem less practical in with a procedural language like BASIC.

It feels like we would end up breaking out thousands of lines of
code into external subroutines which could then be run through a
dedicated unit test.  This would introduce significant overhead with all
the CALLs to hundreds (thousands) of external subroutines.  Then there
are complications such as variables in named common, etc.

Is anyone out there in MV land employing serious unit testing?
If so, care to share your experiences, concerns, success stories?

Thanks. 

Perry Taylor 
Zirmed, Inc. 

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

[U2] UniVerse Unit Testing

2009-06-10 Thread Perry Taylor
The powers that be have been discussing the possibility of going to a
unit test model for QA.  As I understand the concept, portions of code
are broken down into smaller manageable chunks against which a dedicated
unit test for each may be run.  This seems like a good idea in an object
oriented world where methods of object can be easily invoked.  This
would seem less practical in with a procedural language like BASIC.

It feels like we would end up breaking out thousands of lines of code
into external subroutines which could then be run through a dedicated
unit test.  This would introduce significant overhead with all the CALLs
to hundreds (thousands) of external subroutines.  Then there are
complications such as variables in named common, etc.

Is anyone out there in MV land employing serious unit testing?  If so,
care to share your experiences, concerns, success stories?

Thanks.

Perry Taylor
Zirmed, Inc.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


RE: [U2] AUTOLOGOUT and ON.ABORT

2009-02-27 Thread Perry Taylor
Just a side note on the errlog file... You can increase the number of
messages by increasing the MAXERRLOGENT parameter in uvconfig.

Perry 

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G.
Sent: Thursday, February 26, 2009 11:17 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] AUTOLOGOUT and ON.ABORT

If you turn on the errlog file in /u1/uv you may get a message in there
for an AUTOLOGOUT.  I'm pretty sure I've seen such messages in the past.
You will have the user name, the PID and some text describing the error.

The errlog file only keeps the last 1001 error messages so you might
want to have a cron job back them up with a date time stamp periodically
during the day.



- Original Message 
 Our users have their AUTOLOGOUT set to 30 minutes and it looks like
the
 AUTOLOGOUT process causes the ON.ABORT clause to execute.  Is there an
 easy  way using a SYSTEM() or @variable to determine that this
ON.ABORT is the
 result of an AUTOLOGOUT?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] AUTOLOGOUT and ON.ABORT

2009-02-27 Thread Perry Taylor
#touch $(cat /.uvhome)/errlog


- Original Message -
From: owner-u2-us...@listserver.u2ug.org owner-u2-us...@listserver.u2ug.org
To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
Sent: Fri Feb 27 15:55:22 2009
Subject: Re: [U2] AUTOLOGOUT and ON.ABORT

Ok, so I just create a type 18 file called ERRLOG in the UV account and
restart universe?

On Fri, Feb 27, 2009 at 11:59 AM, Martin Phillips 
martinphill...@ladybridge.com wrote:

 Hi Mike,

  I was under the impression that the errlog only existed on
 unix systems. Maybe I'm wrong on this but I can't find it
 anywhere on our system.


 The errlog file is on Windows too but, just as on Unix, you need to create
 an empty errlog file in the UV account directory to enable the system. UV
 looks for this on entry and enables logging.


 Martin Phillips
 Ladybridge Systems Ltd
 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB
 +44-(0)1604-709200 ---

 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited. ZirMed, Inc. has strict policies regarding the
content of e-mail communications, specifically Protected Health Information,
any communications containing such material will be returned to the
originating party with such advisement noted. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies of
the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] SQL select subquerying a saved list.

2009-01-27 Thread Perry Taylor
I do it in a similar way...

SELECT @ID FROM EINVOICES WHERE iInvoiceRef IN (SELECT EVAL @RECORD
FROM SAVEDLISTS 'INV.REF.LIST'); 

... But I agree there should be a more natural way of doing this.

Perry Taylor

-Original Message-
From: owner-u2-us...@listserver.u2ug.org
[mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Boydell, Stuart
Sent: Monday, January 26, 2009 11:40 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UV] SQL select subquerying a saved list.

Hi,
I'm wondering if someone can show me a more elegant way to do a SQL
subquery.
I have a saved select list with a list of values which I want to
test
for in a SQL select IN clause.

Eg. 
SELECT @ID FROM EINVOICES WHERE
iInvoiceRef IN (SELECT EVAL
'TRANS('SAVEDLISTS,INV.REF.LIST,-1,)'
FROM VOC WHERE @ID =
'WHO');

This works, but I don't like the format of
the subquery. I have done
this type of thing before but when the list was a
list of keys to
another file I could create a subquery like SELECT @ID FROM
OTHER.FILE
SLIST INV.REF.LIST. In this case iInvoiceRef doesn't link to
another
file.

I have used the TRANS/VOC arrangement which seems like a
hack to me,
it's also relatively slow. Does anyone know a 'nicer' way to get
back a
select list to use with the IN clause?

Regards,
Stuart Boydell
**
This
email message and any files transmitted with it are confidential and
intended
solely for the use of addressed recipient(s). If you have received this
communication in error, please reply to this e-mail to notify the sender
of
its incorrect delivery and then delete it and your reply.  It is your
responsibility to check this email and any attachments for viruses and
defects
before opening or sending them on. Spotless collects information about
you to
provide and market our services. For information about use, disclosure
and
access, see our privacy policy at http://www.spotless.com.au 
Please consider
our environment before printing this email.
**
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2][JOB]

2008-12-11 Thread Perry Taylor
Zirmed, Inc., an industry leader in health care revenue cycle
management, seeks an experienced UniVerse developer to join our growing
development team in Louisville, Kentucky.

Zirmed provides an exciting work environment, competitive compensation
and excellent benefits.

Benefits include:  Medical Insurance, Life Insurance, Dental Insurance,
Vision Insurance, Paid Vacation, Paid Sick Days, Paid Holidays, Short
Term Disability, Long Term Disability, 401K/403b Plan, Stock Options,
Educational Assistance, Special Incentive Plans

Screening Requirements: Credit Check, Reference Check

Submit inquires and/or resumes to Larry Schremser at
larry.schrem...@zirmed.com 
--
 
Job Title: UniVerse Developer
Department: Information Technology
Reports To: IT Resource Manager

Position Overview
 
This person will be responsible for working with the Technology and
Business teams to design, build, implement, and maintain various process
applications.  This person also will assist the customer support
department to resolve issues relating to production processes.

General Responsibilities
*   Design/Develop/Test/Implement improvements or new features to
the ZirMed UniVerse applications.
o   Work with the various departments and team members to design
and/or implement new enhancements to existing applications.  This
includes, but is not limited to, table design and process design written
in UniVerse BASIC.
o   Test all changes in development and work with the appropriate
business and/or technology owner(s) to ensure development meets business
requirements. 
o   Track any changes required by such development using internal
tools and communicate to the QA Technical Coordinator any special
requirements to push the changes from development through the various
stages to production.
o   Communicate development progress daily using an internal project
tracking tool.
o   Assist in the QA process.
o   Participate as required in production code deployments.
*   Work with Customer Service staff to resolve issues relating to
production.
o   Research system behavior to determine why customer data is not
behaving as expected and communicate findings back to the appropriate
personnel.
oModify any existing processes to fix problems identified as a
result of said research.
o   Add new logic to existing data tweak infrastructure to
manipulate customer data under the direction of the customer support and
EDI staff.
o   Produce ad-hoc reports as necessary for the customer support
team.
*   Develop and maintain an open and fluid communication
relationship with management.
o   Identify and inform the technology manager of areas of the
application that require new or improved technology solutions.
o   Notify the technology manager of any problems that negatively
impact applications and work to implement a solution.
*   Attend to any work items assigned through the internal case
system in a timely fashion.
o   Communicate and work with the resource manager to reassign any
items that can not be addressed in a timely fashion.
o   Provide estimates for project tasks using an internal project
tool, and update the estimates if they increase or decrease.
*   Develop and maintain a positive relationship with other team
members.

Required Skills
*   3 years multi-value database programming experience with
preference for UniVerse given.
*   3 years multi-value database query experience, including but not
limited to the use of RetrieVe, dictionaries of varying types, indexes,
etc.
*   Excellent written and verbal communication skills.
*   Highly self-motivated.
*   Ability to work both in team and solo environments.

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited. ZirMed, Inc. has strict policies regarding the 
content of e-mail communications, specifically Protected Health Information, 
any communications containing such material will be returned to the originating 
party with such advisement noted. If you are not the intended recipient, please 
contact the sender by reply e-mail and destroy all copies of the original 
message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2][UV] EQUATEs Using System Delmiiters

2008-10-11 Thread Perry Taylor
The requirement is for up to 1000 or so arrays which are used only
within the subroutine.  If they are assigned upon entry each variable
has to have memory setup and the values have be contatenated and stored
in the variables.  I could put them in named common and only initialize
them once but still the overhead exists for the one-time initialization.
If the values are EQUates the concatenation is accomplished at compile
time and the only overhead is the object code load when the subroutine
is called.

Am I making sense?

Perry 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming
Sent: Saturday, October 11, 2008 12:12 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2][UV] EQUATEs Using System Delmiiters

I too was going to ask why not a regular variable?

What does that mean, overhead of setting up the variables. Is this
item
passed thru the subroutine either directly or indirectly or is it
equated in
both the sub and the calling program.

Thanks in advance for the explanation.
Mark Johnson
- Original Message -
From: Perry Taylor [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, October 06, 2008 10:27 PM
Subject: RE: [U2][UV] EQUATEs Using System Delmiiters


 The parentheses do the trick!  Thanks to everyone.

 BTW... The reason I don't want to use variables is this is going in a
 subroutine and I don't want the overhead of setting up the variables
 when it is called.

 Thanks again!

 Perry

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Womack,
Adrian
 Sent: Monday, October 06, 2008 6:45 PM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2][UV] EQUATEs Using System Delmiiters

 Try putting parentheses around the expression:

 eg.  EQU MX TO ('ABCD':@AM:'EFGH')

 That will cause each of the functions to operate on the whole string
 rather than on a single element of the string.

 Although something strange is obviously going wrong. I would have
 expected the operations to affect just the last portion (EFGH) but
it
 seems to be affecting the first portion.

 Why use EQUATE anyway in this case, you'd be better of just assigning
a
 variable.

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor
 Sent: Tuesday, 7 October 2008 4:06 AM
 To: U2-Users List
 Subject: [U2][UV] EQUATEs Using System Delmiiters

 I'm trying to use EQUates to setup static arrays in a BASIC program
but
 am getting strange results.  The UniVerse BASIC manual says you can
use
 any valid BASIC expression as an object to the symbol.  However when I
 try to create an array with...

 EQU MX TO 'ABCD': @AM: 'EFGH'

 ... I get strange results.  Consider the following code...

 --
   EQU MX TO 'ABCD': @AM: 'EFGH'

   CRT
   CRT 'MX=': MX

   LC = LEN(MX)

   CRT
   CRT 'LEN(MX)=': LC
   CRT

   FOR NC = 1 TO LC

  CRT 'SEQ(MX[': NC: ', 1])=':SEQ(MX[NC, 1])

   NEXT NC

   CRT

   LAMC = DCOUNT(MX, @AM)

   CRT
   CRT 'DCOUNT(MX, @AM)=': LAMC
   CRT

   FOR AMC = 1 TO LAMC

  CRT 'MX': AMC: '=': MXAMC

   NEXT AMC
 --

 When I run this code in a Pick-flavored account I get the following
 results...

 --

 MX=ABCD~EFGH

 LEN(MX)=9

 SEQ(MX[1, 1])=65
 SEQ(MX[2, 1])=65
 SEQ(MX[3, 1])=65
 SEQ(MX[4, 1])=65
 SEQ(MX[5, 1])=65
 SEQ(MX[6, 1])=65
 SEQ(MX[7, 1])=65
 SEQ(MX[8, 1])=65
 SEQ(MX[9, 1])=65


 DCOUNT(MX, @AM)=2

 MX1=ABCD~EFGH
 MX2=ABCD~

 --

 What am I missing here?

 Thanks.

 Perry Taylor
 Zirmed, Inc.
 UniVerse 10.1.21/RHEL3



 CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments,
 is for the sole use of the intended recipient(s) and may contain
 confidential and privileged information.  Any unauthorized review,
use,
 disclosure or distribution is prohibited. ZirMed, Inc. has strict
 policies regarding the content of e-mail communications, specifically
 Protected Health Information, any communications containing such
 material will be returned to the originating party with such
advisement
 noted. If you are not the intended recipient, please contact the
sender
 by reply e-mail and destroy all copies of the original message.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/


 DISCLAIMER:
 Disclaimer.  This e-mail is private and confidential. If you are not
the
 intended recipient, please advise us by return e-mail immediately, and
 delete the e-mail and any attachments without using or disclosing the
 contents in any way. The views expressed in this e-mail are those of
the
 author, and do not represent those of this company unless this is
 clearly indicated. You should scan

  1   2   3   >