[U2] Quickbooks to Dashboard
I know some of you have worked with interfacing Quickbooks into various U2 products, but I was wondering if anyone has generated a Dashboard from the data garnered from Quickbooks. I have a suspect that has a lot of data in Job costing within Quickbooks and is looking to generate a dashboard to get a better handle of the changes in their business. Has anyone seen anything like this. Thanks Tom Dodds ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about uvbackup dd and uvrestore
Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the Ad moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is specifically designed to work with MV databases and is quite capable and reliable. You might want to look into their product. You can find it on their web site. Thanks Tom Dodds On Apr 13, 2011, at 8:12 PM, Augusto Alonso wrote: Hi all. I'm trying to pipe uvbackup (universe) and gzip in order to compress backups on the fly. I've done it with success. But the problem arise when I try to uvrestore from it. A simple test that you can try: RHEL:/u2/uv# find HS.SALES | bin/uvbackup -v -f - |dd of=hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False Label : Current device(s): stdout Backing up HS.SALES Backing up HS.SALES/VOC.u Backing up HS.SALES/D_VOC Backing up HS.SALES/VOCLIB Backing up HS.SALES/D_VOCLIB Backing up HS.SALES/CUSTOMER Backing up HS.SALES/CUSTOMER.u Backing up HS.SALES/D_CUSTOMER Backing up HS.SALES/D_CUSTOMER.u Backing up HS.SALES/PRODUCTS Backing up HS.SALES/PRODUCTS.u Backing up HS.SALES/D_PRODUCTS Backing up HS.SALES/D_PRODUCTS.u Backing up HS.SALES/STATES Backing up HS.SALES/STATES.u Backing up HS.SALES/D_STATES Backing up HS.SALES/D_STATES.u Backing up HS.SALES/HS_FILE_A000 Backing up HS.SALES/D_HS_FILE_A000 Backing up HS.SALES/.hs_fileinfo Backing up HS.SALES/VOC Backing up HS.SALES/.uvconfig Backing up HS.SALES/uvconfig Backing up HS.SALES/puntouvconfig Total files: 24 Total bytes : 97273 Elapsed Time: 00:00:01 12 operating system files processed, 0 broken, totalling 41444 data bytes. 12 UniVerse files processed, 0 corrupted. 939 UniVerse records processed, 0 corrupted, totalling 55829 data bytes. -1073742616 extended keys processed, 0 not supported at specified revision level. EndOfUvbackup 288+0 records in 288+0 records out RHEL:/u2/uv# dd if=hs_sales.bk | bin/uvrestore -v -i -t /dev/stdin Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /dev/stdin WARNING: Block 1 checksum value of 0 does not match computed checksum of -6667. Integrity of block questionable. Continue (Y/N)? intended publication of source code. * Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore 26+0 records in 25+0 records out RHEL:/u2/uv# Could someone explain why this happen? And the backup is all right, because it works if you change the syntax (without pipe): RHEL:/u2/uv# bin/uvrestore -v -i -t hs_sales.bk Backup Date : Wed Apr 13 21:22:29 2011 Reel Number : 1 Image Type: Full Backup (ver9 UNIX) Block Size: 8192 bytes NLS on: False FastWrite On : False Label : Current device(s): /u2/uv/hs_sales.bk HS.SALES (Apr 13 21:22:29) HS.SALES/VOC.u (Apr 13 21:22:29) HS.SALES/D_VOC (Apr 13 21:22:29) HS.SALES/VOCLIB (Apr 13 21:22:29) HS.SALES/D_VOCLIB (Apr 13 21:22:29) HS.SALES/CUSTOMER (Apr 13 21:22:29) HS.SALES/CUSTOMER.u (Apr 13 21:22:29) HS.SALES/D_CUSTOMER (Apr 13 21:22:29) HS.SALES/D_CUSTOMER.u (Apr 13 21:22:29) HS.SALES/PRODUCTS (Apr 13 21:22:29) HS.SALES/PRODUCTS.u (Apr 13 21:22:29) HS.SALES/D_PRODUCTS (Apr 13 21:22:29) HS.SALES/D_PRODUCTS.u (Apr 13 21:22:29) HS.SALES/STATES (Apr 13 21:22:29) HS.SALES/STATES.u (Apr 13 21:22:29) HS.SALES/D_STATES (Apr 13 21:22:29) HS.SALES/D_STATES.u (Apr 13 21:22:29) HS.SALES/HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/D_HS_FILE_A000 (Apr 13 21:22:29) HS.SALES/.hs_fileinfo (Apr 13 21:22:29) HS.SALES/VOC (Apr 13 21:22:29) HS.SALES/.uvconfig (Apr 13 21:22:29) HS.SALES/uvconfig (Apr 13 21:22:29) HS.SALES/puntouvconfig (Apr 13 21:22:29) Total files: 0 Total bytes : 0 Elapsed Time: 12:00:00 0 operating system files processed, 0 broken, totalling 0 data bytes. 0 UniVerse files processed, 0 corrupted. 0 UniVerse records processed, 0 corrupted, totalling 0 data bytes. -1073742632 extended keys processed, 0 not supported at specified revision level. EndOfUvrestore RHEL:/u2/uv# Any suggestion? Regards -- Augusto Alonso IT manager QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al
Re: [U2] Databasic conversion
I have been involved in a number of migrations. I have stubbed my toes on several issues. Printers Assembly language code/C++/ what ever foreign external code Interface to external devices, scanners, funny printers/plotters, etc. The issues of printers is the most common. Users and developers are use to seeing printers react in a certain manner and when they don't react as expected it can derail an entire migrations. I had one client that refused to test every printer, as recommended, and had to cancel the scheduled cut over because they could only address 64 of their 200 printers at one time. If you are using a spooler, check with the developer to be sure it will work on the new platform, if you can still find the developer. HTH Tom Dodds t...@ix.netcom.com 630.235.2975 On Apr 15, 2011, at 10:04 AM, fft2...@aol.com wrote: In a message dated 4/15/2011 5:43:33 AM Pacific Daylight Time, u...@edclark.net writes: But then we decided we wanted to upgrade the universe system and have all our accounting users on that. Just about everything else was ok, but it took the var 3 months of work to convert the procs to work on universe. Can you explain a bit more this statement about Procs and Universe ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SB+ positions available
I know a company that is looking for SB+ North America based contract programmers for 3 months projects (to test you) and then you commonly get extended for 6 or 9 months more. Work on-site for project kick off, then remote, on-site for code drops and go-live. Pays well, including TL. Please forward me your contact information with resume and I’ll make the introduction I know no more about these positions than is stated in the prepared announcement above, so don't ask me any questions, just send me your contact info and your resume and I will forward it on to the employer. Good luck. Tom Dodds t...@ix.netcom.com 630.235.2975 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ positions available
I really don't know anything more than was included in their pre-prepared announcement. Send me you resume and I will pass it on and then you will know. Tom Dodds t...@ix.netcom.com 630.235.2975 On Mar 4, 2011, at 12:03 PM, Paul Wilson wrote: Where ?? I don't care who at the moment - but where does matter. From: Tom Dodds t...@ix.netcom.com To: U2 User group u2-users@listserver.u2ug.org Sent: Fri, March 4, 2011 1:01:11 PM Subject: [U2] SB+ positions available I know a company that is looking for SB+ North America based contract programmers for 3 months projects (to test you) and then you commonly get extended for 6 or 9 months more. Work on-site for project kick off, then remote, on-site for code drops and go-live. Pays well, including TL. Please forward me your contact information with resume and I’ll make the introduction I know no more about these positions than is stated in the prepared announcement above, so don't ask me any questions, just send me your contact info and your resume and I will forward it on to the employer. Good luck. Tom Dodds t...@ix.netcom.com 630.235.2975 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] PORT.STATUS questions.
Good question, Dan Tom Dodds t...@ix.netcom.com 630.235.2975 On Dec 30, 2010, at 12:22 PM, Dan Fitzgerald wrote: Did real estate prices also cause you to stop putting [ad] in your advertisements? From: fft2...@aol.com Date: Thu, 30 Dec 2010 13:19:17 -0500 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] PORT.STATUS questions. In a message dated 12/30/2010 8:46:12 AM Pacific Standard Time, donr_w...@yahoo.com writes: I use PORT.STATUS for several function within programs by capturing the output and parsing it. I have a couple of problems with this. First, only one user at a time can run the command and this causes random failure of the programs. Second, the output can vary depending on options and success or failure of the command. So, is there a callable routine to get the same info in a cleaner way? Yes. If you have a budget. The solution is rather elegant, but also proprietary... to me. You have to buy a license. I stopped giving away free software when real estate went South :) Will Johnson Fast Forward Technologies 831 477 7125 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compiling 101
Good try, First off when you created the file, CODE, you had to be sure to create a Type 1 on Type 19 file. These are really Unix directories and accessible to the basic compiler which is a Unix program. Secondly the compile command, in your case would be BASIC CODE FLAVOR.RO. The second argument is the name of the directory where you placed your source code and the third is the program name as you have already surmised. HTH Tom Dodds t...@ix.netcom.com 630.235.2975 On Oct 19, 2010, at 7:29 PM, Bill Brutzman wrote: I created a new UV account /u2/CODE I put a program in /u2/CODE/BP/FLAVOR.R0. I was not able to compile the program. When I ran the command BASIC BP FLAVOR.R0 I obtained an error message Unable to open BP file. I did a Unix CHMOD command on the parent folders and the file to 777 but still get the same error. I suppose that it is a Q pointer PATH thing. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Performance monitoring
There are a series of articles written by Mark Baldridge that are very good. A little verbose, but very good. You can find them in the Developers Works section of the U2 web site. Here it link to one of them http://www.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-i.html It takes awhile to go through them, but it very educational. HTH Tom Dodds On Mar 4, 2009, at 10:58 AM, ericro wrote: We run an IBM P570 with 12 processors running Universe 10.2.4, average of 400 users against at EMC DMX4500 disk array. 20 file systems with each about 45gb, 60-80% utilized striped across 94 disks. We do tons of batch processing at night and our rate of data change is about 175GB an hour at night. We're running into some performance issues, jobs taking much longer, keyboard response slow, editing single records taking a long time, etc. and want to really dive in to see what's going on. We've looked at file sizing and have done a fair amount of resizing, but to little avail. Does anyone have any tools, or know of any tools, similar to Oracle, that can really give me insight into what's happening with a given user session at any time? I know I can do port.status and find the address in the code and see what's being executed at that time, but I want something more that will show memory utilization and other stats like that. Any help would be appreciated. -- View this message in context: http://www.nabble.com/Performance-monitoring-tp22336819p22336819.html Sent from the U2 - Users mailing list archive at Nabble.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] Remote backup
You might want to contact Ashwood Computer Company of Cincinnati at [EMAIL PROTECTED] They have a backup solution that runs on a Linux server that I am sure could be adapted to multiple UV servers. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Augusto Alonso Sent: Thursday, November 27, 2008 4:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] Remote backup Hi All. I have a variety of Universe servers running in a variety of Unix and windows flavours. I'm facing the problem to manage unattended daily scheduled backups of it. I need to keep the copy, out of the Universe server. It is impossible to design a universal sollution, but all my servers have a common utility: uvbackup. My question is, does anybody knows the way to run uvbackup dumping to a remote device? So that, I could hold the uvbackup image on a small Linux box or eventually send it to some internet-backup-server. TIA -Augusto Alonso --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3644 (20081126) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers on PICK flavor of UV
John, thanks it was the ON EACH ROW that I was missing. It works now, thanks again Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Thursday, November 20, 2008 10:11 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers on PICK flavor of UV i get the same error, unless i use 'FOR EACH ROW CALLING' rather than 'CALLING'. Also, the 'called' trigger needs to be globally cataloged, ie '*UPCASE.IT' j On Thu, Nov 20, 2008 at 10:31 AM, Tom Dodds [EMAIL PROTECTED] wrote: Does anyone know if Triggers are supported under the PICK flavor of UniVerse. CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; Statement triggers are not supported. If they are not, does anyone know a cleaver way around it other than writing your own? Thanks in advance Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3627 (20081120) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Pentaho/ETL Tools
You could contact [EMAIL PROTECTED] to look at myviewpoint. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Butera Sent: Friday, November 14, 2008 9:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Pentaho/ETL Tools We're in the midst of creating a data warehouse from our UniData databases and exploring the possibility of using Pentaho. Their ETL tool does have an entry for Universe (not Unidata), but the connection methods are JDBC, ODBC or JNDI. We don't want to create an SQL-view of Unidata merely for ETL, we'd prefer to find an ETL tool that can natively talk with Unidata. Has anyone worked with Pentaho? Any thoughts? Does anyone have ETL tools in mind that natively talk to Unidata? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Dad, I'm not listening to you. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3614 (20081114) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Create file on remote account
Brian, this worked like a champ. Thanks very much for your help Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, November 12, 2008 11:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Create file on remote account Hi You can call out to the underlying $UVHOME/bin/mkdbfile. This creates the physical file in any location you like, then you need to create or update the VOC pointer yourself. Create a verb pointer to mkdbfile, and you can do the rest in a simple program. Syntax to mkdbfile is: mkdbfile path_to_file type modulus separation for example (I'm on Windows) c:\ibm\uv\bin\mkdbfile c:\temp\testfile 18 101 2 Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: 12 November 2008 16:07 To: u2-users@listserver.u2ug.org Subject: [U2] Create file on remote account I know this has been addressed before, but I can't find the references. We need to create files in account(directories) other than where we are running our programs. This is an automated process so it needs to run on the command line. We are running UniVerse 10.2.7 in a Suse environment SUSE Linux Enterprise Server 10 SP2 (x86_64) - Kernel 2.6.16.60-0.27-default (15). Thanks Tom --- 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/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3607 (20081112) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Create file on remote account
I know this has been addressed before, but I can't find the references. We need to create files in account(directories) other than where we are running our programs. This is an automated process so it needs to run on the command line. We are running UniVerse 10.2.7 in a Suse environment SUSE Linux Enterprise Server 10 SP2 (x86_64) - Kernel 2.6.16.60-0.27-default (15). Thanks Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Create file on remote account
This one doesn't seem to work in a PICK flavor, but thanks. I got a regular file with DIRECTORY /U2/DEV as the comment on line 1. 1 F DIRECTORY /U2/DEV/ Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Henry Unger Sent: Wednesday, November 12, 2008 12:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Create file on remote account In PI/open, there are two version: CREATE.FILE file.name DIRECTORY CREATE.FILE file.name DYNAMIC DIRECTORY path The former creates a directory in the current account, and the latter a dynamic file in the specified directory. Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, November 12, 2008 8:46 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Create file on remote account Is this the DIRECTORY keyword? (Be careful, in PI this meant create a type 1 file, so it might be a bit temperamental to get working.) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: 12 November 2008 16:07 To: u2-users@listserver.u2ug.org Subject: [U2] Create file on remote account I know this has been addressed before, but I can't find the references. We need to create files in account(directories) other than where we are running our programs. This is an automated process so it needs to run on the command line. We are running UniVerse 10.2.7 in a Suse environment SUSE Linux Enterprise Server 10 SP2 (x86_64) - Kernel 2.6.16.60-0.27-default (15). Thanks Tom --- 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/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3607 (20081112) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Identifying the pid for a user
Thanks to all who submitted suggestions. I got it to work. Thanks again Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Wednesday, November 12, 2008 4:12 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Identifying the pid for a user DECLARE GCI getpid ; * general C interface call PID = getpid() ; * get the unix process ID for this process -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Saturday, November 08, 2008 1:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Identifying the pid for a user Tom, Try @USERNO, or the USER.NO in LISTU on the entry with the asterisk or the first field from WHO, all on the User's connected line. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Tom Dodds [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, November 07, 2008 12:37 PM Subject: [U2] Identifying the pid for a user I know this has been address before, but I can't find any of the references to the solution. We are running UniVerse 10.2 in a Suse environment and I would like a reasonably simple method of acquiring the pid of the current process. Thanks for the help. Tom Dodds [EMAIL PROTECTED] 630.235.2975 --- 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/ This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3607 (20081112) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Identifying the pid for a user
I know this has been address before, but I can't find any of the references to the solution. We are running UniVerse 10.2 in a Suse environment and I would like a reasonably simple method of acquiring the pid of the current process. Thanks for the help. Tom Dodds [EMAIL PROTECTED] 630.235.2975 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe 10.2.9 PE install
When I try to install UV 10.2.8 personal edition I get a File Transfer error 0 and big OK. The window says Universe is configuring your software installation Does anyone have any idea what would cause this condition? Thanks in advance Tom Dodds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe 10.2.9 PE install
Sorry, I should have said that it is being installed on Windows XP SP2. When I try to install UV 10.2.8 personal edition I get a File Transfer error 0 and big OK. The window says Universe is configuring your software installation Does anyone have any idea what would cause this condition? Thanks in advance Tom Dodds __ Information from ESET NOD32 Antivirus, version of virus signature database 3471 (20080925) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Universe SQL Reference if I remember correctly. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, Vance Sent: Wednesday, August 27, 2008 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3392 (20080827) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET
Thanks for asking the question Susan, I learned a lot also. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Wednesday, August 13, 2008 4:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET Greetings, I'm studying the U2 University Agenda to see what mischief I can get into. Anyone know what is the difference between IBM.NET, U2.NET and UNIOBJECTS.NET? There are three distinct sessions at U2U on these. TIA, Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3353 (20080813) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Linux Pseudo Directory
From Wikipedia, the free encyclopedia Jump to: navigation, search A chroot on Unix operating systems is an operation that changes the apparent disk root directory for the current running process and its children. A program that is re-rooted to another directory cannot access or name files outside that directory, called a chroot jail or (less commonly) a chroot prison. The term chroot may refer to the chroot(2) system call or the chroot(8) wrapper program. The chroot system call was introduced by Bill Joy on 18 March 1982 - 17 months before 4.2BSD was released - in order to test its installation and build system. Sounds like it might help you out after all. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: Monday, August 04, 2008 8:31 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Linux Psuedo Directory quote who='Results' date='Monday 04 August 2008' All, I'm going blank on this one, all help appreciated. I want to create a Linux user who cannot see the top level directories, i.e. what they see as '/' is actually further down the chain. Can anyone remind me how? - Chuck Rootless Barouch Somehow 'chroot' does not seem like what you want, but I won't presume. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Email gives the illusion of progress even when nothing is happening. unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3324 (20080804) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11)
We recently had an issue on a Window 2003 server that would seem to hang just on one secession, but not always the same secession. It was not on any specific program, file, subsystem, just completely random. What we, think, we found is that it had recently been added to an additional domain and it seemed that the excess time was being taken by authenticating over the internet to that new domain. When we took it off of that domain the hangs stopped. Our hangs were more like 15,30, 60 second hangs, not minutes that I am aware of. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: Friday, August 01, 2008 11:34 AM To: U2 Users List Subject: [U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11) We are experiencing periodic hangs (up to 5 minutes in duration) accessing the UV database. These hangs are manifesting when accessing the database through JDBC, sometimes when calling a stored procedure, sometimes when running queries directly through JDBC. The problem has appeared in two different, unrelated sub-systems (no common tables are accessed by both). Of course, we first suspected locking issues, but we have not been able to find any evidence that this is the case. In most cases, only one process seems to be accessing the table(s) in question at the time of the problem. Any ideas on how to go about diagnosing this? Or thoughts as to what might be the problem? It would be awfully nice to have a log of all of the queries being executed and how long they took, such as you can easily get from other databases, like mysql, or PostGresql. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3317 (20080801) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Server 2003
Thanks to everyone that has responded. We are researching your suggestions and will get back when we find the culprit. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of lappies Sent: Thursday, July 10, 2008 2:12 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Server 2003 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Server 2003
I have a client that is a running 2003 Server on a large Dell box. Dual quad cpu, 4 gigs of memory, 120 Gig drive, controller driven raid 5( I know about Raid 5 but that is not causing this issue). UniVerse 9.6.2.1, 36 users. We were running on a an old P3 with software raid 5 and very little memory and 18gig drives. One of the drives died and we can't find a replacement for it, so we build a new power server. Every once in a while, every 10/15 minutes a workstation will seemingly stop for between 5 and 15 second and then start up again. It doesn't seem to be the whole system, just one workstation at a time. It is not one program, nor one file, it is seemingly random. We have tried everything we can think of with no results. The database is very small. The largest file is 1.4 gigs, we have resized the larger files. We have taken the current data of off the new server, put it back on the old server and it still runs without any slowdowns. Anyone have any magic. Thanks in advance for your help. Tom Dodds [EMAIL PROTECTED] 630.235.2975 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Global Catalog - Recovery
The host O/S file copy. (cp) Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, May 15, 2008 8:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Global Catalog - Recovery Was the copy done with the COPY verb, or with the host O/S file copy? Regards, Clif On May 15, 2008, at 6:01 PM, Tom Dodds wrote: My experience says that you have to be careful copying the catdir directory. You can get some corrupt data because of the funny characters in the object code stored in catdir. Be careful and verify the content, maybe with VCATALOG, before you stash it away. You will have to verify it each time to copy it because the object may change. I lost a migration weekend because of copying catdir and getting corrupt data. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, May 15, 2008 4:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Global Catalog - Recovery Cataloging locally might not be an option if there are a lot of programs that CALL *XYZ(...) or the old Prime way of XYZ = *XYZ CALL @XYZ(...) Bill, Globally cataloged programs (the ones with the * as the first character) are stored in the catalog space which is really a subdirectory in the UV account called catdir. If you copy the catdir directory, I believe you will have what you need. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 15, 2008, at 1:51 PM, Israel, John R. wrote: Catalog locally and you will never need to re-catalog (assuming local cataloging is acceptable). or Catalogging hundreds of pgms should not be a big deal. SELECT BP (or SELECT BP_O) CATALOG BP FORCE John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, May 15, 2008 4:36 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Global Catalog - Recovery I am trying to validate an emergency recovery scenario. I want to install UV on a disk and lock the disk (unpowered) in a safe. So, if our main disk has a problem, I would just insert the (cold) hot-plugable disk, copy the latest data to this disk and then we are LIVE again... rapidly. To do this, it appears that I need to reCatalog all 100 of our global subs on the new disk. Is there any way around this reCataloging hitch? Suggestions would be appreciated. We are using HP-Ux 11i v2 and UV v10.1. This scenario would also help with smoothly upgrading HP-Ux and UV versions. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- 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/ --- 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] Global Catalog - Recovery
My experience says that you have to be careful copying the catdir directory. You can get some corrupt data because of the funny characters in the object code stored in catdir. Be careful and verify the content, maybe with VCATALOG, before you stash it away. You will have to verify it each time to copy it because the object may change. I lost a migration weekend because of copying catdir and getting corrupt data. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, May 15, 2008 4:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Global Catalog - Recovery Cataloging locally might not be an option if there are a lot of programs that CALL *XYZ(...) or the old Prime way of XYZ = *XYZ CALL @XYZ(...) Bill, Globally cataloged programs (the ones with the * as the first character) are stored in the catalog space which is really a subdirectory in the UV account called catdir. If you copy the catdir directory, I believe you will have what you need. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 15, 2008, at 1:51 PM, Israel, John R. wrote: Catalog locally and you will never need to re-catalog (assuming local cataloging is acceptable). or Catalogging hundreds of pgms should not be a big deal. SELECT BP (or SELECT BP_O) CATALOG BP FORCE John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, May 15, 2008 4:36 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Global Catalog - Recovery I am trying to validate an emergency recovery scenario. I want to install UV on a disk and lock the disk (unpowered) in a safe. So, if our main disk has a problem, I would just insert the (cold) hot-plugable disk, copy the latest data to this disk and then we are LIVE again... rapidly. To do this, it appears that I need to reCatalog all 100 of our global subs on the new disk. Is there any way around this reCataloging hitch? Suggestions would be appreciated. We are using HP-Ux 11i v2 and UV v10.1. This scenario would also help with smoothly upgrading HP-Ux and UV versions. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Triggers
Try looking in the SQL.HELP file. 02 SEARCH SQL.HELP STRING:TRIGGER STRING: 4 record(s) selected to SELECT list #0. LIST ONLY SQL.HELP LIST ONLY SQL.HELP 05:52:53pm 07 May 2008 PAGE1 SYS.HELP CREATE SCHEMA CREATE TRIGGER ALTER TABLE DROP TRIGGER 4 records listed. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Wednesday, May 07, 2008 4:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse Triggers On UV triggers, I've used them often on UD and now have a great application for them on UV. I searched the VOC and found no commands with the word 'trigger' in them. I was expecting the CREATE.TRIGGER of Unidata.What's the syntax for setting them up in UV? Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Friday, April 25, 2008 11:02 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniVerse Triggers Hello, We have received reports that UV triggers have shown some instability. Does anyone have anything to share on this? We have been using them for a couple of years with no issues but were hoping for more details from other users, if available. Thanks much, -Baker --- 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] Maximum size of the record lock table
Everyone seems to have missed the question. Steve knew the problem and what was required to fix it. What he wanted was Can someone tell me what the maximum of locks allowed is, or what the size of the lock table is? Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Tuesday, April 15, 2008 3:57 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Maximum size of the record lock table Steve Ferries wrote: Hi All, We had some excitement today when we ran a program with READU, with the associated WRITE commented out. In no time at all (these RS6000s are fast!), the system froze. I had a login and some UniVerse commands worked, but others did not. LIST.READU showed one user with thousands of locks and that is how we identified the program. snip Directly underneath the commented out WRITE, add a RELEASE statement. In such circumstances, I typically code something like: *DBG WRITE PEOPLE.REC ON PEOPLE.FILE, PEOPLE.ID RELEASE PEOPLE.FILE, PEOPLE.ID;* DBG And when I'm finished debugging, I just uncomment the write, and comment the release. -- Allen Egerton aegerton at pobox dot 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] Mail server issues
Thanks for taking care of things. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Friday, March 28, 2008 6:16 PM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [U2] Mail server issues Hi folks, Our mail servers seem to have suffered a glitch while I was TRYING to take a vacation. The problem has been resolved, and things should be running smoothly once again. Sorry for the inconvenience. If you don't see a message that you sent show up on the list, please resend it, as some message may have been dropped during the problem. Larry Hiscock Moderator --- 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] Indexes
Got me. Thanks Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Sunday, March 16, 2008 6:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexes Ya left out LIST.INTER, LIST.UNION and LIST.DIFF commands! These, admittedly, work with saved - rather than active, in-memory - Select Lists. - Original Message - From: Tom Dodds [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexes Date: Fri, 14 Mar 2008 08:38:08 -0500 I recently put together a Tech Tip for a monthly news Letter about the Merge List process. That might help with your situation, take a look. http://www.ashwoodcomputer.com/TechTip.html This is not an ad for Ashwood Computer Company Tom Dodds [EMAIL PROTECTED] 630.235.2975 snip --- 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] Indexes
I recently put together a Tech Tip for a monthly news Letter about the Merge List process. That might help with your situation, take a look. http://www.ashwoodcomputer.com/TechTip.html This is not an ad for Ashwood Computer Company Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Friday, March 14, 2008 5:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexes I would use the SAVING clause on a select of the repairs file to build a list of stock id's then use a merge list command to see what stock ids do not have a repairs record. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 14 March 2008 10:04 To: u2-users@listserver.u2ug.org Subject: [U2] Indexes My dumb question for the day (just cant remember how to... and the manual's example is too simplistic...) How do I programmatically get an index value out, eg I have a STOCK file, and a REPAIRS file. Whoever designed this needs their head read, but the repairs file only has the stock code as a reference in the record. I have indexed the repair file on stock code, and need to create a report on the stock file of how many items are under repair. 1. UniverseBASIC code? 2. is this possible from an Itype? --- 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] looking for Dan Fitz
I have a [EMAIL PROTECTED] for a Dan Fitzgerald, but there are several of them so I am not sure that this is the right one. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, March 13, 2008 10:20 AM To: U2 Users List Subject: [U2] looking for Dan Fitz anyone knowing dan fitzgerold in portland please let him know I am looking for him. his hotmail email is bouncing DSig David Tod Sigafoos SigsSolutions, Inc. --- 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] TZ in AIX
You can set the time zone by user, at the Unix level, through something like .profile if each user has their own login id or if the one time zone has an login id and the other time zone has another login id. (I forgot the two cities, time zones, involved). We did this with a client that had Eastern time, Central Time and Mountain Time and each user had a separate login in and separate .profile. HTH Tom Dodds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Type ahead buffer overflow
Thanks to everyone that has responded. We have found that upgrading the terminal emulator to the latest version has solved the issue. They were running a very old version of the emulator and were reluctant to upgrade because of costs and some licensing issues. If the issue was solved with the new emulator, it is not a Unix or a UniData based issues. Thanks again to everyone who tried to help Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, February 27, 2008 12:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Type ahead buffer overflow Agreed. You may find tho', that the extra call out to TRIM may cause the input loop to be too slow to collect all the incoming data. Better to get the data, then trim as you process it... Your loop doesn't cater for 80 col lines (or whatever length) and therefore runs the risk of getting to the same place: the input buffer filling up prematurely, or an embedded CR being interpreted an an Enter. By limiting the input to a defined length, the INPUT buffer just handles 80 chars. You may even find, however, that a loop of -1 within a loop of recs may work better... this captures any char sequences embedded (if any) and ensures NO overflow, but might be a bit excessive. This is the method used when getting input from laboratory machines, with NAKs and ACKs, etc. * just get the data in next.key = 0 LOOP chr = 0 LOOP chr += 1 if chr = {whatever length} THEN EXIT INPUT X,-1 LINE := X REPEAT next.key += 1 WRITE LINE ON FILE, next.key REPEAT * now process the input SSELECT FILE LOOP ... REPEAT As for getting the data across, you could always mail it...!!! then issue a PINE command line and capture the output. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Stokes Sent: 26 February 2008 06:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Type ahead buffer overflow That is very similar to the one I use. Here is mine. REC = '' LOOP INPUT XXX UNTIL XXX = *NED OF TEXT* DO REC-1 = XXX REPEAT If you want to lose blank lines you change REC-1 = XXX to IF TRIM(XXX) # THEN REC-1 = XXX --- 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] Type ahead buffer overflow
Or something like that. We have a client that uses a paste from Windows into an input statement, within a UniBasic program, to enter data. The string get quite large and in the transmission from VMS to Unix AIX 5.2 running UniData 7.10 we are losing data. We have played with the terminal emulator as much as possible, but we still lose data coming from Windows into UniData. We have set the sty to utilize xon/xoff, but still we lose data. Is there a way to increase the type ahead buffer so we won't overrun it. The data string could contain multiple pages. Or does anyone have a solution other then changing terminal emulators, that is out of the question at this installation. Thanks Tom Dodds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Type ahead buffer overflow
Thanks for the reply, it may be something we can work out. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Houben Sent: Monday, February 25, 2008 12:44 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Type ahead buffer overflow I have had little to no success over the years in trying to convince various flavors of PICK to honor long strings passed in. The stty settings guarantee that the O/S gets the data, but does NOT guarantee that PICK can handle the long string. What has always worked for us is to insert CRs every hundred or so bytes, and then make sure the data ends with two CRs. The INPUT is done in a loop, concatenating the data, until you get an INPUT with an empty string, at which point you are done. This only works provided that you don't want to preserve CRs for some reason. It means you have to paste into something else, massage it, then copy the massaged text. May not be automated enough for you, but just in case it helps... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Monday, February 25, 2008 9:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Type ahead buffer overflow Or something like that. We have a client that uses a paste from Windows into an input statement, within a UniBasic program, to enter data. The string get quite large and in the transmission from VMS to Unix AIX 5.2 running UniData 7.10 we are losing data. We have played with the terminal emulator as much as possible, but we still lose data coming from Windows into UniData. We have set the sty to utilize xon/xoff, but still we lose data. Is there a way to increase the type ahead buffer so we won't overrun it. The data string could contain multiple pages. Or does anyone have a solution other then changing terminal emulators, that is out of the question at this installation. Thanks Tom Dodds --- 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] Type ahead buffer overflow
The test we have run seems to indicate that the data loss start after about 300 line of 80 characters each and from then on every 90 to 120 line thereafter. They can get to as large as 500-600 lines. It is received into a simple INPUT VAR statement. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Stokes Sent: Monday, February 25, 2008 2:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Type ahead buffer overflow How large is the data? How are you receiving the data? The routines I use hold several pages. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Monday, February 25, 2008 12:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Type ahead buffer overflow Or something like that. We have a client that uses a paste from Windows into an input statement, within a UniBasic program, to enter data. The string get quite large and in the transmission from VMS to Unix AIX 5.2 running UniData 7.10 we are losing data. We have played with the terminal emulator as much as possible, but we still lose data coming from Windows into UniData. We have set the sty to utilize xon/xoff, but still we lose data. Is there a way to increase the type ahead buffer so we won't overrun it. The data string could contain multiple pages. Or does anyone have a solution other then changing terminal emulators, that is out of the question at this installation. Thanks Tom Dodds --- 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] Change Prompt
Try this one, it works on UniVerse 10.2.0 : P 0001: * Program to set the prompt character for a UniVerse Session 0002: * 1 is for TCL 0003: * 2 is used with an active Select list 0004: * 3 is the line continuation character. 0005: PMT = @LOGNAME : ' ': @WHO : ' ' 0006: STELPROMPT = PMT 0007: STELPROMPT2 = @WHO : ' ' 0008: STELPROMPT3 = '+' 0009: ASSIGN 1 TO SYSTEM(4001) 0010: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 10. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Monday, February 18, 2008 11:07 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change Prompt This code works a bomb! Brilliant thank you! The only problem is that now there aren't any when a search (SEARCH) finds anything. Has anybody a solution? (its just blank...) Eg BR201 SEARCH BP STRING:SETTL STRING: 11 record(s) selected to SELECT list #0. There are records selected, but the users are sitting waiting for the -Original Message- IF @ACCOUNT = mc OR @ACCOUNT = da THEN STELPROMPT= @WHO : '' END ELSE STELPROMPT = Press G and hit ENTER to continue END ASSIGN 1 TO SYSTEM(4001) ASSIGN STELPROMPT TO SYSTEM(4002) --- 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] testing
That has been my experience, but then I am not MAJ. :-) Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday, December 31, 2007 10:10 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] testing We have no discrimination around here, if a site is blocked for one it is blocked for all, including the person blocking it. If you came in here on a contract you would be treated the same way. Since you would be on contract I would be surprised if you had any internet access at all. Jerry Banker Sr Programmer Analyst Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Monday, December 31, 2007 9:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] testing Anthony: Then I must not understand what a 'forum' is. I use the Raining Data forum http://forums.rainingdata.com/ all the time (some say too much). This page has the RD 'products' (D3 NT, D3 Aix, D3 Linux, MvBase etc) neatly illustrated like a table of contents and shows the latest posting. Clicking on a 'product' will give you a listing of the topics within. It also shows you the technical announcements and any other top-down information. Within the topics themselves, you can see the different topics with the originator, number of views and replies and the time/date of the latest reply. This forum is spared a bunch of the static that an email forum offers. There are no redundant posts, no comments about trimming extraneous email content, no 'Fred is out of the office problems, etc. The topics may take a non-related tangent but not as pervasive as on the U2 one. By seeing the latest date for each thread, you can quickly see if the thread interests you and if the reply is considered 'new'. As one who participates on both, the RD one more organized. Ask TonyG. He's quite visible on both as well. While this forum is web-based and an email forum is not, I don't buy the argument that employers (clients) prevent internet access by their employees as a reason to not participate. Many of my clients have baracuda or other content blocking firewalls etc that I simply am not restricted with. I am considered middle to upper management by all of my clients as well as many 'employee' programmers should be. We are not the low man on the office totem pole. I've got some clients that sharpen their pencil more than most that allow me full access to the internet despite instituting strong-armed policies about employees mis-using the internet on company time. It's a trust thing. I'm a huge ebay participant and would not dare be caught doing ANYTHING with ebay at a client's site on their dime. My 1 cent Mark Johnson - Original Message - From: Anthony W. Youngman [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, December 30, 2007 6:33 PM Subject: Re: [U2] testing In message [EMAIL PROTECTED], Bill Haskett [EMAIL PROTECTED] writes Wol: I just don't get this attitude. Why is it necessary to pick up our toys and go home? To say, if you don't do things my way I'm quitting the team? There are too many postings that forswear any solution that doesn't result in a complicated mess of things. I don't use forums. I read this mailing list in my spare time, or snatch moments at work. I find forums time-consuming, and a pain, and I have better things to do with my time (like working :-) At the end of the day, all too often I find that the web is a solution in search of a problem. It's the wrong tool for many jobs, and imho this is one of those situations. I rest my case with the fact that other people have pointed out - there ARE fora out there, including those on u2ug. Why are the fora unused while the mailing list carries on regardless? I put it to you - the reason is that most people worth listening to prefer a mailing list. Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] PE Edition Telnet Service Won't Start
I also have the same problem. I am at the U2U conference in San Francisco and have approached the experts with the issue. If we get it resolved I will let all of you know the solution. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Wednesday, November 28, 2007 5:48 AM To: u2-users@listserver.u2ug.org Subject: [U2][UV] PE Edition Telnet Service Won't Start I'm having some trouble getting my UniVerse 10.2 PE (Windows) telnet service to start. The last time I used it several months ago it worked just fine. Now when I try to start it I get this in the event log... Event Type: Error Event Source: IBM UniVerse Event Category: None Event ID: 1004 Date: 11/28/2007 Time: 8:40:30 AM User: N/A Computer: LS031 Description: UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. Running an open ports utility I see nothing bound to port 23. The Windows telnet service is disabled. I have uninstalled and re-installed UniVerse and still have had no success. Has anyone any suggestions? Thanks. Perry Taylor ZirMed --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Subject: [U2] Via Systems
[AD] As long as we are going to push contacts at this person, Larry Christenson is a dealer for Via Systems and ViewPoint. Here is his contact information. Larry has been in the Multi-Valued industry for a long time and has a great back ground in Business Intelligence with extensive experience with MITS. Larry Christensen, C-7 Reporting Solutions, LLC, Direct: 909-349-1736, [EMAIL PROTECTED] [AD] This is not my AD, but just to be sure I don't get chastised. Tom Dodds [EMAIL PROTECTED] 630.235.2975 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT: Email encryption
Here is a snippet from the Outlook help on encryption. It looks like your back to the public key/private key setup which is unacceptable Encrypting an e-mail message in Microsoft Office Outlook 2007 protects the privacy of the message by converting it from readable plaintext into ciphered (scrambled) text. Only the recipient who has the private key (private key: The secret key kept on the sender's computer that the sender uses to digitally sign messages to recipients and to decrypt (unlock) messages from recipients. Private keys should be password protected.) that matches the public key (public key: The key a sender gives to a recipient so that the recipient can verify the sender's signature and confirm that the message was not altered. Recipients also use the public key to encrypt (lock) e-mail messages to the sender.) used to encrypt the message can decipher the message. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, November 16, 2007 3:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT: Email encryption Brenda, If I'm not mistaken Outlook has an encryption feature built into it. Jerry -Original Message- From: Brenda Price [mailto:[EMAIL PROTECTED] Sent: Friday, November 16, 2007 10:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] OT: Email encryption We sometimes have to email csv files with sensitive information to our clients. Right now we are just setting a password to the zipped files. We really need to encrypt either the whole email or just the attached files. We are using Microsoft Outlook. Any ideas? Brenda L Price Senior Programmer Analyst Affiliated Acceptance Corporation Sunrise Beach, MO (800)233-8483 --- 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/ __ NOD32 2664 (20071116) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University
Yea, I am going. Can't wait. Pasta at Fino's Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nancy Fisher Sent: Tuesday, October 30, 2007 11:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 University Is anyone going to the San Francisco end of Nov venue? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ NOD32 2627 (20071030) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Timeout and the break key.
We are running UniData 7.1.10 on AIX 5.1. We set a TIMEOUT set for 1800 seconds in the LOGIN paragraph. If any user encounters a break condition, that condition seems to turn off the TIMEOUT requirements. We have attempted to use ONABORT to turn on the TIMEOUT but the re-setting does not seem to have any effect. We can disable the break key for the normal users and log them out if the hit an error conditions, but we want something to control the idle time associated with the developers as well. The developers need access to the break key. Has anyone else run into this situation and does anyone have a workaround? TIA Tom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Timeout and the break key.
We are not running SB+, I know shame :-) Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Tuesday, October 16, 2007 4:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Timeout and the break key. Wow, that's bizarre. I was able to replicate it on 7.1.9 by logging on, setting the TIMEOUT, then starting SB+, then breaking, and the TIMEOUT is gone. However, if I login, set the timeout, do NOT start SB+, but then break and quit from TCL, the timeout is not lost. So next I wrote a quick 1-liner that does an input, ran it, broke it, and the timeout was cleared. So it apparently is not related to SB+. Very strange. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I *was* Going to the New York U2U Class...
I don't believe this is an appropriate forum for political comment. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, October 12, 2007 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... Have they got a definition of what is considered work? Anybody that attends a convention for their company is usually getting paid while there so I guess it would be considered working there. Or, would it? What do you expect from a state that would support Hillary for congress or anything? -Original Message- From: David Wolverton [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 9:49 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... That's why I called -- it appears to be a TERRIBLY written rule/law -- CNA is who notified me of it, and if you read the 'Comp Blogs' it IS causing them to lose business. It wasn't well thought out it appears. As long as you're not 'working' there, you're OK, or if your carrier by default gives you some sort of NY rider. I'd have to add a full policy in my case, or any issue I had there that would be 'Comp-able' would be denied everywhere -- by CNA locally and by New York - both because I didn't have the right coverage. So - not worth the risk or buying a policy since I don't normally have work there anyway. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, October 12, 2007 9:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... I think I would recheck that. If it is true that would stop New York's convention business completely and I don't think that would be what they would want. --- 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/ __ NOD32 2589 (20071012) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
My guess is that a lot of parsing code is written around that sting for control and to change it, the whole world would come to a screeching halt. :-) (that is a smile) Backward compatibility. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, October 12, 2007 10:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter New line to continue... ...question at the end of a page of missing quote:...'... errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic end of page comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, October 12, 2007 8:30 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes Have you tried using the LIKE option? SELECT CUSTOMER WITH NAME LIKE ...'... -Original Message- From: Charlie Rubeor [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] select statement with single quotes Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = ['] missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = ['] results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- 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/ __ NOD32 2589 (20071012) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [AD] Green Screen Dev. Environment
Have you looked at OpenInsight from Revelation Software. The same people that have done Advanced Revelation for years. They now have a product that will allow the OpenInsight development platform to interface with the U2 database. This is jointly marketed by Revelation and IBM/U2. This allows you to keep the green screens where you want them, but do the new development in a true GUI environment. The report writing abilities are outstanding and from my experience the response time is more that acceptable. You should look into it. This allows you to keep the same data base, the same subroutines and a lot of the same programs and fix up the new ones. I have put the AD in the subject because I know this sounds like and ad. I am not a re-seller for OpenInsight although I have done some development work in the development environment and the U2 interface tool. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Friday, October 05, 2007 3:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Green Screen Dev. Environment Hi list, I'm researching the types of character based development tools that are available in the UV environment for screen and report development. We're cutting/pasting code from our vendors software, which is poorly coded btw, to create new screens and what not. It's a mess and I really want to get away from this practice. I know we can use gui tools like VS, MV.net, etc, but our transactional system is all character based and that's what we want to stick with for the time being. I know AREV and SB+ are out there, but are there others that anyone is using that is not 'home grown'? And if you are using AREV or SB+ how do you like it? Thx, Rudy Technical Project Lead Sage Publications Information Technology Development (805) 410-7724 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ NOD32 2574 (20071005) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is this error??
In have the same problem with the editor some times, but it only happens on my Unix version and not on Windows. The is Unix. (AIX 5.2.? uv 10.1.?) ED VOC New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// TCL Case sensitivity is ON [990070] Try HELP. Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE OFF TCL Case sensitivity is OFF ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// Try HELP. Bottom at line 1. : C/CASE IN/IN Try HELP. : EX * Record changed. OK to quit (Y) ? 0001: CASE IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y But on Windows it works ok. (XP SP@ and UV 10.1.11) ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE TCL Case sensitivity is ON CASE OFF TCL Case sensitivity is OFF .X3 03 ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Thursday, September 13, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] What is this error?? In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- 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] What is this error??
I have been singled out by the powers before, but usually after a few wines. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Thursday, September 13, 2007 3:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] What is this error?? I think it's just us, Tom. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, September 13, 2007 3:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] What is this error?? In have the same problem with the editor some times, but it only happens on my Unix version and not on Windows. The is Unix. (AIX 5.2.? uv 10.1.?) ED VOC New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// TCL Case sensitivity is ON [990070] Try HELP. Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE OFF TCL Case sensitivity is OFF ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// Try HELP. Bottom at line 1. : C/CASE IN/IN Try HELP. : EX * Record changed. OK to quit (Y) ? 0001: CASE IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y But on Windows it works ok. (XP SP@ and UV 10.1.11) ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE TCL Case sensitivity is ON CASE OFF TCL Case sensitivity is OFF .X3 03 ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Thursday, September 13, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] What is this error?? In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Religious Wars
I am against the unmoderated list and I am against the combining of the two lists into one. I often wait with great anticipations the intervention of the moderator when a thread gets to far off track, for my thinking. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Tuesday, September 11, 2007 9:34 AM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2] Religious Wars All, It is no secret that I vehemently disagree with making this an unmoderated list. So I'm going to take a poll. Everyone who is looking forward to no moderator intervention during the next GOTO war or Single Letter Variable war or next Monty Python Quote jamboree, please sound off your approval. All those who want to see personal attacks unsanctioned, sing out. And please take a moment to vote for obscene and inappropriate comments as well. Those who think the mods *should* step in on those sort of things, kindly explain exactly what rules want and don't want. Because the 'freedom now' posts are not well thought out. Digest users, for example, can't filter out posts. People who have quotas on their e-mail boxes really don't want important messages bouncing because two people decide to chat on the list about the nuances of implementing a rock-paper-scissors design strategy on various MV platforms. Some people are stuck with low speed connections. The reason U2-Community is under used is because the vast majority of people on this list aren't very interested in that sort of endless naval gazing. Bear in mind, I generally don't END OF THREAD anything immediately. I shut it down when the value vs. volume becomes reduced. If it is running too long, but still of interest, I send it to U2-Community. If asking you to change the address on the send line is enough to completely kill a topic, you weren't very invested in it, were you? If this sounds angry, you have read it correctly. This is now a U2UG board issue and will be discussed at the Wednesday meeting. I suggest you put your opinions out in the open, on U2-Community -as that is where it belongs under the CURRENT rules, before then. - Charles Barouch, Moderator To subscribe or resubscribe to U2-Community 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] Posting limitations?
I agree. The other side is that if you don't like what is posted you can always go else where for you free advice and free technical support. These are like the popup ads you get with Google because it's free. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, September 06, 2007 4:58 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Posting limitations? Susan: You, nor Tony, nor anyone else, IMHO of course, is abusing anything or anyone. Anytime information is posted it's a good thing. :-) On the other hand, what's being done by those who volunteer to manage U2UG is also a good thing. Totalitarians will always try to rule everyone and everything, but those who are attempting to adhere to, and encourage, courteous behavior shouldn't be treated with disrespect either. The great thing about postings on this list...they can be deleted. No need to demand that they not be posted, unless they're completely disruptive. I don't think anyone on this list has been disruptive. Keep up the good work, to those who volunteer and to those who take the time to post here. :-) Just my humble opinion... Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, September 06, 2007 2:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver Dear List, I'm on offender? In a league of offenders!? While I certainly try not to miss an opportunity to offer information (including product information) to anyone asking for advice or a solution such as mine / in my area of [snipped] Susan Joslyn SJ+ Systems Associates, Inc. --- Date: Wed, 5 Sep 2007 17:08:44 -0600 From: D [EMAIL PROTECTED] Subject: RE: [U2] U2 University Last Week In Denver George, Tony G and Susan J are the biggest offenders. I will make sure that I'm not put into that league. Regards, Doug www.u2logic.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] UD - Open command
Try using the OPENSEQ or an OSOPEN depending on your needs. I can't remember the difference, but HELP should show you the way. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, August 23, 2007 12:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] UD - Open command I was under the impression that UniData could handle something like: OPEN 'E:\DataShare\Temp' TO TEMP.FV ON ERROR CRT File abort. ELSE STOP 201, 'E:\DataShare\Temp' SELECT TEMP.FV IF SYSTEM(11) THEN LOOP READNEXT ID ELSE EXIT ...do something REPEAT END This worked fine in D3 but it is failing (actually the program just stops) in UniData, even though the directory is local and valid. Am I missing something or am I required to create a DIR pointer to the D:\DataShare\Temp local directory first? Thanks, Bill --- 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] Is U2 University worth going to? YES!
Is any one else going to San Francisco's U2 University. I'll be there. When you have a change to take a business trip to San Francisco you should talk advantage of it. It is the last conference so I hope it doesn't get cancelled. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, August 20, 2007 12:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Is U2 University worth going to? YES! I'm planning to attend the San Francisco edition, late November. I was at IBM's huge conference last year and we (U2) just got lost in the mix. This is a much better format. I suppose if you have AIX and U2 and Tivoli, last year's CAAOC (Conglomerated Association of Affiliated Organizations Conference) was ok, because you could talk about all three in one place, but I only met a few other u2 users when milling about. I think users of non-U2 IBM products had the same frustration. I think IBM ended up limiting the number of U2-related breakout sessions too. We could have used more. And it was expensive. I'm guessing half the attendees were IBM employees. Maybe we had to pay for them. What did we get for that extra grand, pooling our education dollars with the disparate dollars of diverse disciplines whose only commonality was the vendor? (a) A roped off section of Disneyland for an evening with music so loud that my ears rang I couldn't network anyway, even when I could find some fellow u2-ists in the crowd; and (b) Gladys Knight and the Pips. Big whoop. (Tho I like Susan Joslyn's suggestion of Bono U2.) I'm looking forward to this year's conference. See you in SF, Chuck Stevenson --- 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] External format command on Unidata
BLIST does a great job of formatting programs, but you can not save them back to the file. It does have lots of options to serve as a tool for tracing problems with source code, but it is only temporary. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Monday, August 13, 2007 10:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] External format command on Unidata U2users, does anyone know the Unidata equivalent of FORMAT BP XYZ thats possible on Universe. Thanks in advance jak --- 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] Looking for a White Paper
From the web address: AD 3003- Case Study: U2 Technology Powers the New IBM Strategic Call Management System IBM is implementing a new call management system based on U2 technology. As part of the evaluation, U2 Lab Services completed a benchmark of our business partner, PDSC's, call management application, wherein 15,200 concurrent users ran on a single system. We will present the key components that made this system scalable enough for a worldwide IBM implementation. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron White Sent: Friday, August 10, 2007 12:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Looking for a White Paper Look at http://www-306.ibm.com/software/info/u2/university/index3.jsp in the AD3xxx section. I did a find on 15,200 and found the statement in question. Ron White Charles Barouch wrote: All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. They pushed it somewhere past 2K users without breaking things and only stopped when they ran out of testing time. I have a client who is part SQL shop and part UniVerse. I'd love to get them a copy of this White Paper so that I can help guide them to a better choice on an upcoming project which could be implemented on either architecture. Showing the robustness of the U2 system would go a long way. Anyone have a link to the paper? --- 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] I need a favor
I agree, it works well and I like the format of the code it generates. Good job Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cordes, Tom (contractor) Sent: Friday, July 27, 2007 9:42 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] I need a favor I like it. Works well. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Thursday, July 26, 2007 11:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] I need a favor All, I just put up a new (free) tool on my site. It takes very little time to use and I'd appreciate it if some of you would beat on it and let me know what you think. http://www.keyally.com/fasterskel/Main.php5 -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- 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] Move data files from Unidata to Universe
You can use UvAdmin's backup and restore capability. There is pretty good HELP for both of these processes and it is good for someone that only does this occasionally. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Monday, July 23, 2007 8:53 PM To: u2-users@listserver.u2ug.org Subject: [U2] Move data files from Unidata to Universe I have a Unidata demo on my pc that I installed along the the PE version of Unidata. I want to test in my Universe/Linux environment. How does one convert a Unidata account to Universe? (I am ok with the ud style dicts, so I just need to convert the data files, indexes? etc.) It has been suggested that uvbackup can do this. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 --- 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] UniData 7.1 vs. MS SQL 2005 performance
I think they should remain here to the benefit of all U2 members. Just my 2 cents worth. Tom Dodds InformCorp, LLC Information for Corporations [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Monday, July 16, 2007 5:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Dawn wrote: I'm starting to get that fear of being tossed to u2-community vibe when typing this... Time for some chocolate, perhaps. --dawn I don't think this is a u2-community discussion. I've been contacted by a few people who have found the discussions (benchmarks, web services, and relational data exchanges) very helpful. However, to avoid bothering people with a focused discussion about which they're not interested, I will offer to take these ongoing technical discussions to a forum on my website or a separate email list. I'll post a note here as soon as I have the forum setup. Regards, T --- 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: [AD] [U2] Basic developments reverse engineering tool ?
We have a series of programs that will dissect a U2 application and create a series of documentation databases. We have some canned reports or you can simply use LIST to generate your own reports. The application is available for installation on one of your systems so you can maintain this level of documentation. We are working on a second module that will allow for the entry of textual descriptions for each component and then generate various types of documentation. IE. html, pdf, csv, rtf, etc Contact me off line if this sounds interesting. Tom Dodds [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Herve Balestrieri Sent: Wednesday, June 27, 2007 10:23 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Basic developments reverse engineering tool ? To clarify the inquiry : I am seeking for a tool reading Basic source code modules and producing a technical documentation of an application automatically. This is not the purpose of an object code decompiler. Thanks Herve' Balestrieri There was UN-Basic that took compiled code and reverted it back to source code. My 1 cent Mark Johnson - Original Message - From: Herve Balestrieri [EMAIL PROTECTED] Does it exists a (marketed?) tool for MV databases (i.e UniVerse) that would allow to make the reverse engineering of an application, based on automated Basic source code analysis ? Thanks for any information. --- 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] VMS Migration
Let me re-phrase my question. Does anyone know if the following option is available in the tar command on VMS? -L InputList The Inputlist argument to the -L option should always be the name of the file that lists the files and directories that need to be archived or extracted. Because VMS also has a limit of 2 gigs on a file size, so if you can limit the files that are a part of a tar file set you can limit the size of the tar file that is created and thus avoid the 2 gig limit on the tar file as well. You just make multiple tar file sets, all of which are less than 2 gigs and you should be able to migrate any size database. I just don't know if the -L option is available on a VMS system Also does any one know if a NFS mount is available on a VMS system? Thanks for your help. Tom Dodds InformCorp, LLC Information for Corporations [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Wyatt Sent: Friday, June 22, 2007 4:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] VMS Migration Tom, In AIX 5.1, tar won't work on files larger than 2 GB: The tar command is not enabled for files greater than 2 Gig in size due to limitations imposed by XPG/4 and POSIX.2 standards From the AIX 5.1 Command Reference manual... Regards, Bob Wyatt We are migrating to AIX 5.1 with UniData 7.1.8 We seem to be having problems trying to tar large files within large directories. Thanks for any help Tom Dodds InformCorp, LLC Information for Corporations --- 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] [UD] Unidata 7.1 / HPUX 11.11i
And the Availability Matrix says: HP/UX PA-RISC Releases 7.1.0 through 7.1.10 have the same comment. UniData 7.1 for HP/UX PA-RISC is 64-bit unless otherwise specified HP/UIX Itanium This version of UniData does not support EDA. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Verhagen Sent: Tuesday, June 12, 2007 4:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Unidata 7.1 / HPUX 11.11i I have a question for the group. Mainly because I'm too lazy to go to the IBM product matrix and also wondering if anyone else is running this configuration. I was told by people inside my organization that UD 7.1.x only runs on HPUX 11.x in 64-bit mode and I find that hard to believe. Currently we are running UD 6.0.9 on HPUX 11.11i in 32-bit (non 64-bit mode). So my question is, is UD 7.1.x only available on HPUX in 64bit versions? Thanks for advice or experiences. -- Donald Verhagen Director Of Application Development [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 --- 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] [UD] Union Query
Does anyone know how this is handled and what the syntax is in other database reporting tools? That might be a good start for an implementation on U2. I for one do not know. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Wednesday, May 16, 2007 2:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Union Query Which we were you speaking of? Just kidding, seemed like such a great sentence I could not resist. Anyway, since it already exists in Universe my guess would be that implementing multi part files would be easier, and less kludgey, than implementing some sort of file spanning, temp file generating, new query language paradigm. David Wolverton wrote: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Users of UniVerse
Give them time and they may well be stellar references for stick with U2 A lot of these get off of U2 initiatives cost a lot of money only to revert back to U2 in the end. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Monday, April 30, 2007 6:21 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Users of UniVerse Nestle Waters is in the process of converting to an SAP solution, as part of the worldwide Nestle initiative known as Globe. Also SAP-bound are: Hughes Supply/Home Depot Supply of Orlando and Ferguson Enterprises of Newport News, VA. All three of these companies have spent millions of dollars (MILLIONS) on customizing their in-house U2 software - and those systems are now destined for the scrap heap. So, those companies would probably *not* be good references for a stick with U2 campaign. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Friday, April 27, 2007 4:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Users of UniVerse Nestli Waters North America (Perrier), Greenwich, CT Sent: Friday, April 27, 2007 9:29 AM Hi, all. My sales group has a need to convince some prospects that real companies do, indeed, use UniVerse. snip Dave Liesse Quality Manager SSC Technologies, Inc. - 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/ --- 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] Differences between UV and UD
It's my understanding that the people that started VMark came from Prime and thus had a Prime Information background. Pete Simmons, one of the principle architects of UniVerse, was a software engineer at Prime Computers. I am sure they came away from Prime with more that a few tricks in their bag. They basically took the Prime Information concept and enhanced it to create UniVerse. They really didn't have the chance or the necessity to start all over and, in your terms, do it right. I'm not trying to start the hated which is better argument, just the statement that starting with a blank sheet of paper, after some years of experience with Pick/PI/PI Open, maybe some Rev and Arev, etc, is more likely to come up with a similar, but quite different product. I would also suggest that if the UniData folks were satisfied with PI/PI Open/UniVerse, they would not have gone to the trouble of creating UniData. I know from my own experience in helping to write the Prime Information System, after 5-6 years of experience with Reality, created a product that was significantly different from Reality, but still very similar. Each iteration is a step up, hopefully. In my humble or sometime not so humble opinion. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, April 30, 2007 9:48 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Differences between UV and UD I've always thought that there was a difference of philosophy from Day 1 that underlied the 2 organizations that manifests itself in the software: Vmark/UV: All things to all men, that I might by all means sell to some. (If you'll allow me to misquote St. Paul.) UniData: Do it right. They took the opportunity to recreate MV PI in their own image. (I'm continuing to bastardize the Bible.) There are pluses minuses to each approach. I am NOT arguing which is better, just that some differences in the products can be explained in terms of the respective philosophies of the organizations. Examples: 1. Conversions from other MVs: UV: inherently easier. BaskinRobbins 31 Flavours. UD: supplies conversion tools to help you, since it is more extensive. 2. UV tends to resolve ambiguities and go on, where UD tends to abort. That means you might get up and running with UV sooner, but UD aborts on bugs that need to be resolved. That can be characterized in terms of rigidity/flexibility. Those EACH have positive AND negative connotations, with respect to Software Quality Attributes, both inherent within UV UD itself, and in your ability to build quality into your ap using each environment. Consider the implications on: Correctness Dependability Learnability Efficiency Portability Robustness What is important to you would influence your preference of UV or UD. By the way, I've worked in UV much more than UD, which is fine by me. But take that as circumstance of history, more than personal bias. Chuck Stevenson --- 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] Differences between UV and UD
All of this sounds right to me. I had jumped ship by this time. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Nuckolls Sent: Monday, April 30, 2007 12:18 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Differences between UV and UD Okay, I have been sucked into this conversation: I would also suggest that if the UniData folks were satisfied with PI/PI Open/ UniVerse, they would not have gone to the trouble of creating UniData. The early versions of Unidata were poor cousins to PI/Open (imho). One of the Unidata engineers sat in our offices many years ago and said that their versions of Basic and the query language were based directly on the Prime Information manuals. ( They did not have a copy of PI in the office while they were working to emulate it.) My understanding is that Unidata had a database, and was looking for an established market that they could enter with it; they chose the MV market. Vmark (which predated Unidata by a number of years, I believe) saw an opportunity to move the MV market from Reality and Primos to Unix, which they correctly perceived as supplanting the existing proprietary minicomputers of the time. It took several years after Vmark released Universe for Prime to release their (excellent) Unix version of Prime-Information. Prime failed for familiar reasons: Their development and marketing structure was based on the high-margins of proprietary systems, and they were the target of a prolonged hostile takeover attempt, which dissuaded customers from updating their equipment and cost the company the farm. In retrospect, Unix had probably doomed them; I doubt that they could have shifted their structure fast enough to be successful with it. :-) --- 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: Spam:RE: [U2] Users of UniVerse
I understand that RR has been purchased by a much smaller firm out of Texas and the search is on, again, for a replacement for UniVerse. And the pendulum swings. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Sent: Friday, April 27, 2007 8:33 AM To: u2-users@listserver.u2ug.org Subject: Re: Spam:RE: [U2] Users of UniVerse That would be Reynolds and Reynolds software that is used by most car dealers in the US. - Original Message - From: Mark Eastwood [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, April 27, 2007 9:19 AM Subject: Spam:RE: [U2] Users of UniVerse Hundreds of Universities/Colleges (Datatel). Hundreds of Libraries (Dynex? Think name changed?). Lots of Auto Dealerships (don't remember vendor, ADP?) --- 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] Multivalue Column
My company can help. Tom Dodds InformCorp, LLC Information for Corporations [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeebkumar Sarangi Sent: Tuesday, April 17, 2007 7:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] Multivalue Column Hi, Suppose, I have a multivalue column. How can I get the sum of all the values ? If I want to create an array of the elements present in the multivalue column, then how can I do it ? Please give me some examples. Thanks, Sanjeeb =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] list files
It's not going to happen until we stop doing her job for her for free. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker Sent: Monday, April 09, 2007 2:16 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] list files Yeah, Read The Fine Manual. It's basically what I suggested to her back on the 29th. -- daw -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bobby Worley Sent: Monday, April 09, 2007 2:42 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] list files It took me a moment, but I love the RTFM acronym. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, April 09, 2007 1:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] list files It word wrapped. The last part of that url is univ_101.html BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, April 09, 2007 10:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] list files Anita, RTFM http://www-306.ibm.com/software/data/u2/pubs/library/100univ/u niv_101.ht ml BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Monday, April 09, 2007 9:50 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] list files I do this at the OS level... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anita Panda Sent: Monday, April 09, 2007 10:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] list files Hi, I have connected on to a remote Universe instance.I want to see all the files and tables in that instance .What is the command to see all the main programs ,subroutines and tables. Thanks, Anita =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Spam:[U2] FILE EXPORT
I agree. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Sent: Friday, March 30, 2007 9:27 AM To: u2-users@listserver.u2ug.org Subject: Re: Spam:[U2] FILE EXPORT This is ridiculous. I would advise everyone to not answer any more of this persons questions. If the companies involved are not willing to invest in a connection between to two systems or provide a means of getting the files to the other system then there are two reasons. Either they are too cheap to do it, or, this is the reason to stop answering questions, this may be software piracy. In the latter we, by helping this individual, would be aiding and abetting. If it is the former then they shouldn't even be in business. - Original Message - From: Anita Panda [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, March 30, 2007 12:27 AM Subject: Spam:[U2] FILE EXPORT I think I was not clear in my question.Now i need to activities to be done. firstly,I have a universe instance on a different Machine located at USA and the other in INDIA. Both of them are stand-alone system.I by no means ,am able to get the data from the UNIVERSE USA to my UNIVERSE INDIA.No what I need is if there is any way of the user in USA can send me the DATA file from USA to INDIA so that the same DATA file could exist in INDIA without again creating the same file and inserting data.Is there any means without floppy,CD and magnetic tape.Please help me in this regard. I have got a huge BP file on a word document.Now its not feasible to type the whole file in the Universe Instance .Is there any way without typing the code to import the whole BP file into the Universe Instance. Thanks, Anita =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] FILE EXPORT
It sounds to me like we have someone converting a UniVerse application to Oracle. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anita Panda Sent: Friday, March 30, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FILE EXPORT ya you got it right .I had worked prevoiusly in ORACLE , there to just get the table contents from one standalone instance to another stanalone instance what we do is create a script with create table and insert into table commands and send it through mail .The other person just runs the script and he/she gets table and its contents within the schema. Same way in Universe how do I copy the contents of a file from one instance to another.What are the files necessary to get the whole data of the files. The OS is Windows XP Thanks, Anita Allen Egerton [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/30/2007 05:31 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2] FILE EXPORT Anita Panda wrote: I think I was not clear in my question.Now i need to activities to be done. firstly,I have a universe instance on a different Machine located at USA and the other in INDIA. Both of them are stand-alone system.I by no means ,am able to get the data from the UNIVERSE USA to my UNIVERSE INDIA.No what I need is if there is any way of the user in USA can send me the DATA file from USA to INDIA so that the same DATA file could exist in INDIA without again creating the same file and inserting data.Is there any means without floppy,CD and magnetic tape.Please help me in this regard. Set up an FTP site on the internet. I have got a huge BP file on a word document.Now its not feasible to type the whole file in the Universe Instance .Is there any way without typing the code to import the whole BP file into the Universe Instance. Open it in word. File; Save As xyz.txt in the BP directory change the file name I've been reading your questions, and I have a question of my own. Where is your area of expertise? It quite evidently isn't Universe, but it appears that it's not in general systems either. So, what can I use to draw analogies? -- Allen Egerton [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ForwardSourceID:NT0001531A =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- 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] Digests
Thanks for looking into to this. I was not aware that someone else had already reported the condition. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: Wednesday, March 14, 2007 1:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Digests Tom Jan, Tom Pellitieri just raised this with us earlier today. It appears that the threshold for how big a digest can get before it is sent is set at too low a level. Larry Hiscock, who donates the server, bandwidth, and his time, will be looking into it with me. - Charles Barouch, Moderator Tom Dodds wrote: Is there a reason why we are getting digests containing only one posting? I.E 1549, 1550, 1551, 1552. 1547 had two postings and 1546 had 5 postings. Thanks Tom --- 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] catalog command
You do realize that you need to compile the subroutine before you can catalog it. BASIC BP SUB This will create the BP.O file if it does not already exist. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Wednesday, March 07, 2007 8:09 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] catalog command Almost certainly this is related to permissions on the account directory. Either you can not create a BP.O subdirectory (lacking write permission to the account directory) or a file called SUB within BP.O (lacking write permission to the BP.O subdirectory). Or, a slight chance, your disk is full. - Original Message - From: Anita Panda [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] catalog command Date: Wed, 7 Mar 2007 18:26:07 +0530 Hi I have created one BP file containing the main procedure (say Main)and another BP file which contains the subroutine (say SUB). I tried cataloging the subroutine but couldnot it raised the following error Unable to open BP.O/SUB for cataloging.Also I want to view all the cataloged files. Can anyone help me in this regard. Thanks Anita --- 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] Lists are back online
No doubles for me either Tom Dodds InformCorp, LLC Information for Corporations [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, March 02, 2007 10:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Lists are back online Is anyone else getting the messages from this list doubled? I'm not sure if it's the list or something afterwards. BobW --- 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] anonymous ftp commands
The touch command is in /usr/bin on AIX so everyone should have access to the touch command. My guess is the person does not have write privileges to the directory or the file you want them to touch and you will have the same problem with ftp. If ./myfile already exists check the access privileges on that file. Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 27, 2007 3:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] anonymous ftp commands I guess ftp'ing the same zero byte file would accomplish the same thing eh? -- Original message -- From: [EMAIL PROTECTED] Hi all, There is an external application that sends data to our system via ftp that I want to monitor. I would like for this user to execute a unix touch on a file in their home directory using the ftp quote command (quote SH -C touch ./myfile). This would tell me that their server is up even though there is no data to send. The problem is (i am guessing) that they do not have authority to the touch command. I thought I could copy the touch command into the users home directory to get it to work but it did not. I looked at a file called /etc/ftpd/ftpaccess but nothing jumped out at me in there. Can anyone tell me if what I am trying to do is feasible and if so what I am doing wrong? Thanks
RE: [U2] [UV] SPOOLER
You might take a look a sudo. It is freeware that allow non super users to act like super users sometimes. It can be a little fun to setup, but it works great. hth Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Rogen Sent: Thursday, January 25, 2007 9:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] SPOOLER We are in the processing of setting up a new system that we will be migrating to. It will be running 10.2 on HPUX 11.23. We are planning to stop using our network print server and spool through Unix directly to the IP address. Here is the challenge. Joe produces a quite sizable job to the printer. So, the UniVerse spooler processes the job and hands it off to the Unix spooler. At this point, the job is no longer visible to the UniVerse spooler. Since 'usd' is running with superuser level, the Unix print file gets created with the same security level. Joe decides to cancel the print job. He can not execute SPOOL -CANCEL because UniVerse is no longer cognizant of the file. He cant 'cancel' the job, because he does not have security level. Question: How to create a print job from UniVerse, so that the Unix print file will have an ownership/security that will allow Joe to cancel his own print job. Note: If you press the cancel button on printer, Unix seems to say 'oh, something happened to the printing, let me start over and print it again' Thoughts, ideas, comments, criticisms. 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.t. roosevelt [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- 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] U2 and Open Insight.
Go to the url below and take look at the press release for Revelation Software and IBM U2. Looks like a new, fully GUI front end to U2. Westwood, NJ - 8 January 2007: Revelation Software today introduced OpenInsight for IBM U2 and announced that under an agreement with IBM, Revelation Software will market and sell the IBM UniVerse and UniData Servers as part of its OpenInsight offering. http://www.revelation.com/Revelation.nsf/28eaa3bb5371386d85256dd6001f2c87/66 d0d9ce0920e2c38525725d0056f792?OpenDocument Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] cODE39
I have a program that is reading the table listed below )code339) and printing code39 bar codes from these entries. It takes the SEQ of the character to be printed, extracts the data from the corresponding field of this table and the print a series of ESC characters and the result is a bar code. What I need is to fill in the upper case alpha characters. This table only has a *, 0-9 and B,C characters. Has anyone ever seen the code39 table below and do you have the upper case characters for that table? Thanks in advance for your help. TXT='*':TXT:'*' ; DC=LEN(TXT) FOR CC=1 TO DC N=SEQ(TXT[CC,1]) BNBR=CODE39N ; COLOR=1 FOR C=1 TO 10 WIDTH=FIELD(CODE39.WIDTHS,',',BNBR[C,1]) ; COLOR=NOT(COLOR) PRINT ESC:'*c180B': ; * height PRINT ESC:'*c':WIDTH:'A':; * width PRINT ESC:'*c':COLOR:'P':; * fill PRINT ESC:'*p+':WIDTH:'X': ; * move NEXT C NEXT CC RETURN This is code39 variable. 0042: 1211212111 : P35 0042: 1211212111 0043: 0044: 0045: 0046: 0047: 0048: 1112212111 0049: 211221 0050: 112221 0051: 212211 0052: 1112211121 0053: 211221 0054: 112221 0055: 1112112121 0056: 2112112111 0057: 1122112111 0058: 0059: 0060: 0061: 0062: 0063: 0064: 0065: 0066: 1121121121 0067: 212112 0068: 0069: 0070: 0071: 0072: 0073: 0074: 0075: 211221 Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Mac telnet
Thanks to everyone that responded. It seems that MacWise is the choice. Thanks again. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, December 01, 2006 11:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Mac telnet It seems to me that any telnet client that's available in the Mac environment should do the trick. I guess the only real concern would be the terminal emulation options you have in any given client package. VT100/ADDS/etc... As far as Universe is concerned, it doesn't care if it's a PC pretending to be a terminal or a Mac pretending to be a terminal. Just as long as it pretends convincingly to be a terminal. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Friday, December 01, 2006 6:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Mac telnet Which telnet client should be used to connect a Mac to UniVerse? Any insight would be helpful. Thanks Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- 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/
[U2] Mac telnet
Which telnet client should be used to connect a Mac to UniVerse? Any insight would be helpful. Thanks Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Program Mgmt System
PRC from Susan Joslyn at SJPlus. I have used it, installed it and it is easy to work with, as is Susan. It really works. (954) 796-9868 [EMAIL PROTECTED] http://www.sjplus.com Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Rogen Sent: Friday, December 01, 2006 8:03 AM To: u2-users@listserver.u2ug.org Subject: [U2] Program Mgmt System To all, We are in process of getting new systems here, which will be allowing us to segregate the programming people from the live system In this light, we will actually be setting up a form testing to implementation environment. Question: Does anybody know of a good 'software management' program out there that will allow us to manage program version control, implementation process, auditing capabilities, etc, etc.Any suggestions will be much appreciated. 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.t. roosevelt 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. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers
Yes Triggers work well. You can find the docs in Chapter 5 of the SQL reference manual within UV Docs SQLREF.PDF I have a set of pretty simple set trigger programs that I would share. They are too big to send outside of an attachment. So I will send them to you direct. HTH Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, November 28, 2006 11:46 AM To: u2-users Subject: [U2] Triggers Hi all!! Someone know if exists triggers in Universe?? Thanks all!! Pulse para ir al sitio web JesC:s Barbero RodrC-guez Departamento de AnC!lisis y ProgramaciC3n - Desarrollo tecnolC3gico Zoco Gran Santander, 1B* Planta b 39011 PeC1acastillo b Santander b ESPACA Tel.: +34 902 233 323 b Fax: +34 902 234 280 AVISO LEGAL: Este mensaje contiene informaciC3n destinada exclusivamente al usuario de destino, pudiendo contener informaciC3n confidencial o protegida legalmente. Si, por un error de envC-o o transmisiC3n, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningC:n medio . Cualquier opiniC3n en C)l contenida, es exclusiva de su autor y no representa necesariamente la opiniC3n de Quiter Servicios InformC!ticos, S.L. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the authorE=s own and do not necessarily reflect those of Quiter Servicios InformC!ticos, S.L. --- 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] Phantom Limits
Brian: Is there a limit to iPhantoms? Is the limit a system wide limit? Is the limit tunable? I have 10.1.11 i386 UV license with 41 users and over the weekend I had 218 phantoms and one real user active. It stopped at 218 phantoms, because I ran out of memory to load another process. Several years ago at another client I ran into a limit while I was doing a stress test and had to start multiple host sessions to spawn more the approximately 50 phantoms. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Monday, November 27, 2006 11:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Phantom Limits Stu Phantoms on uv do not consume a regular licence. However, certain functions - notably those that are socket related - will cause a phantom to consume an 'iPhantom' licence. This was to prevent unscrupulous sites circumventing the normal licencing by purchasing a small number of users and having a load of phantoms act as listeners for interactive processing. That's not the case for all MultiValue databases however. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: 27 November 2006 15:54 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Phantom Limits I was under the impression that the number of phantoms is limited to the licensed number of users less the number of users on the system. In other words, each phantom used a license. Am I out incorrect? --- 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] Phantom Limits
In my experience, which is at UV 10.0.x some years back, the limit is not system wide, but was imposed at the host process level. The limit I found was 50 phantoms per host process so if you needed to have more than 50 phantoms running you needed to start multiple host process to spawn a set number of processes. I was never able to find a tunable parameter to modify the limit. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Veenhof Sent: Thursday, November 23, 2006 1:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Phantom Limits Hi, I'm just reading up on phantoms, and saw this little note in the HELP... There is a system-wide limit on the number of processes that you can initiate. If you can start no more processes when you issue a PHANTOM command, the following message appears: NO FREE PHANTOMS You cannot run a phantom process now. Wait a while, then try again. I was wondering if anyone knows off the top of their head, what determines this limit? Is it a static number, if so what, or is it user definable? Thanks Peter --- 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] Question about EQU
The way I understand this thing is that when you use a simple variable (A= 16) what is stored in the object code is an offset value into the descriptor table where the value of A is stored. If you use an EQU A to 16 then what is stored in the object code is 16. When the program is executed the interpreter does not have to look the value of A up in the descriptor table because the value is right in the object code and thus the program executes faster. That's what I was taught, long, long ago. :-) Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Saturday, November 18, 2006 1:06 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Question about EQU David, I am interested in your opinions as to why, given that equates are compile time constructs, would have any impact at all on execution speed. Understand, I am not contesting your premise, but rather would simply like more explanation to understand your perspective. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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] Why does the IF statement think these values are different?
I would remove the 'R2' from the err display so you can see the complete values. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ferries Sent: Monday, November 06, 2006 9:14 AM To: u2-users@listserver.u2ug.org Subject: [U2] Why does the IF statement think these values are different? HI All, I don't understand why the IF statement THEN clause is executed in the following code: CUSTOMCALC: 447: IF INTREC+PRNREC#INTPAY+PRNPAY THEN :: S CUSTOMCALC: 448: ERRMSG='ACCT/CALCULATOR MISMATCH: ':(INTREC+PRNREC)'R2':'/':(INTPAY+PRNPAY)'R2' :: INTREC/ NUMBER: 24016.35 :: PRNREC/ NUMBER: 978.56 :: INTPAY/ NUMBER: 24016.35 :: PRNPAY/ NUMBER: 978.56 :: ERRMSG/ STRING: T r L=42 `ACCT/CALCULATOR MISMATCH: 24994.91/24994.91' To my tired eyes, they are equal and we should not take the THEN. What am I missing here? Thanks for your help! Steve Steve Ferries Vice President, Information Technologies Total Credit Recovery Limited 416 774 4250 [EMAIL PROTECTED] Note: This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier ilectronique est confidentiel et protigi. L'expiditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) disigni(s) est interdite. Si vous recevez ce courrier ilectronique par erreur, veuillez m'en aviser immidiatement, par retour de courrier ilectronique ou par un autre moyen. --- 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] What Flavor UV ?
There is a SYSTEM() cell that will tell you. Do a HELP BASIC SYSTEM() and look for flavor and the write a Basic program to CRT SYSTEM(X). hth Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, October 26, 2006 1:15 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] What Flavor UV ? How do I determine what UniVerse flavor is running, on an old HP-UX machine? --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron White Sent: Thursday, October 26, 2006 12:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New Account Setup - Copy VOC ? Brutzman, Bill wrote: In UniVerse 10.1, I can setup a new account with the Admin tool. Upon entering the command ED VOC LOGIN I obtain Verb ED is not in your account. Should I copy the VOC file from our main account to this new account? VOC in our main account is rather large, 1.3-MB. VOC in the new account is tiny, 40-KB. There is plenty of disk space. I am surprised that ED functionality is not there on the new account. Suggestions would be appreciated. --Bill I have never heard of this happening. I would use UniAdmin to delete the account and recreate it. Check that the flavor and account path are correct. I am on M$ platform but it should work the same on *nix. Ron White --- 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] [OT] - Texas Sales Tax
We interfaced to the Vertex package at a client in Tulsa, OK. The contact name was/is: Matt Dailey Account Executive, Tax Technology Vertex Inc. Where Taxation Meets Innovation T: 972.385.7409 F: 972.385.7219 M:972.567.5684 [EMAIL PROTECTED] Or Maybe Alice Carter Senior Training Coordinator Vertex Inc. Where Taxation Meets Innovation 1041 Old Cassatt Road Berwyn, PA 19312 Phone: 484.595.6224 Fax: 610.640.2761 [EMAIL PROTECTED] Website: www.vertexinc.com HTH Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard A. Wilson Sent: Thursday, October 26, 2006 3:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] - Texas Sales Tax you may want to talk to ROI, I believe they support the Vertex tax software www.roisyn.com Rich Caminiti, Marc wrote: This is totally off topic and apologize for this. Starting in January of next year, we will be collecting sales tax for packages that we ship to Texas and was wondering if someone would be willing to share (off-topic would be fine) on how they figure out the correct tax for each city code. Unfortunately we cannot go by zip code and I was wondering what other people have done. Reason for that, in their PDF, they use the example of Kingwood, Texas (which we have 4 zip codes for) states that the tax collected should go to City of Houston and the Houston MTA, not to Kingwood. Outside of that explaination, I cannot find any other cross reference between the 2, to try to create some logic out of it. Thanks in advance Marc Marc Caminiti Nashbar Direct, Inc IS Manager Bike Nashbar 330.533.1989, ext 336 6103 State Route 446 330.702.9733, fax Canfield, OH 44406 [EMAIL PROTECTED] http://www.nashbar.com Computers make very fast, very accurate mistakes. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.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/
[U2] UV/SB+
I have a client that wants to upgrade from SB+ 4.4.3 to SB+ 5.4.x. Does anyone know of any problems that may arise from this upgrade? They will be running AIX 5.3.3 and UV 10.1.22 on IBM P505 hardware. TIA Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sort / Select keyword
I had not thought of the index, but it does show up in the EXPLAIN data. .X 01 LIST SA SLSMLINELOCCAT.IDX WITH SLSMLINELOCCAT.IDX = [KK] AND WITH CUSTLINELOCCAT.IDX = [LL] EXPLAIN Single-variable predicates processed in index: F0 MATCHES '...'KK'...' AND F0 MATCHES '...'LL'...' Optimizing query block 0 Driver source: SA Access method: select list 0 with 0 ids UniVerse/SQL: Press any key to continue or 'Q' to quit Obviously a PICK flavor UniVerse 10.1.11, AIX 5.3.2 Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Laura Hirsh Sent: Friday, October 13, 2006 2:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort / Select keyword Interesting. I was just thinking that something similar would be useful - especially when using indexes and being able to tell if an index is being used or not. Anyone know of anything similar in Unidata? Thanks, Laura -Original Message- From: Tom Dodds [EMAIL PROTECTED] Sent: Oct 13, 2006 12:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort / Select keyword This is what I got using EXPLAIN on UV 10.1.11 under AIX 5.3 LIST P/O ORDER CUST P/O-DATE BY CUST WITH CUST 1 EXPLAIN Optimizing query block 0 Tuple restriction: F3 '1' Driver source: P/O Access method: file scan Sorted by: CUST UniVerse/SQL: Press any key to continue or 'Q' to quit --- 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] Sort / Select keyword
This is what I got using EXPLAIN on UV 10.1.11 under AIX 5.3 LIST P/O ORDER CUST P/O-DATE BY CUST WITH CUST 1 EXPLAIN Optimizing query block 0 Tuple restriction: F3 '1' Driver source: P/O Access method: file scan Sorted by: CUST UniVerse/SQL: Press any key to continue or 'Q' to quit Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Verhagen Sent: Friday, October 13, 2006 11:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sort / Select keyword John, I think the keyword is EXPLAIN. I don't have a copy of Universe nearby. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 10/13/2006 at 10:02 am, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: I seem to recall that there is a keyword / option / modifier which will display more details about the internals of a select statement. Am I hallucinating again or is there really such an animal ? We are on UniVerse 9.6.1 Cheers John Rodgers --- 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] PORT.STATUS bug?
I disagree. Port Status is a good option for determining what the state of a process is if you are on the proper release of the database. We are working on uv 10.1.11 and are not having any problems with PORT.STATUS. You can only have one user in PORT.STATUS at a time, but it works just fine in our environment. (aix 5/2/2UV 10.1.11) Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 5:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] PORT.STATUS bug? So if port.status is not a good option for determining what state a process is in, what do people turn to? -- Original message -- From: Stevenson, Charles [EMAIL PROTECTED] I saw something similar with telnet sessions, not phantoms a few years ago. Also HP, but UV 9.6.2.6, HPUX 11, August 2002. I hit it with PORT.STATUS...LAYER.STACK but I don't think I've hit it anywhere else. At least I've never pinned it. It happened when I was trying to collect stats on what we spent our time on. I ran a job that repeatedly executed PORT.STATUS LAYER.STACK (consistent with what Asvin says) and telnet sessions began hanging right left. It was only when I used the LAYER.STACK option and I never saw a problem with phantoms, although several were running, only telnet. I did not see the :nanosleep: Interrupted system call error message. 10.1.14 release notes says: Issue 7659 If one UniVerse process was executing a SELECT statement against a file, and a different UniVerse process was executing the PORT.STATUS command, the process selecting the file may have received an error message similar to the following: nanosleep: Interrupted system call This problem was unique to the HP platform and has been fixed. There are 4 other notes that mention PORT.STATUS. I did not recognize 7659 as my issue, but reading both of your posts, it looks like maybe it is. I am at UV 10.0.16 at present. Chuck Stevenson From: [EMAIL PROTECTED] this is a known issue in some versions of Universe. It is fixed at one of the 10.1.nnn releases - not sure which. From our experience, it seems to only occur when you have a program that is sleeping, and you run PORT.STATUS more than once without any appreciable gap in between. Sent by:[EMAIL PROTECTED] HPUX 11 UV10.1.8 Has anyone had any problems with PORT.STATUS causing phantom jobs to hang? We have background jobs that, every once in a while, will hang. When looking at the output from PORT.STATUS the last command is always some simple EXECUTE. For example, the batch job EXECUTES a SH -C ls ./dir/whatever* and, seemingly, fails to return. I did see the following in the PH record :nanosleep: Interrupted system call How does PORT.STATUS work internally anywho? Thanks, Scott --- 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] Triggers
Unfortunately this is the best documentation that I have seen. I received it from David Scoggins via U2_Digest group who got if from Bryan Thorell. I have written several more routines using this as a basis that I could email to you if you like. The list won't accept attachments. Let me know and I will send them to you TRIGGER * The routine called by the trigger process. SUBROUTINE TRIGGER(TRIGGER.NAME, TRIGGER.SCHEMA, TRIGGER.FILE, TRIGGER.EVENT , TRIGGER.TIME, TRIGGER.NEWID, TRIGGER.NEWREC, TRIGGER.OLDID, TRIGGER.OLDREC, T RIGGER.ASSOC, TRIGGER.AEVENT, TRIGGER.COUNT, TRIGGER.CHAIN, TRIGGER.CASCADE) ** WARNING** * This routine must be cataloged globally not locally. * This is accomplished by using the I.CATALOG verb. This verb is present * in both the AAON accounts and in the ON.TEST accounts or it may be * created by coping the CATALOG verb from the voc of the UV account into * the voc of any account changing is's name to I.CATALOG. * Do NOT overwrite the CATALOG verb in the to acount or BAD things will happen * It's syntax is * I.CATALOG -PGM-MODS * .TRIGGER .TRIGGER * It is the * .TRIGGER that makes is globally cataloed. A globally * cataloged program does not need an entry in the VOC file. *** * Generic trigger to log updates to files * 08/23/04 gds - created, from an example by Bryan Thorell * 08/14/04 ttd - received from David Scoggins via U2_Digest group * * Usage notes: * Triggers must be globally cataloged. * Use ICATALOG verb - ICATALOG SRC.BP CDB.T in the RIS account * * To activate the trigger on a file: * CREATE TRIGGER triggername AFTER INSERT OR UPDATE OR DELETE ON filename * FOR EACH ROW CALLING 'CDB.T' * * To deactivate the trigger on a file: * DROP TRIGGER filename triggername * DROP TRIGGER filename ALL - drops all triggers on filename * * Parameter list: * TRIGGER.NAME:name of the trigger * TRIGGER.SCHEMA: name of schema (account) trigger is called from * TRIGGER.FILE:name of file trigger is called on * TRIGGER.EVENT: INSERT, UPDATE or DELETE * TRIGGER.TIME:BEFORE or AFTER * TRIGGER.NEWID: new record ID if event is INSERT or UPDATE * TRIGGER.NEWREC: new record if event is INSERT or UPDATE * TRIGGER.OLDID: old record ID if event is UPDATE or DELETE * TRIGGER.OLDREC: old record if event is UPDATE or DELETE * TRIGGER.ASSOC: name of dynamically normalized association * TRIGGER.AEVENT: event (INSERT, UPDATE or DELETE) on association * TRIGGER.COUNT: number of triggers currently firing * TRIGGER.CHAIN: number of active triggers since last cascade * TRIGGER.CASCADE: cascaded event (UPDATE or DELETE) firing the trigger * EQU DELIM TO '_' * * CRT 'EVENT ':TRIGGER.EVENT * * Create the Log Record R.TRANS = '' ; K.TRANS = '' R.TRANS1,1 = DATE() R.TRANS1,2 = TIME() R.TRANS1,3 = TRIGGER.EVENT R.TRANS1,4 = @LOGNAME R.TRANS1,5 = @USER.NO R.TRANS1,6 = @PATH * * Write the Log Record BEGIN CASE CASE TRIGGER.EVENT EQ 'UPDATE' K.TRANS = TRIGGER.FILE:DELIM:TRIGGER.OLDID:DELIM:R.TRANS K.TRANS2 = TRIGGER.NEWREC:'~' CASE TRIGGER.EVENT EQ 'INSERT' K.TRANS = TRIGGER.FILE:DELIM:TRIGGER.OLDID:DELIM:R.TRANS K.TRANS2 = TRIGGER.NEWREC:'~' CASE TRIGGER.EVENT EQ 'DELETE' K.TRANS = TRIGGER.FILE:DELIM:TRIGGER.OLDID:DELIM:R.TRANS:'~' END CASE * CRT 'READY TO WRITE ':R.TRANS * CALL *XML.PARSE(K.TRANS,ERR.REC,FLAG) IF FLAG THEN CRT 'An error was received from the XML.PARSE routine ' CRT ERR.REC END * FINALLY: * RETURN END * Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pamela J Robbins Sent: Tuesday, October 03, 2006 9:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers Does anyone know where I might find good documentation on triggers? I haven't worked with them before and the UniVerse manuals don't have much documentation. -- Pamela J Robbins University of Pennsylvania Sr Programmer/Analyst School of Veterinary Medicine mailto: [EMAIL PROTECTED] New Bolton Center 610-444-5800 610-925-6438 Computer help, ext HELP (4357) --- 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] Command that is the opposite of MATPARSE.
You have to DO MAT B = MAT A after you have dim'ed B, but then the CRT B won't work because it is an array. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, October 03, 2006 1:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Command that is the opposite of MATPARSE. Dave: Really? I tried the following on UniData v7.1: 3 Demo (0)- BPTEST DIM A(5) ; A(1) = A ; A(2) = B ; A(3) = C ; A(4) = D ; A(5) = E ; B = A ; CRT B ; END Compiling Unibasic: SAVEDLISTS\BpTest_407195971 in mode 'p'. redefined variable A near line 7 compilation failed In E:\DataTrust\DTA\BP\BP\_BPTEST at line 101 can not find object/catalog file: 'SAVEDLISTS\_BpTest_407195971'. ...but on D3 I get: 31 Demo (0)- BPTEST DIM A(5) ; A(1) = A ; A(2) = B ; A(3) = C ; A(4) = D ; A(5) = E ; B = A ; CRT B ; END BpTest*407628781 . [241] Successful compile! 1 frame(s) used. A^B^C^D^E Am I missing something here? Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker Sent: Tuesday, October 03, 2006 5:39 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Command that is the opposite of MATPARSE. They work in Unidata... -- Dave Walker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Monday, October 02, 2006 8:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Command that is the opposite of MATPARSE. Mark: I don't believe this works in the U2 products. All those little niceties of D3 are not considered essential in U2. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, October 02, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that is the opposite of MATPARSE. I don't know if this would work on U2 but as I was trying to remember this for D3, I simply equated them as such: DIM A(100) MATREAD A FROM FILE, ID ELSE STOP B=A PRINT A(49), B49 My .001 cents. Mark Johnson - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, October 02, 2006 6:53 PM Subject: RE: [U2] Command that is the opposite of MATPARSE. Just curious - Does anyone know if there is a command/function that will do just the opposite (of MATPARSE)? MATBUILD -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.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/ --- 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] Command that is the opposite of MATPARSE.
Your right I missed the point. You can't do that in UV that I know of. They could do that in UltPls and it gave us fits during a conversion from UltPls to UV. Thanks Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, October 03, 2006 3:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Command that is the opposite of MATPARSE. Tom: I think the point Mark was making is you can do: DIM A(5) A(1) = A A(2) = B A(3) = C A(4) = D A(5) = E B = A ...and now B is a dynamic array while A is a dimensioned array. You can assign one from another without ever using MATPARSE or MATBUILD. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Tuesday, October 03, 2006 12:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Command that is the opposite of MATPARSE. You have to DO MAT B = MAT A after you have dim'ed B, but then the CRT B won't work because it is an array. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, October 03, 2006 1:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Command that is the opposite of MATPARSE. Dave: Really? I tried the following on UniData v7.1: 3 Demo (0)- BPTEST DIM A(5) ; A(1) = A ; A(2) = B ; A(3) = C ; A(4) = D ; A(5) = E ; B = A ; CRT B ; END Compiling Unibasic: SAVEDLISTS\BpTest_407195971 in mode 'p'. redefined variable A near line 7 compilation failed In E:\DataTrust\DTA\BP\BP\_BPTEST at line 101 can not find object/catalog file: 'SAVEDLISTS\_BpTest_407195971'. ...but on D3 I get: 31 Demo (0)- BPTEST DIM A(5) ; A(1) = A ; A(2) = B ; A(3) = C ; A(4) = D ; A(5) = E ; B = A ; CRT B ; END BpTest*407628781 . [241] Successful compile! 1 frame(s) used. A^B^C^D^E Am I missing something here? Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker Sent: Tuesday, October 03, 2006 5:39 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Command that is the opposite of MATPARSE. They work in Unidata... -- Dave Walker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Monday, October 02, 2006 8:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Command that is the opposite of MATPARSE. Mark: I don't believe this works in the U2 products. All those little niceties of D3 are not considered essential in U2. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, October 02, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that is the opposite of MATPARSE. I don't know if this would work on U2 but as I was trying to remember this for D3, I simply equated them as such: DIM A(100) MATREAD A FROM FILE, ID ELSE STOP B=A PRINT A(49), B49 My .001 cents. Mark Johnson - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, October 02, 2006 6:53 PM Subject: RE: [U2] Command that is the opposite of MATPARSE. Just curious - Does anyone know if there is a command/function that will do just the opposite (of MATPARSE)? MATBUILD -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.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/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] - AREV
Tony: Here is a response from the folks at Revelation. HTH From: Robert Catalano [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 5:27 AM To: Tom Dodds Subject: RE: [U2] [OT] - AREV Hi Tom, Please see Bill's response below. Tony can always post a question on our discussion forums at: http://www.revelation.com/Revelation.nsf/byTitle/Registration+Entry?OpenDocu ment Regards, Bob Bob - The key is, as Tony notes, to make sure that whatever he buys does indeed support expanded memory. A check with the manufacturer with either get him a straight answer either way or a What's Expanded Memory? from first line tech support (probably before their time). As for settings, below is a link to the Arev FAQ which shows a Windows 95 PIF (shortcut) that's basically the same as in XP. http://www.revelation.com/knowledge.nsf/6172b55c0754651c852566f500659145/3c5 7c588ce21daf9852563920051f70b?OpenDocument Hope that helps. Bill Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Caufield Sent: Monday, September 25, 2006 2:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] [OT] - AREV I know this is a universe/unidata list but I know many of you still use Arev. I wondering if anyone that is using AREV has purchased a laptop recently that they are using it on. I know I need expanded memory (old dos stuff) and I know before getting the cheapo systems did not allow you to access it because windows wants to. So any help would be great. Thanks, Tony Caufield IS Manager Harbor Wholesale Grocery Inc. --- 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][UD] UniQuery SELECT WITH Limits
You might consider doing it in a subroutine if you don't have to run it too often and you are selecting a high percentage of the database. Do it with field name = 1 and then have the subroutine do the withing and set the return value to 1 so your just test of a 1. Set up an array in the subroutine to hold the 250 numbers and then just locate in that array. If the numbers truly are random then you could generate the numbers in the subroutine as well or read them from an external source. hth Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jjuser ud2 Sent: Monday, September 25, 2006 12:22 PM To: u2-users@listserver.u2ug.org Subject: [U2][UD] UniQuery SELECT WITH Limits Hi hello how are ya :) Limits. The documentation I have for Using UniQuery says that you can only have 120 different with fields in a SELECT statement. I'm trying to select a series of non-contiguous numbers at random intervals to generate a select list. There are 251 of these numbers. Do I have to split the list into three different groups in order to generate three different lists that I can do a SAVE.LIST on? What's the best way to go about getting these select lists? Thanks! :) --- 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] IDC White Paper on U2
The complete URL is listed below. http://www-306.ibm.com/software/data/u2/pubs/whitepapers.html Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Tuesday, September 12, 2006 8:24 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] IDC White Paper on U2 Now we have a document that has U2 recognised by industry analysts. Something that can be given to the CEO, CFO, CIO justifying that U2 is the right choice. Make sure to read the IDC white paper, Because Not All Data is Flat: IBM's U2 Extended Relational DBMSs. The IDC white paper compares the strengths of the extended relational approach with the more commonly used relational approach and highlights the advantages of the extended relational approach in terms of development, performance and maintenance of the data server. It includes an overview of IBM UniData and UniVerse, their suitability for use in embedding in vertical applications and how these data servers are meeting the needs of today's development challenges. You will find the paper posted under the Highlights section on the right-hand side of the U2 home page: http://www.ibm.com/software/data/u2 Regards David Jordan Managing Consultant www.dacono.com.au --- 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] rsync query
Wait until the next time you do it. The real time is made up on the subsequent saves. I hope this is not the one that was going to do the rcp every 10 minutes. Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Frost Sent: Monday, September 11, 2006 4:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] rsync query Hi -- I ran our first complete rsync job over the weekend and what normally took 30 hours with rcp reduced to 7 hours for 40 GB.I'm impressed. # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- 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] D Debugger
I have noticed that if you happen to be EXECUTEing a TCL command when you depress the break key it will not give you the D option because you can not debug a non-basic process. Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Thursday, September 07, 2006 3:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] D Debugger I'm not getting the D Option when entering a control-break while running basic programs. Just guessing, but does the program have to be compiled with -D or -Z option? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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/