[U2] Elections and Membership

2006-01-06 Thread u2ug
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

RE: [U2] DCOUNT

2006-01-06 Thread Larry Hiscock
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

Re: [U2] DCOUNT

2006-01-06 Thread Symeon Breen
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

RE: [U2] DCOUNT

2006-01-06 Thread Anthony Dzikiewicz
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

RE: [U2] [UD] OSBWRITE problem

2006-01-06 Thread Brian Leach
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

[U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Jeff Powell
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

RE: [U2] DCOUNT

2006-01-06 Thread Ross Ferris
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

Re: [U2] DCOUNT

2006-01-06 Thread TPellitieri
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

Re: [U2] DCOUNT

2006-01-06 Thread Serguei
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:

RE: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Robert Paterson
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

RE: [U2] Elections and Membership

2006-01-06 Thread Perry Taylor
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: (

Re: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread TVankirk
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

Re: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Gordon J Glorfield
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

RE: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Robert DunnMiller
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,

RE: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Anthony Dzikiewicz
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

Re: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Thomas Derwin
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

Re: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Martin Phillips
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

RE: [U2] [uv] Something Strange happened today {Unclassified}

2006-01-06 Thread George Gallen
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

RE: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Tom Dodds
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

Re: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread mgolden
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

RE: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Baakkonen, Rodney A (Rod) 46K
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

[U2] Backup, dbpause 24/7 operation

2006-01-06 Thread David Wolverton
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. ---

Re: [U2] Elections and Membership

2006-01-06 Thread Results
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

RE: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Robert Paterson
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

Re: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread Josh Volosov (3)
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

Re: [U2] Elections and Membership

2006-01-06 Thread Larry Friedlander
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

RE: [U2] DCOUNT

2006-01-06 Thread Bob Woodward
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

RE: [U2] DCOUNT

2006-01-06 Thread Marilyn Hilb
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

RE: [U2] DCOUNT

2006-01-06 Thread gerry-u2ug
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

RE: [U2] DCOUNT

2006-01-06 Thread Kevin King
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

RE: [U2] Backup, dbpause 24/7 operation

2006-01-06 Thread John Solie
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

RE: [U2] DCOUNT

2006-01-06 Thread BNeylon
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

RE: [U2] [UV] Create hashed file in subdirectory?

2006-01-06 Thread Jacques G.
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

[U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread 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

RE: [U2] [UV] Create hashed file in subdirectory?

2006-01-06 Thread Brian Leach
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:

Re: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread karlp
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

[U2] [UD] How to determine the File Name within a dictionary called Subroutine

2006-01-06 Thread Bill Haskett
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

RE: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread Eric Armstrong
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]

RE: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread Barry Rogen
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

RE: [U2] [UV] Create hashed file in subdirectory?

2006-01-06 Thread Jacques G.
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

[U2] Calendar

2006-01-06 Thread Bob Kinney
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

RE: [U2] Calendar

2006-01-06 Thread Mike Rajkowski
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

RE: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread Piers Angliss
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

Re: [U2] [uv] Something Strange happened today

2006-01-06 Thread Ray Wurlod
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

Re: [U2] Converting number to word

2006-01-06 Thread Ray Wurlod
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

Re: [U2] Converting number to word

2006-01-06 Thread Ray Wurlod
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

Re: [U2] UV - OPENSEQ and unix pipes

2006-01-06 Thread Ray Wurlod
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

2006-01-06 Thread Results
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

[U2] Re: U2 Users Digest V1 #991

2006-01-06 Thread Russ DeWitt
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

[U2] Launching DOS executables from Universe 10.0.10 on Win 2000

2006-01-06 Thread Dave Taylor
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

Re: [U2] [UV] Totaling oddity on UniVerse

2006-01-06 Thread Bruce Nichol
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

Re: [U2] DCOUNT

2006-01-06 Thread Mark Johnson
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

RE: [U2] Calendar

2006-01-06 Thread Tony Gravagno
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

[U2] re: [u2] DCOUNT

2006-01-06 Thread Stuart Boydell
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

RE: [U2] [UD] How to determine the File Name within a dictionary called Subroutine

2006-01-06 Thread Bill Haskett
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