[U2] Elections and Membership
All, While you are all welcome to be members of the lists and not be members of the U2UG organization, we recommend that you consider joining the U2UG. Membership is free and, with elections coming up soon, this is an ideal time to join and let you voice be heard. To join the U2UG, follow this link: http://u2ug.org/user.php?op=check_agemodule=NS-NewUser - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. For non-U2UG e-mail: [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
Mark Johnson wrote:
REMOVE doesn't give you the MV counter for the associated fields
by itself. You have to manage separately and hope to keep in sync.
That's more code.
You can do multiple removes on different MV strings instead of keeping a
counter and referencing the associated fields as RECX,X.
For example:
LOOP
REMOVE VAR1 FROM REC15 SETTING DELIM
REMOVE VAR2 FROM REC16 SETTING NOTHING
...
{ do something with the variables }
WHILE DELIM REPEAT
Larry Hiscock
Western Computer Services
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 1/3/2006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] DCOUNT
If we where obj orientated we could have REC15.dcount but alas no
On 1/6/06, Larry Hiscock [EMAIL PROTECTED] wrote:
Mark Johnson wrote:
REMOVE doesn't give you the MV counter for the associated fields
by itself. You have to manage separately and hope to keep in sync.
That's more code.
You can do multiple removes on different MV strings instead of keeping a
counter and referencing the associated fields as RECX,X.
For example:
LOOP
REMOVE VAR1 FROM REC15 SETTING DELIM
REMOVE VAR2 FROM REC16 SETTING NOTHING
...
{ do something with the variables }
WHILE DELIM REPEAT
Larry Hiscock
Western Computer Services
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 1/3/2006
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
This is the way we always do it. For associations, you might be better off creating a separate set of subroutines that add and delete to rows of associated values. Its just more controlled and you dont end of with uneven columns of data. The system Im working was not designed this way and I was finding tables of data within records that were uneven. We still have a little of that left and I plan to knock that out when we can. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Thursday, January 05, 2006 12:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] DCOUNT I'm finding that I'm doing a lot of programming for the processing through multi-valued attributes. I'm wondering if the method I'm using is the best way to determine the last element. LAST=DCOUNT(REC15,@VM) FOR I=1 TO LAST (process something) NEXT I There was a REMOVE thread a few months ago and I use that when I expect that the number of elements could test the patience of the EXTRACTs. REMOVE doesn't give you the MV counter for the associated fields by itself. You have to manage separately and hope to keep in sync. That's more code. I know that in VB certain object array variables (a list box for example) has a property for the number of elements. Is there anything in MV that I'm not aware of for determining the last multi-value that's easier to type than the DCOUNT expression. I'm looking at reducing my keystrokes. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.14/222 - Release Date: 1/5/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.14/222 - Release Date: 1/5/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] OSBWRITE problem
Colin, That worked a treat. Thanks! Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 05 January 2006 20:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] OSBWRITE problem You can try NOCONVERT ON to see if that fixes your problem. Hth Colin Alfke Calgary, Canada -Original Message- From: Brian Leach All, I'm having a problem writing a binary file from UniData. I need to store some lengths as 4 byte integers, and I'm deliberately encoding all numbers to base 250 + 1 shifted to avoid writing char(0) or char(255)s but I'm still getting a problem with byte translation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Backup, dbpause 24/7 operation
As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
But this doesn't save much on the typing front, which apparently is the
real objective of the question :-(
However, with a 'smart' pre-compiler you can achieve your OO objectives,
AND(or) reduce typing. (Of course we have such a beast within our Visage
environment)
There are some other advantages to this pre-compiler approach, like
being able to freely (and easily) change the physical implementation of
something if you DO find that there is a more efficient way to work.
For example your pre-compiler directive may look like this :
vl REC 15 mysub
(I've assumed REALLY short names like vl (for a value loop) to reduce
typing, and that mysub is a reference to an internal subroutine to do
something with the variables)
The initial implementation of vl may initially generate code something
like :
LAST = DCOUNT(REC15,@VM)
FOR I = 1 TO LAST
GOSUB mysub
NEXT I
which is a saving on the typing front (my favourite is the
select/readnext/read/write loop). Or perhaps (better) with a small
change to mysub
LAST = DCOUNT(REC15,@VM)
FOR I = 1 TO LAST
THIS.REC = REC15,I
GOSUB mysub
NEXT I
Our next iteration on the journey may generate this code
TEMP.REC15 = REC15
LAST = DCOUNT(TEMP.REC15,@VM)
FOR I = 1 TO LAST
THIS.REC15 = REC151,I
GOSUB mysub
NEXT I
to avoid jumping over the leading 14 attributes every time, and if LAST
was getting big, then we could change the implementation to generate
LOOP
REMOVE THIS.REC15 FROM REC15 SETTING DELIM
GOSUB mysub
WHILE DELIM REPEAT
to gain the advantages of REMOVE (internal pointers for where we were up
to in the string)
The nice thing about this approach is that if you DO find a better way
to do something that you do often, it becomes very easy to change it
everywhere in your application.
(You can also have 'implementations' of things that may generate
something other than Basic code, but that is a whole other story -
suffice to say that this snippet technology also powers our
multi-lingual capabilities)
Within the context of our Visage development, by adopting his technique
we have a single source tree that can generate code that is
targeted/optimised for a particular OS database version type. Whilst
we can debug with the generated code, we develop at a higher (macro)
level
Maybe a long way off topic, but if you are serious about reducing
keystrokes, as part of our Active Code Reduction initiative we have
found that using this type of technique, a single high level
pre-compiler directive may generate 5-50 (or more) lines of efficient,
error-free, local-standards compliant code, resulting in faster
development, and easier maintenance enhancements
Ross Ferris
Stamina Software
Visage Better by Design!
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Symeon Breen
Sent: Friday, 6 January 2006 10:25 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] DCOUNT
If we where obj orientated we could have REC15.dcount but alas no
On 1/6/06, Larry Hiscock [EMAIL PROTECTED] wrote:
Mark Johnson wrote:
REMOVE doesn't give you the MV counter for the associated fields
by itself. You have to manage separately and hope to keep in sync.
That's more code.
You can do multiple removes on different MV strings instead of
keeping a
counter and referencing the associated fields as RECX,X.
For example:
LOOP
REMOVE VAR1 FROM REC15 SETTING DELIM
REMOVE VAR2 FROM REC16 SETTING NOTHING
...
{ do something with the variables }
WHILE DELIM REPEAT
Larry Hiscock
Western Computer Services
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] DCOUNT
Mark Johnson [EMAIL PROTECTED] wrote on Thu, 5 Jan 2006 00:21:37 -0500 I'm finding that I'm doing a lot of programming for the processing through multi-valued attributes. I'm wondering if the method I'm using is the best way to determine the last element. LAST=DCOUNT(REC15,@VM) FOR I=1 TO LAST (process something) NEXT I If you're working with ASSOCIATED multi-values and you need to process every one, this may be your best bet, although there are some other options. If you just need to process each item in a single multi-valued attribute (without updating the original), you could consider: REC15 = RAISE(REC15) SELECT REC15 TO R15.LIST LOOP WHILE READNEXT MV FROM R15.LIST DO (process MV) REPEAT For example, I use the above syntax to process each line in a sales order, where the multi-value in the order header contains the keys to the individual line items. If your controlling multi-value is sorted and you only need to process a known value, you can use the LOCATE function to find the appropriate spot. With associated multi-values, you'll need to use the INSERT (or DELETE) function on the associated items to add (or remove) value groups from the list. Note that these functions are flavor dependent. --Tom Pellitieri Toledo, Ohio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] DCOUNT
I personally would even write it like this if I am sure the number of values is no more then ten: FOR I=1 TO DCOUNT(REC15,@VM) (and of course I would not use number as a field position) - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, January 05, 2006 5:21 AM Subject: [U2] DCOUNT I'm finding that I'm doing a lot of programming for the processing through multi-valued attributes. I'm wondering if the method I'm using is the best way to determine the last element. LAST=DCOUNT(REC15,@VM) FOR I=1 TO LAST (process something) NEXT I There was a REMOVE thread a few months ago and I use that when I expect that the number of elements could test the patience of the EXTRACTs. REMOVE doesn't give you the MV counter for the associated fields by itself. You have to manage separately and hope to keep in sync. That's more code. I know that in VB certain object array variables (a list box for example) has a property for the number of elements. Is there anything in MV that I'm not aware of for determining the last multi-value that's easier to type than the DCOUNT expression. I'm looking at reducing my keystrokes. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
If you are truly 24x7 then the best way in my opinion would be to mirror - or better yet - triple mirror the disks. Then, using dbpause to pause, split one of the mirrors off, dbresume and then mount the split disk for backup separately. The triple mirror will then mean you still have two sets of disks operating and providing performance/redundancy whilst being able to backup using the third set with your favourite tool. :-) This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Elections and Membership
There appears to be a small problem on the New User Registration page http://u2ug.org/user.php?op=registermodule=NS-NewUser . Here's what I'm getting... --- New user registration User name: -- _UAUPASS * _UAUPASSCONFIRM * -- E-mail address: ( _FIELD_REQUIRED ) Option: Allow other users to view your e-mail address Fatal error: Call to undefined function getuserfieldlist() in /home/httpd/vhosts/u2ug.org/htdocs/modules/NS-NewUser/user.php on line 115 --- Thanks. Perry Taylor Zirmed, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of u2ug Sent: Friday, January 06, 2006 2:05 AM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [U2] Elections and Membership All, While you are all welcome to be members of the lists and not be members of the U2UG organization, we recommend that you consider joining the U2UG. Membership is free and, with elections coming up soon, this is an ideal time to join and let you voice be heard. To join the U2UG, follow this link: http://u2ug.org/user.php?op=check_agemodule=NS-NewUser - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. For non-U2UG e-mail: [EMAIL PROTECTED] --- 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] Backup, dbpause 24/7 operation
Jeff, We also are a 24/7 shop and we use Tivoli Storage Manager and just back up Unidata hot. What happens is that some very active files will have errors when restored and we simply run fixfile, fixgroup, etc to throw out the incomplete records. This is not perfect, but gets us 99% of the way. Or you could mirror your data, break off the mirror, backup the mirror and then resync the mirrors. This would require a large hardware investment, but would be fairly easy to implement on AIX. Thanks. Unidata 6.1 AIX 5.2 TSM 5.2.6.1 Jeff Powell [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/06/2006 05:14 AM Please respond to u2-users To: u2 users group u2-users@listserver.u2ug.org cc: Subject:[U2] Backup, dbpause 24/7 operation As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Backup, dbpause 24/7 operation
Your query got me curious so I went to our DBA to ask. We have a live system, a fallback system and a development system. 3:00 AM was determined to be the time with the lowest volume of activity. So at that time we do a Unix system copy of the file systems from the live system to the fallback system. The DBA said it takes just under 3 hours to do this. As soon as that system copy is complete a tape backup of the fallback system is made and stored offsite. Then each weekend the Thursday night tape is restored to the development machine. It's not perfect but it works for us. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/06/2006 05:14:50 AM: [snip] How do those companies who operate 24/7 get around this and perform backups? Thanks, [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
Jeff - The answer to that question is rooted in the backup methodology you are employing. If, for example, you are running on EMC, you can pause the database long enough to split off a BCV, then resume the database, and perform your backup from the copy you split off. The SHARK offers Flash Copy, HP Sure Store XP series offers Business Copy. Ultimately, the database is paused to obtain a quiescent image. However, since these splitting operations tend to take only a few minutes, the actual time that the database is unavailable is minimized, often no more than 5-10 minutes. Most shops that have moved to a 24/7 operational strategy have had to revisit how they manage their backups to accommodate their availability requirements. Hope this offers a little insight for you. Regards, Robert DunnMiller CIO, dmcs, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Friday, January 06, 2006 04:15 To: u2 users group Subject: [U2] Backup, dbpause 24/7 operation As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
We are using Veritas NetBackup. What we do is kick off the users, do a disk to disk with Veritas, process nightly (approx 15 minutes of exclusive system use), then allow users to login. After that we duplicated the diskbackup to tape. Our files that are backed up are only about 4.5gb. So, it does go pretty quick. As far as people complaining, what can you say. There are absolutely more sophisticated ways of doing this using replication and so forth. The question is how much do you want to spend on this and how much do you want complicate things ? Sometimes you really have no choice and you have to bit the bullet. I say keep it simple. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Friday, January 06, 2006 5:15 AM To: u2 users group Subject: [U2] Backup, dbpause 24/7 operation As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Backup, dbpause 24/7 operation
Hi, For starters, you might check the features of your AIX filesystem. Does it have any kind of snapshot feature? If it does, you might only need to dbpause while the snapshot command executes. On DEC Tru64, we use the Advanced filesystem (AdvFS). It has a awesome feature called clone filesets. When a clone is created, it keeps copies of the original data before any changes are written. We mount and backup the clone, which gives us a time-sliced snapshot while business rolls on. When the backup is done, we delete the clone and recover the disk space it needed. Another traditional way is to use mirrored disks. The backup script would break the mirror, backup the static data on the unmirrored (and offline) set of disks, and remirror them when it finishes. If your data is stored on a SAN device, the SAN hardware probably has features that can help you, too. Hope this helps, Tom Derwin [EMAIL PROTECTED] 01/06/06 5:14 AM As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Backup, dbpause 24/7 operation
Then, using dbpause to pause, split one of the mirrors off, dbresume and then mount the split disk for backup separately. Beware! Unless your application makes full use of transaction processing, dbpause may well split in the middle of a business transaction. If you were, for example, moving funds between two client accounts, restore of the backup may have the money in both accounts (bad news) or neither account (a healthy profit until someone spots it!). As far as I am aware (and I have put much effort into this one) there is no safe way to backup the system without at least briefly getting all the users to a quiescent state. The easiest way to do this is to get them to log out across the dbpause and mirror breaking operation. Martin Phillips Ladybridge Systems 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/
RE: [U2] [uv] Something Strange happened today {Unclassified}
This did happen to us once before, I think the circumstances were
around unix and not being able to spawn off a new process.
Our problem was with phantoms, I had a phantom process that fired
off other phantom processes, the only problem was the processes that
were fired off were never released because the parent phantom had
never finished.
Our workaround for that was to have the parent phantom chain to itself
after it fired off a new phantom, thus allowing the child phantom to
fully release.
Once we killled the parent phantom job, all of our locked processed
started up like magic.
George
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
HENDERSON MIKE,
MR
Sent: Thursday, January 05, 2006 10:05 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [uv] Something Strange happened today {Unclassified}
Mark,
Since nobody else has replied, I'll put in my two cents worth ...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
When you reconnect/remirror the split drive do you have to re-sync the complete volume or only the data that was updated since the split was executed. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Paterson Sent: Friday, January 06, 2006 9:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Backup, dbpause 24/7 operation If you are truly 24x7 then the best way in my opinion would be to mirror - or better yet - triple mirror the disks. Then, using dbpause to pause, split one of the mirrors off, dbresume and then mount the split disk for backup separately. The triple mirror will then mean you still have two sets of disks operating and providing performance/redundancy whilst being able to backup using the third set with your favourite tool. :-) This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Backup, dbpause 24/7 operation
We do a disk-to-disk-to-tape backup to minimize the amount of quiet time required from the live data files, and we schedule the backup to coincide with the workers' scheduled break. Michael Golden Unique Fabricating Inc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
We only DB Pause the system long enough to sync up a parallel copy of the database on our SAN. The parallel copy then gets unmounted off the production server. It is mounted on the backup up server and a tape backup is done. You need enough disk for another copy of your production files. We mount the backup file system on another machine because tape processes slowed our production box down, so we setup a special server just for backups. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Powell Sent: Friday, January 06, 2006 4:15 AM To: u2 users group Subject: [U2] Backup, dbpause 24/7 operation As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Backup, dbpause 24/7 operation
And if you are using a Windows box, dbpause doe NOT close open files at the O/S level (at least in UniData it does not) -- so you cannot pull a backup against a system that was 'paused' and count on it unless you are SURE your Backup Software *really* handles open files correctly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Elections and Membership
Perry, I've forwarded your complaint to our webmaster. If anyone else is being blocked from joining, please speak up. We'll get you all straightened out. Perry Taylor wrote: There appears to be a small problem on the New User Registration page http://u2ug.org/user.php?op=registermodule=NS-NewUser . Here's what I'm getting... --- New user registration User name: -- _UAUPASS * _UAUPASSCONFIRM * -- E-mail address: ( _FIELD_REQUIRED ) Option: Allow other users to view your e-mail address Fatal error: Call to undefined function getuserfieldlist() in /home/httpd/vhosts/u2ug.org/htdocs/modules/NS-NewUser/user.php on line 115 --- -- - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
snipAnd if you are using a Windows box, dbpause doe NOT close open files at the O/S level (at least in UniData it does not)/snip Just a thought, have you tried the sync command available from http://www.sysinternals.com to see if that helps? I appreciate that the open files issue may still be a headache, but at least any pending writes should be flushed from the OS level in that instance... (One less thing to consider!) This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Backup, dbpause 24/7 operation
Hi, I will be out of the office on the afternoon of 1/6/06. I will return to the office on Monday 1/9/06. I will have limited access to e-mail or voice mail during this time. If a you need an immediate response to your e-mail please e-mail [EMAIL PROTECTED] Thanks and have a great day! Josh --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Elections and Membership
I had the same problem trying to sign-up. Larry E. Friedlander Assistant MIS Manager for Programming Utilities, Inc 2335 Sanders Road Northbrook, IL 60062 Telephone: 847-498-6440 x3318 Fax # : 847-498-2066 __ From: Results [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: Re: [U2] Elections and Membership Date: Fri, 06 Jan 2006 10:59:43 -0500 Perry, I've forwarded your complaint to our webmaster. If anyone else is being blocked from joining, please speak up. We'll get you all straightened out. Perry Taylor wrote: There appears to be a small problem on the New User Registration page http://u2ug.org/user.php?op=registermodule=NS-NewUser . Here's what I'm getting... --- New user registration User name: -- _UAUPASS * _UAUPASSCONFIRM * -- E-mail address: ( _FIELD_REQUIRED ) Option: Allow other users to view your e-mail address Fatal error: Call to undefined function getuserfieldlist() in /home/httpd/vhosts/u2ug.org/htdocs/modules/NS-NewUser/user.php on line 115 --- -- - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
Correct me if I'm wrong but does this method not require the DCOUNT function to be executed each iteration of I to determine if you have reached your max value? Granted, for a small number of values it would not be that much of a hit but I'd not like to encourage this on the off chance that you use it on a large number of values somewhere else. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Serguei Sent: Friday, January 06, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DCOUNT I personally would even write it like this if I am sure the number of values is no more then ten: FOR I=1 TO DCOUNT(REC15,@VM) (and of course I would not use number as a field position) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
Which is why he said no more than ten. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, January 06, 2006 10:43 AM To: u2-users@listserver.u2ug.org Subject:RE: [U2] DCOUNT Correct me if I'm wrong but does this method not require the DCOUNT function to be executed each iteration of I to determine if you have reached your max value? Granted, for a small number of values it would not be that much of a hit but I'd not like to encourage this on the off chance that you use it on a large number of values somewhere else. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Serguei Sent: Friday, January 06, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DCOUNT I personally would even write it like this if I am sure the number of values is no more then ten: FOR I=1 TO DCOUNT(REC15,@VM) (and of course I would not use number as a field position) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
Absolutely correct -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: January 6, 2006 11:43 To: u2-users@listserver.u2ug.org Subject: RE: [U2] DCOUNT Correct me if I'm wrong but does this method not require the DCOUNT function to be executed each iteration of I to determine if you have reached your max value? Granted, for a small number of values it would not be that much of a hit but I'd not like to encourage this on the off chance that you use it on a large number of values somewhere else. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Serguei Sent: Friday, January 06, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DCOUNT I personally would even write it like this if I am sure the number of values is no more then ten: FOR I=1 TO DCOUNT(REC15,@VM) (and of course I would not use number as a field position) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
I'd like to second BobW in NOT using DCOUNT in a FOR line. Certainly when the count is small the overhead is also small, but how many times are we DCOUNTing with certainty that we know the count is less than a particular threshold? Whether the count is zero or higher, I believe it's always better to assign the count to a variable and then loop to the variable; then there's no chance for surprises when the program does encounter an unexpectedly big list. Furthermore, at the risk of offending delicate sensibilities, I take this a step farther and recommend specific variable names for FOR statements. If the list is in a variable called INVOICES, the loop would be: INVOICES.CNT = DCOUNT(INVOICES,@VM) FOR INVOICES.LOOP = 1 TO INVOICES.CNT .. NEXT INVOICES.LOOP (That is, loop variables always end in .LOOP, loop max counts always end in .CNT, and the prefix is the original variable name. It has been my experience that tying the loop max and loop counter to the original variable name (by convention) improves the clarity and purpose of the loop. Your individual results may vary.) This is assuming, of course, that the FOR/NEXT loop is the proper construct for the particular task at hand. If the list is anticipated to be large or there are other extenuating circumstances due to the format of the data being looped through, FOR/NEXT may not be the best choice. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
Hi Jeff, We use the FlashCopy feature of our FAStT disk array. My script does a dbpause, then runs a script to activate flashcopy on our FAStT (which takes a kind of snapshot of the disk, and the array is able to maintain this snapshot even as the underlying data changes) then dbresume. The script then does some stuff behind the scenes to re-mount the filesystems in the snapshot area and the backup proceeds from the snapshot. At the end of the backup, those filesystems are unmounted, and flashcopy turned off. Total time for Unidata to be in a dbpause: anywhere between 20 seconds and a minute (last night's was about 27 seconds) Total time to tape off the snapshot: close to 5 hours Value to a 7x24x365 bidness to get a good night's backup: priceless... :-) -- John Solie -- Professional Hospital Supply -- 951-296-2600 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Friday, January 06, 2006 2:15 AM To: u2 users group Subject: [U2] Backup, dbpause 24/7 operation As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DCOUNT
IMHO it is a bad habit to get into. Bruce M Neylon Health Care Management Group Marilyn Hilb [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/06/2006 12:07 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:RE: [U2] DCOUNT Which is why he said no more than ten. -Original Message- From:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent:Friday, January 06, 2006 10:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] DCOUNT Correct me if I'm wrong but does this method not require the DCOUNT function to be executed each iteration of I to determine if you have reached your max value? Granted, for a small number of values it would not be that much of a hit but I'd not like to encourage this on the off chance that you use it on a large number of values somewhere else. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Serguei Sent: Friday, January 06, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DCOUNT I personally would even write it like this if I am sure the number of values is no more then ten: FOR I=1 TO DCOUNT(REC15,@VM) (and of course I would not use number as a field position) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Create hashed file in subdirectory?
I've used Multi-files like this on Unidata, I tried the following in Universe 10.1.8: Notice that in the second part that I add, I specify 18 503 and 1 as parameters. For some reason, CREATE-FILE uses the 18 as both the file type and modulo. The LISTFILES command confirms that the second part was created with a modulo of 18. CREATE.FILE TEMP.JAG,WORK.JJ 16 17 1 18 101 1 Creating a multilevel data file. Creating file TEMP.JAG/WORK.JJ as Type 18, Modulo 17, Separation 1. Creating file D_TEMP.JAG as Type 18, Modulo 16, Separation 1. CREATE.FILE DATA TEMP.JAG,WORK.KK 18 503 1 Creating file TEMP.JAG/WORK.KK as Type 18, Modulo 18, Separation 1. FILES in your vocabulary 08:45:12pm 06 Jan 2006 Page 1 Filename... Pathname.. Type Modulo F 503 1 DICT TEMP.JAG D_TEMP.JAG 18 16 DATA TEMP.JAG,WORK.JJTEMP.JAG/WORK.JJ 18 17 DATA TEMP.JAG,WORK.KKTEMP.JAG/WORK.KK 18 18 ED MD RELLEVEL 5 lines long. : P 0001: X 0002: 10.1.8 0003: PICK 0004: PICK.FORMAT 0005: 10.1.8 __ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Totaling oddity on UniVerse
A strange oddity I have encountered on UniVerse (10,0,19). I have a file that I build and export to a third party package we have. In this file, the dollar amount values have to be store and sent in OCONV format (that being 123.00 instead of 12300). All the data is MR2 converted and all the data is valid. Before sending, I just like to check that to total dollar amount is correct. So I do a LIST filename TOTALF55 DET-SUPP Dict filename F55 D 55 ATTR 55 12R The output I get is quite bizarre. Instead of the expected value of 134878167.90I get 134878167.890005 Any thoughts ??? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. 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] Create hashed file in subdirectory?
Jacques, Does it work correctly if you specify commas between e.g. CREATE.FILE TEMP.JAG,WORK.JJ 16,17,1 18,101,1 ? It could be flavor dependent. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: 06 January 2006 19:53 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Create hashed file in subdirectory? I've used Multi-files like this on Unidata, I tried the following in Universe 10.1.8: Notice that in the second part that I add, I specify 18 503 and 1 as parameters. For some reason, CREATE-FILE uses the 18 as both the file type and modulo. The LISTFILES command confirms that the second part was created with a modulo of 18. CREATE.FILE TEMP.JAG,WORK.JJ 16 17 1 18 101 1 Creating a multilevel data file. Creating file TEMP.JAG/WORK.JJ as Type 18, Modulo 17, Separation 1. Creating file D_TEMP.JAG as Type 18, Modulo 16, Separation 1. CREATE.FILE DATA TEMP.JAG,WORK.KK 18 503 1 Creating file TEMP.JAG/WORK.KK as Type 18, Modulo 18, Separation 1. FILES in your vocabulary 08:45:12pm 06 Jan 2006 Page 1 Filename... Pathname.. Type Modulo F 503 1 DICT TEMP.JAG D_TEMP.JAG 18 16 DATA TEMP.JAG,WORK.JJTEMP.JAG/WORK.JJ 18 17 DATA TEMP.JAG,WORK.KKTEMP.JAG/WORK.KK 18 18 ED MD RELLEVEL 5 lines long. : P 0001: X 0002: 10.1.8 0003: PICK 0004: PICK.FORMAT 0005: 10.1.8 __ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Totaling oddity on UniVerse
quote who=Barry Rogen A strange oddity I have encountered on UniVerse (10,0,19). I have a file that I build and export to a third party package we have. In this file, the dollar amount values have to be store and sent in OCONV format (that being 123.00 instead of 12300). All the data is MR2 converted and all the data is valid. Before sending, I just like to check that to total dollar amount is correct. So I do a LIST filename TOTALF55 DET-SUPP Dict filename F55 D 55 ATTR 55 12R The output I get is quite bizarre. Instead of the expected value of 134878167.90I get 134878167.890005 Sounds like an IBM RS/6000 anomaly I found when writing a uniVerse calculator. I had it working on a PICK 7800 system (this was years ago) and when I ported it to an IBM RS/6000, I had to re-write it and build in some pretty annoying compensatory tools so the math co-processor (if that's what it's called) couldn't mess my answers so badly that trust was lost. I don't remember what I did, but it was pretty lame to have to do it. So, if you are on an IBM system, you may have found the bug I found years ago. Karl Any thoughts ??? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. 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/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] How to determine the File Name within a dictionary called Subroutine
As I trudge along with a client conversion I've noticed a difficulty using @FILENAME within a BASIC program...it works fine in UniVerse but fails to compile in UniData (P Ecltype). I'm trying to determine, in a subroutine called from a virtual definition, if the file being processed needs to be opened. Code looks like: CurrFileName = @FILENAME IF CurrFileName = EMPLOYEES THEN ReturnValue = @RECORD15 END ELSE ReturnValue = @RECORD12 END RETURN I can use @FILENAME in a virtual dictionary definition but not in BASIC. How do I get the variable of the file being processed in a query, in UniData? Since the same code runs on U2 and D3 I'd like to keep this business rule in the subroutine, that can be used by both. Thanks, any help would be appreciated. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Totaling oddity on UniVerse
It looks like its rounding to six decimal places instead of two. Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 -Original Message- From: Barry Rogen [mailto:[EMAIL PROTECTED] Sent: Friday, January 06, 2006 12:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Totaling oddity on UniVerse A strange oddity I have encountered on UniVerse (10,0,19). I have a file that I build and export to a third party package we have. In this file, the dollar amount values have to be store and sent in OCONV format (that being 123.00 instead of 12300). All the data is MR2 converted and all the data is valid. Before sending, I just like to check that to total dollar amount is correct. So I do a LIST filename TOTALF55 DET-SUPP Dict filename F55 D 55 ATTR 55 12R The output I get is quite bizarre. Instead of the expected value of 134878167.90I get 134878167.890005 Any thoughts ??? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Totaling oddity on UniVerse
sorry, should have specified - HPUX box but thanks for the feedback Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 06, 2006 3:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Totaling oddity on UniVerse quote who=Barry Rogen A strange oddity I have encountered on UniVerse (10,0,19). I have a file that I build and export to a third party package we have. In this file, the dollar amount values have to be store and sent in OCONV format (that being 123.00 instead of 12300). All the data is MR2 converted and all the data is valid. Before sending, I just like to check that to total dollar amount is correct. So I do a LIST filename TOTALF55 DET-SUPP Dict filename F55 D 55 ATTR 55 12R The output I get is quite bizarre. Instead of the expected value of 134878167.90I get 134878167.890005 Sounds like an IBM RS/6000 anomaly I found when writing a uniVerse calculator. I had it working on a PICK 7800 system (this was years ago) and when I ported it to an IBM RS/6000, I had to re-write it and build in some pretty annoying compensatory tools so the math co-processor (if that's what it's called) couldn't mess my answers so badly that trust was lost. I don't remember what I did, but it was pretty lame to have to do it. So, if you are on an IBM system, you may have found the bug I found years ago. Karl Any thoughts ??? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. 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/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Create hashed file in subdirectory?
I tried a few things to arrive at this syntax for Pick flavor: CREATE.FILE DATA TEMP.JAG,TRAVAIL.KK 503,1,16 (Modulo,Separation,Type) The problem I had was when I do: HELP CREATE.FILE at the TCL level I only get examples for a different flavor. Those examples had spaces instead of commas. I have the PDF files, but tend to use the HELP command instead. Still, it shouldn't have created files with a modulo of 18. --- Brian Leach [EMAIL PROTECTED] wrote: Jacques, Does it work correctly if you specify commas between e.g. CREATE.FILE TEMP.JAG,WORK.JJ 16,17,1 18,101,1 ? It could be flavor dependent. Brian __ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Calendar
Hi everyone, We would like to publish a company calendar. We have an intranet running off Unidata thru the DBC cgi script. We are planning to enter events into Unidata records that gets presented in either a standardized, formatted html page or Outlook's calendar. We aren't using Exchange and don't know if feeding Outlook's calendar is even possible. Any suggestions? We are currently using Cyberscheduler for our workgroup application. Thanks, Bob Kinney Buffalo Wild Wings --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Calendar
If you must use Outlook Try working with CSV file. While I have not imported the calendar, I have imported into the address book from a CSV created from a U2 file. Michael Rajkowski Senior Programmer/Analyst GWiz Systems Inc. (720) 212 - 0691 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Kinney Sent: Friday, January 06, 2006 3:16 PM To: U2 Users Subject: [U2] Calendar Hi everyone, We would like to publish a company calendar. We have an intranet running off Unidata thru the DBC cgi script. We are planning to enter events into Unidata records that gets presented in either a standardized, formatted html page or Outlook's calendar. We aren't using Exchange and don't know if feeding Outlook's calendar is even possible. Any suggestions? We are currently using Cyberscheduler for our workgroup application. Thanks, Bob Kinney Buffalo Wild Wings --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Totaling oddity on UniVerse
Barry, Search the archives for anything on wide-zero for detailed explanation, but I'll have a go anyway. It is all to do with binary representation of floating point numbers. If you convert an integer from decimal to binary the resultant value is always precise and unambiguous, the binary can always be converted back to decimal with the correct result. If you try this with a floating point number that isn't always true, a small percentage of decimal values between 0 and 1 do not have a precise binary representation, you can get close but you can't get there exactly. So, if you perform arithmetic operations on these binary representations you stand the chance of getting very small inaccuracies, or rounding errors. Many programming environments (including Unidata) will resolve these for you - I'm not sure how (help me Ken ?) but possibly by converting fp values to integers first, then calculating, then converting back Universe performs the calculation on the fp numbers themselves and uses a tunable parameter (WIDE-ZERO) to allow you to specify the point at which very small values can be considered equivalent to zero. The default value is an industry-standard (IEEE) value of 2.91E-11 which is roughly 1 / 2 pwr 35. By totalling values in external (OCONV) format in Universe you will occasionally fall foul of this and find that the total is out by a small amount - although 0.05 is larger than I would expect, may depend on the number of values you are totalling. You can tune your system by tweaking the value of the wide-zero parameter (default 0x3dc0) or, as recommended by many gurus on this list, you should always perform arithmetic on the internal (ICONV) values so if you modify your F55 definition to ICONV the value with an MD2 conversion then I think you'll find the total to be as expected ( but 100 times too large) Hth Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen The output I get is quite bizarre. Instead of the expected value of 134878167.90I get 134878167.890005 Any thoughts ??? Barry Rogen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [uv] Something Strange happened today
Mike has replied about the negative versus unsigned integer. Looks like one process locked the T30FILE semaphore, which governs access to the T30FILE table in the disk shared memory segment, for longer than the instant expected. Maybe that process was killed at EXACTLY the wrong moment (while it held that semaphore). You could have used analyze.shm -d to see what Type 30 files were open, and analyze.shm -s to see the semaphores (T30FILE is in the final eight). The administrator has an UNLOCK SEMAPHORE command available to free these eight system semaphores in the very unlikely event that it's required. Such as your erxperience! (I was going to fix that spelling, but I actually like the new word!) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Converting number to word
Algortithm refinement: You need to add ST or ND if the final digit is 1 unless the penultimate digit is also 1 in which case add TH. Oconv(TheNumber, NR) will do Roman numerals. I suppose it's a user exit, but one for which there's no code supplied. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Converting number to word
The Advanced UniVerse Programming class used to use this as an example of writing a recursive function. Each thousand-group can make a recursive call. There is no inbuild numbers-to-words function in UniVerse. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV - OPENSEQ and unix pipes
There is (or was) a white paper on using named pipes with UniVerse. Download from IBM web site (start at http://www.ibm.com/software/data/u2 and search for it in the library). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Calendar
Bob, You could join the mvCMS project, which is developing a U2-to-web interface, starting with a calendar application. We will start looking at coding for the core API next week. Watch U2-Community for discussions, details, and progress. - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com Bob Kinney wrote: Hi everyone, We would like to publish a company calendar. We have an intranet running off Unidata thru the DBC cgi script. We are planning to enter events into Unidata records that gets presented in either a standardized, formatted html page or Outlook's calendar. We aren't using Exchange and don't know if feeding Outlook's calendar is even possible. Any suggestions? We are currently using Cyberscheduler for our workgroup application. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: U2 Users Digest V1 #991
I will be out of the country from Sunday 1/8/2006 thru Sunday 1/15/2006. During this time I will not have very limited access to email. If you need to contact me, please try me on my cell phone. 631 680-0691 Thanks, Russ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Launching DOS executables from Universe 10.0.10 on Win 2000
I'm trying to launch a DOS executable (.bat or .exe file) from TCL or from a BASIC program in UV PE Ver. 10.0.10 on Win 2000 Server. The DOS /c (pathname) command Issued both at TCL and from a Basic program runs the DOS command from *within* UV, but I want to run it from outside of UV. I understand from a friend that Unidata uses the command PCPERFORM to accomplish this. We currently use UEXECUTE in mvBase to accomplish this. tia for your suggestions, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Totaling oddity on UniVerse
Goo'day, Looks awfully like the old WIDEZERO problem to me At 23:43 07/01/06 +1100, you wrote: A strange oddity I have encountered on UniVerse (10,0,19). I have a file that I build and export to a third party package we have. In this file, the dollar amount values have to be store and sent in OCONV format (that being 123.00 instead of 12300). All the data is MR2 converted and all the data is valid. Before sending, I just like to check that to total dollar amount is correct. So I do a LIST filename TOTALF55 DET-SUPP Dict filename F55 D 55 ATTR 55 12R The output I get is quite bizarre. Instead of the expected value of 134878167.90I get 134878167.890005 Any thoughts ??? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 06/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 06/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] DCOUNT
Thanks for all that responded. It was not a trick or underhanded question. It was just one of those days when I had programmed DCOUNT about a zillion times and I was wondering if there was any shortcut. It's better than the COUNT function that actually counts something different. I agree that having FOR I=1 to DCOUNT is not a problem with the small counts but dare not consider it as my conscience (the U2 Forum) would frown on it. I've learned a lot from this forum despite my decades of experience as I have not transversed every possible style of coding. My personal collection of styles is gleened from that vast experience of inheriting both good and bad code examples and keeping the best. Thanks Mark Johnson - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 06, 2006 11:42 AM Subject: RE: [U2] DCOUNT Correct me if I'm wrong but does this method not require the DCOUNT function to be executed each iteration of I to determine if you have reached your max value? Granted, for a small number of values it would not be that much of a hit but I'd not like to encourage this on the off chance that you use it on a large number of values somewhere else. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Serguei Sent: Friday, January 06, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DCOUNT I personally would even write it like this if I am sure the number of values is no more then ten: FOR I=1 TO DCOUNT(REC15,@VM) (and of course I would not use number as a field position) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Calendar
Have a look at NebulaManager, which isn't actively offered anymore, but you'll get an idea of what's possible with Outlook and MV: http://removethisNebula-RnD.com/products/manager.htm (I munge the domain because this forum is open to spammers.) There are some free and open source projects out there which allow people to maintain calendars. With some investigation into the datastore for these applications I'm sure someone can work out a U2 interface into them. I'll be happy to do such research and development on a contracting basis. HTH Tony Gravagno Nebula RD TG@ removethisNebula-RnD.com Bob Kinney wrote: Hi everyone, We would like to publish a company calendar. We have an intranet running off Unidata thru the DBC cgi script. We are planning to enter events into Unidata records that gets presented in either a standardized, formatted html page or Outlook's calendar. We aren't using Exchange and don't know if feeding Outlook's calendar is even possible. Any suggestions? We are currently using Cyberscheduler for our workgroup application. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] re: [u2] DCOUNT
Haven't seen anyone mention vector functions here. Do many people use them? In situations where you are performing identical operations on every value in a dynamic array, I rekon vector functions are a more efficient way of handling multivalues then dcount/loop constructs. A simple example of adding 1 to every attribute; instead of: max = dcount(var15,@vm) for i = 1 to max var15,i += 1 next you use: var15 = adds(var15,reuse(1)) Cheers, Stuart --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine
Thanks, but I've already tried this. This is on UD PE v7.1. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Friday, January 06, 2006 1:57 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine try @FILE.NAME -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Friday, January 06, 2006 4:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] How to determine the File Name within a dictionary called Subroutine As I trudge along with a client conversion I've noticed a difficulty using @FILENAME within a BASIC program...it works fine in UniVerse but fails to compile in UniData (P Ecltype). I'm trying to determine, in a subroutine called from a virtual definition, if the file being processed needs to be opened. Code looks like: CurrFileName = @FILENAME IF CurrFileName = EMPLOYEES THEN ReturnValue = @RECORD15 END ELSE ReturnValue = @RECORD12 END RETURN I can use @FILENAME in a virtual dictionary definition but not in BASIC. How do I get the variable of the file being processed in a query, in UniData? Since the same code runs on U2 and D3 I'd like to keep this business rule in the subroutine, that can be used by both. Thanks, any help would be appreciated. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- 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/
