[U2] Testing a new address Please ignore.
Testing a new email address. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
Have you tried to old 'ED' editor? Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Tuesday, April 08, 2008 8:37 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Keys with @AM in them... LOL - I don't have the keys -- it was a one-off piece of code. But I'll write a program -- I was trying to do a 'select' and use AE to remove the keys -- but that just will not work... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Monday, April 07, 2008 3:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Keys with @AM in them... uh, write the same program to construct the keys and delete them? There are notes about finding these actual keys (to use in your fix program) in one of my various UniData troubleshooting presentations - from U2U, at least. In the context of 'duplicate keys'. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] David Wolverton [EMAIL PROTECTED] et To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Keys with @AM in them... 04/07/2008 01:15 PM Please respond to [EMAIL PROTECTED] er.u2ug.org How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- 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 image/jpeg which had a name of 09407543.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic29301.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- 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] version control
It seems that everyone needs to be a specialist these days, even in our business. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, April 17, 2008 4:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] version control David You might want to check out an article I wrote for Spectrum about this. Back-issues are on www.intl-spectrum.com. One other tip: We used CVS at my last company, which was quite a complex arrangement handling server and client side code (and keeping these in sync). The key was to appoint someone who was responsible for it. If it is anything more than trivial, it needs someone charged to administer it, not just left to the whims of developers! That was the best decision we made... Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Beahm Sent: 16 April 2008 21:22 To: u2-users@listserver.u2ug.org Subject: [U2] version control We are looking to add our UniData/SBClient environment to Subversion, and wanted to get advice from anyone who has done s something similar (CVS, etc.) Searching through past posts, I found Brian Leach's note about generating DICT items from scripts, which I quite like; I suspect there are more ideas like that around. First, however, we need to come up with a suitable repository structure. We have a number of live, proto, and development accounts on one box (HP-UX). We have some universally shared directory files, but most files are unique to each account. To begin with, we are wondering whether it would be best to have individual repositories for each account, or whether there should be one repository with relative paths for each account, or whether each account should be a different branch, etc. Suggestions welcome, however we are want to standardize on one solution -- Subversion. Thanks, David Beahm --- 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] Unidata @LOGNAME
If I remember correctly, Solaris only looks at the first 8 characters as the user name and the password. If you have a password longer than 8 characters you're wasting keystrokes. I don't know if there is a setting to change it. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jeffrey Butera Sent: Thursday, April 17, 2008 8:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata @LOGNAME Under Unidata 7.1.x on Solaris (9/10) we're seeing @LOGNAME truncated to 8 characters. Others on different OSes are not seeing this behavior. Does anyone know if this is a Unidata setting or how Unidata is interacting with a system call (eg: and therefor cannot be changed)? -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Consultants don't necessarily know more than you, they just get paid more than you. Me --- 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 Training
You could try looking here: http://jes.com/picklist.html Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, April 21, 2008 9:05 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata Training Does anyone have an idea how I could get my hands onto a copy of the book mentioned below? I've been searching around and I cannot seem to hit upon the right place/web site. It's been out of print so long that it appears as if you can't buy it anymore...has anyone else found that to be the case? Same here. Amazon lists it, but as not available. Not even used. Pick Basic: A Programmer's Guide by Jon Sisk is not available either. I would like to acquire a copy myself. Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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 have disappeared
As far as I know it's always worked that way. Question, the copies you made before, were they on the same system? If so you were using the same indices for both your live and copied data. Usually this causes some strange results when using the indices. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Tuesday, April 22, 2008 7:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexes have disappeared No, but how could it have worked before? If a SET.INDEX was required, wouldn't it have to be executed after every copy? We've never done that. On Tue, Apr 22, 2008 at 4:32 PM, Wally Terhune [EMAIL PROTECTED] wrote: Identical file system path to the files and indexes? --- 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] Spooler hold entry number
Why not go paperless and email the reports to an email repository? We email most of our reports now to the various individuals that need them. When they receive them they can squirrel them away in their little cubby holes or delete them. Most don't delete them. The report name is on the subject line so they know where to put it. You could do the same thing only send the email to one mail account that has rules set up to categorize by the subject line. If you send the reports through a text to pdf converter before they are sent they are always printable. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Tuesday, April 22, 2008 8:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Spooler hold entry number Hi Brian, First, for the U2 readers on this list, let me explain that the ANPHOLD file that Brian referred is not a file provided by UniVerse. It is a replacement in SpoolerPlus (our generic Pick/Reality print spooler) for the HOLD file that is in UniVerse. It allows us to have a single Hold File in the SpoolerPlus account that receives print jobs from all application accounts rather than a separate HOLD file in each application account, which UniVerse otherwise creates automatically. This allows us to process all print jobs generated in all application accounts thru one file and aggregate all print jobs on hold in the same file. With regard to the expansion of the length of the hold entry number that is assigned by UniVerse, I asked this question of IBM Support on behalf of one of our other SpoolerPlus customers a few months ago. IBM Support said that this request to expand the Entry No. beyond 4 digits in UniVerse was first recorded a number of years ago, that others had made the same request and that they would add my request to the list of others who had requested it. UniData does provide a means to expand the length of the _HOLD_ file entry number (and our UniData customers are using that feature), but UniVerse does not provide for that at this time (ie. within the past year) as far as I know. I would ask this question of your IBM Support representative under your UniVerse support agreement to get a current definitive answer and to add your name to the request list. With the expanding use of SpoolerPlus on UniVerse and the additional functionality that it provides for managing and manipulating print jobs on hold, users are finding more and more uses for keeping print jobs on hold for longer and longer periods of time, and the incidence of repeating the same Entry No., even though the print job id can not be duplicated, is becoming more and more prevalent. It does make it confusing when you have more than one print job on hold with the same entry number. This problem is not going to go away and it's not going to get better until IBM recognizes the needs of the end-user community to manage larger and larger volumes of print jobs. If anyone discovers a better answer, please let us all know. Thanks, 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: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, April 22, 2008 12:50 PM Subject: [U2] Spooler hold entry number Hello all! I see that U2 gets the next hold entry number from an item in the DICT of ANPHOLD called NEXT.HOLD. It seems to automatically roll over at - it won't go to 5 digits. Although we use the BANNER UNIQUE option on the SETPTR command so that the actual ID of the print job also includes the user, account, date, time, etc., the users themselves only see the entry number when the spooler list is presented to them (long story). Because we could generate quite a few print jobs in a day, and because jobs on hold can be kept for a little while, we're running into some overlap. Does anyone know if (and then where) I can change the limit before the hold entry rolls? Thanks! Brian _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender
RE: [U2] Indexes have disappeared
What was your old revision? If this was changed then it was changed for the worst. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Friday, April 25, 2008 4:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexes have disappeared I just found out that the original indexes had a virtual path (correct terminology?) (../directory.name), which didn't work with the new version of UniVerse (10.2.7), so our vendor changed them to a physical path (u2/ directory.name), which didn't match our other system. So now we do a SET.INDEX every day after the copy from computer A to computer B. Fun. -- Louie in Seattle http://directory.name --- 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] Press any key to continue...
INPUT ANS,1 Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Ferries Sent: Tuesday, April 29, 2008 2:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] Press any key to continue... Hi All, We were coding a standard INPUT ANS after asking a user to Press any key to continue We noticed that the program would not accept a Space Bar as a valid key; it only moves the cursor to the right. However, the Press any key to continue... message from UniVerse accepts the Space Bar as a valid key. Can someone shed any light on how this prompt works? We know the magic command to suppress the message: UDUMY = @(0), but we are more interested in why the INPUT command does not treat the space as the UniVerse message does. Thanks Steve Steve Ferries Vice President Information Technologies Total Credit Recovery 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] Press any key to continue...
That's and old Pick Basic command, it's been replaced by KEYIN() in Universe. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Armstrong Sent: Thursday, May 01, 2008 11:05 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Press any key to continue... Allen, I don't see the IN() form of input in my documention for Universe 10.1.18. Eric -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 30, 2008 2:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Press any key to continue... I think you could just get away using the IN() form of input. CH.IN = SEQ(IN()) This is from the word processor I wrote where it returns the numeric value of any key pressed *including* the space bar. You wouldn't need to evaluate the response for your purpose though hth Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marc Harbeson Sent: Wednesday, April 30, 2008 13:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Press any key to continue... In this case, simply re-labeling the Enter key as Any would be the best way to proceed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Alfke Sent: Wednesday, April 30, 2008 4:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Press any key to continue... We had one user (a lawyer - go figure) complain, quite vigorously, that the Shift key wouldn't be accepted as ANY key. Colin Alfke Calgary, Canada -Original Message- From: Steve Ferries Hi All, We were coding a standard INPUT ANS after asking a user to Press any key to continue We noticed that the program would not accept a Space Bar as a valid key; it only moves the cursor to the right. --- 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/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- 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] Record Locking Problems
Your code doesn't test for the type of lock. It could be just a shared record lock which would allow another user to get in. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, May 07, 2008 10:00 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Record Locking Problems I am trying to make sure that if one Customer.Service rep is updating a Sales Order, then the other Cust.Svc rep is blocked from accessing the same record. The following code will indicates that the record is locked but when the 2nd user goes in (in an independent session), the second user gets in no problem. Since it does not seem to do what I think that it should, [1] I am wondering if I am missing something. [2] I am inclined to create a file to handle this (brute force) with multivalues for user, port, time, date, program, file, record. Comments would be appreciated. --Bill SUBROUTINE SUB.LOCK.SOH.R0 ( Record.ID, Error.Code ) prompt '' open 'SOH' to F.This.File else gosub Error.Opening.File gosub Lock.And.Hold goThe.End *--- -- *--- -- Lock.And.Hold: Lock.Test = recordlocked (F.This.File, Record.ID) crt '**11 Lock.Test ' : Lock.Test : ' [] ' input Ans begin case case Lock.Test = 0 ; recordlocku F.This.File, Record.ID case 1 ; gosub Error.Record.Locked end case Lock.Test = recordlocked (F.This.File, Record.ID) crt '**12 Lock.Test ' : Lock.Test : ' [] ' input Ans return *--- --- Error.Record.Locked: Lock.Test = recordlocked (F.This.File, Record.ID) crt '**13 Lock.Test ' : Lock.Test : ' [] ' input Ans Error.Code = 'E' crt @(-1) crt @(-5) crt crt crt crt crt crt crt crt crt crt '' : @(-6) crt crt ' ___ ' crt ' \ \ ' crt ' \ Error, Record Locked \' crt ' \__\Try Later ' crt ' ' crt ' ' crt ' [X] ' crt ' ' : input Ans, 1 Ans = upcase(Ans) begin case case Ans = 'X' ; null case 1 ; go Error.Record.Locked end case return *--- --- Error.Opening.File: crt @(-1) crt @(-5) crt crt crt crt crt crt crt crt crt crt crt crt ' Big Problem...' : @(-6) crt crt ' _ ' crt ' \\ SOH' crt ' \ Error Opening File \' crt ' \\Contact HK.IT ' crt ' [X] ' crt '' : input Ans, 1 Ans = upcase(Ans) begin case case Ans = 'X' ; null case 1 ; go Error.Opening.File end case return to The.End *--- --- The.End: RETURN END --- 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] U2 - SQL Server ODBC Connection via Universe
There is also Easysoft which seems to be a good one. I've tested it but have not put it into production yet. There seems to be more action being done at getting things from the U2 environment then the other way around. What we are doing here is the other way around, trying to get data from SQL Server for use with our UV programs. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: Friday, May 09, 2008 1:47 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 - SQL Server ODBC Connection via Universe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Thursday, May 08, 2008 10:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 - SQL Server ODBC Connection via Universe Has anyone had success in setting up a ODBC connection from Universe to MS SQL Server 2005? We are needing to get data imported into SQL Server and I was hoping that there is an easy way for UniVerse to connect to the database and do the inserts on its own. Universe 10.0.9 running on Red Hat 7.3 Thanks in advance Marc We're using ODBC drivers from OpenLink to connect from UV 10.2.7 on RH EL 5.1 to MS SQL 2005. Prior to that we were using the same drivers to connect from UV 10.1.4 on RH AS 3. As long as your RH 7.3 install has at least glibc 2.1, I think their driver will work for you. They offer a 30-day trial license. -John --- 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] U2 - SQL Server ODBC Connection via Universe
So would you recommend OpenLink then? Jerry -- From: John Hester [EMAIL PROTECTED] Sent: Friday, May 09, 2008 4:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 - SQL Server ODBC Connection via Universe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Friday, May 09, 2008 1:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 - SQL Server ODBC Connection via Universe There is also Easysoft which seems to be a good one. I've tested it but have not put it into production yet. There seems to be more action being done at getting things from the U2 environment then the other way around. What we are doing here is the other way around, trying to get data from SQL Server for use with our UV programs. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Just a word of caution - I tested Easysoft's ODBC driver last year when we migrated from SQL 2000 to SQL 2005 (it looked like there was a slight cost advantage over OpenLink until I discovered Easysoft charges for each client node in a linux HA cluster). The Easysoft driver worked fine for our daytime transaction processing that involves sending and/or retrieving 5-10 records every few minutes. When I tested our nighttime batch processing, however, which sends as many as 35K records across all at once, the SQL 2005 box would spiral down to the point it was unresponsive and in-turn cause UV to crash. I was able to dig up my email to Easysoft support, and this is what I saw from the UV side: 31268 record(s) selected to SELECT list #0. CR0013: SQLExecDirect failed, error condition SQLSTATE: 08S01, DBMS.CODE: 0ERROR: [IBM][SQL Client][ODBC][unixODBC][Easysoft][ODBC-SQL Server Driver][SQL Server]Communication link failure: socket read failed CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 13. Layer type is Verb. Broken pipe The process would make it through about 15K records before the SQL box was completely unresponsive. This was in Oct. of '07, so the problem may have been corrected by now, but I highly recommend you do tests with heavy transaction loads. -John --- 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] Blink Error - Dictionary Related
Are both boxes on the same release of UniVerse and the same operating system (same release)? Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martel, Henry Sent: Monday, May 12, 2008 12:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Blink Error - Dictionary Related I have a situation were I have a Prod box and a Dev Box both with Universe installed. On the Prod box we have a samba share that is pointing to the Dev box and we have voc entries pointing to Dev files. But when I execute a command such as: Copy from file to Test.file The records will copy over to the Dev box, but it always results in a Blink error. Has anyone experienced this or know how to fix it? Henry M. Database Administrator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bessel, Karen Sent: Friday, May 09, 2008 3:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] Blink Error - Dictionary Related A client is experiencing a blink error when using a certain I-descriptor in a SORT, but not in a LIST or SELECT. I can't copy the code into the post because of copyright purposes, but this is the dictionary item: 0001: I 0002: IF CASE.PERSON.ID # THEN SUBR(CJ.READ.PERSON,CASE.PERSON.ID,1,) E LSE 0003: S;*;*** No Defendant *** 0004: Defendant 0005: 30L 0006: S The dictionary item referenced by the I-descriptor: 0001: A 0002: 1 0003: CASE.PERSON.ID 0004: 0005: M 0006: 0007: 0008: 0009: R 0010: 8 0011: 0012: COMMON Attribute 1 should be single-valued but there are 27 records in this file that have multiple values in this field. On our in-house system, we also have a handful of records that have multiple values in this field, and I can't recreate the problem here. There are commons involved in the subroutine referenced by the I-descriptor. This issue just came to me and the people who worked on it before did all of the data related things I would have done: searched for control characters, fix tool, deleted the file then recreated it, etc. I don't know if I've provided enough information to explain the problembut has anyone seen this? If you've experienced an application-related blink error, I'd be interested in hearing from you. Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.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/
Re: [U2] Backup Question
The built in backup and restore are uvbackup and uvrestore. You can find all of the information in the Administering Universe manual. Jerry Banker -- From: Chandrika Padaki [EMAIL PROTECTED] Sent: Monday, May 12, 2008 2:25 PM To: u2-users@listserver.u2ug.org Subject: [U2] Backup Question Our company has a Universe System. We are trying to automate the backup process without bringing the system down every night. Is there an Online Backup Utility available? If so what is it and do any of you have a sample script I could look at? Thank you in advance, Chandrika --- 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] U2 - SQL Server ODBC Connection via Universe
Is this the one at: www.openlinksw.com Just wondering because they don't mention U2 anywhere. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: Tuesday, May 13, 2008 4:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 - SQL Server ODBC Connection via Universe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Sunday, May 11, 2008 12:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 - SQL Server ODBC Connection via Universe So would you recommend OpenLink then? Jerry Sorry for the delayed reply - just got back from vacation. Yes, I wouldn't hesitate to recommend OpenLink. We've been using various versions of their drivers with UV for about 5 years without any issues. If you're only talking about licensing a single server and single client, they will be a little more expensive than Easysoft, but the difference is only a few hundred dollars. -John --- 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] Problem Printing PCL ESC Sequences to a RHEL Printer from Universe
The printer is not including a carriage return at the end on the line. Set up a Linux script like the following: #!/bin/bash # # Include a carriage return at the end of a line of text before printing. # Cat - | sed 's/$/^013/' | lp -d printername -o nobanner The ^013 is the carriage return character. After creating the script make sure it is executable by everyone that will use it. Then put its pathname in the driver location of the device. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Monday, May 19, 2008 12:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] Problem Printing PCL ESC Sequences to a RHEL Printer from Universe I have installed UV PE 10.2.7 on RHEL 5.1 Desktop and want to send PCL ESC sequences to a printer to configure the printer before I send print jobs to that printer. The HP LaserJet printer driver will not pass ESC sequences thru to the printer (as it won't on Windows). 1.I created a raw printer pointing to the HP LaserJet printer on LPT#1 using the raw printer driver in RHEL. 2.I added a raw printer driver to /usr/spool/uv and installed this raw printer in Universe with a CR Mode = Convert CR to CR/LF and the FF Delay = 2, and verified this setting in the sp.config file in /usr/spool/uv. I can print to this raw printer. However, the first line of the first print job after resetting the printer starts at the left edge of the paper, but each subsequent line starts one line down and on the next character position after the last character in the line above it, like there is a LF at the end of each line but no CR to reposition the cursor to the beginning of the next line. The first line of the following print job even starts one position to the right of the last character in the last line of the previous print job, so the printer cursor position is not even being reset at the end of the print job. 3.The FF Delay in the TERM statement = 2. 4.I added the l.len and p.len and FMT option to the SETPTR command and nothing changed. 4.I attempted to use UniAdmin from a Windows client to define the printer but got the msg No RPC Connection Active. So, I tried to start UniRPC under the Universe Package menu on RHEL and it would not start, with a msg one or more of the required files either did not exist or was corrupt, but they all existed. At this point, I don't know if there's something wrong with the raw printer driver in RHEL or with the Universe printer definition process or the ability of Universe to interpret it. I haven't figured out how to print a print job to a RHEL file outside of Universe so I can examine it to see if there are any CRs with LFs at the end of each print line. Any suggestions will be deeply appreciated. tia, 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 --- 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] Would like to create Missouri Users Group
I am trying to see if a Missouri Users Group is viable. If you work for a company, school, college, government entity, etc. in the State of Missouri or close enough in adjacent states and run on one of the flavors of Pick (D3, UniVerse, Unidata, Reality, jBase, Revelation, OpenQM, etc) would you contact me at: [EMAIL PROTECTED] I want to see if there are enough sites and interest to create a users group in the center of the country. I know there were individual users groups at one time in some of the larger cities but don't know if they are still active. The reason I am inviting all flavors is because I don't know if there is enough of any one flavor to be self supporting. We are an end user of UniVerse located near the center of the state within an hour and a half of any state line and could be the central location for the group (not to mention the Lake of the Ozarks is within walking distance) but we could have meetings at all of the sites so that the burden is not always on the remotest sites to get to meetings. PS: If you subscribe to one of the other users groups email lists, forums, or comp.databases.pick would you pass on this message. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Missouri Multi-Value Users Group
I have been informed that I was a little off on my time to the borders of Missouri. We are actually about 3 hours to any border of the state. I'm glad that I've gotten some responses, keep them coming in. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] HP Laserjets and AIX/Unix
Seems strange that HP would have done that since they have their own 'nix, HP-UX. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] HP Laserjets and AIX/Unix Looks like HP has discontinued the 4240, 4250, 4350 LaserJets and their various tnd models and replaced them with various models P4014, P4015 and P4515 with some new letters. While we can still find leftovers of the old models, it is only a matter of time. The only Supported operating systems Windows 2000; Windows XP Home; Windows XP Professional; Windows Server 2003; Certified for Windows Vista(R); Mac OS X v 10.2; Mac OS X v 10.3 or higher No Unix or AIX. Nor Linux for that matter. Has anybody tried one of these printers with ##IX or Linux so far? Thanks. Roger --- 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 and Antivirus Software
We were just informed that with PCI the systems have to be protected with antivirus software. I thought that there was a problem running antivirus software with the UniVerse database. Am I wrong? If this is true how are other people dealing with this part of PCI. Oh, and that includes *nix systems. What antivirus software is out there for Linux that won't harm the database? Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error Opening HOLD file
If your HOLD file is a type 1 or 19 file it is a directory file and subject to the maximum number of files (records) that can be put into a directory on your operating system. If the HOLD file is a static hashed file, which it is probably not, then it would be limited to a maximum of 2 GB on a 32 bit operating system. More than likely this is a symptom of the maximum number of files you have open. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martel, Henry Sent: Wednesday, June 11, 2008 9:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] Error Opening HOLD file We seem to have a sporatic issue with some of our nightly jobs. They run for months at a time then all of a sudden, for 3 or 4 days in a row we start to see the following error *PRINT.ONE.SEE.ATTACHED: Line 555, Cannot open file HOLD. Job seem to just fail because it can not open the HOLD file. Its more than just this one job, it happens to many jobs. So I suspect is some kind of issue with the HOLD file and not the job it's self. Has anyone else seen this before? Is there a max number of entries that can be in the HOLD file at one time? Thanks in advance. Henry. --- 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] Uni Kernel
Although PICK was an operating system at one time, and therefore had a kernel, the U2 products dropped the kernel so they could operate on any operating system with adjustments. There is a engine that manages the applications built in the environment but it is not usually called the kernel. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Monday, June 16, 2008 9:45 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Uni Kernel I was recently asked about the kernel of UniVerse. A quick look on Google, IBM's website, and the UV manuals that I have did not lead to much. Wikipedia has an insightful writeup of Kernel (Computer Science) and Linux Kernel. Comments on the significance of the UniVerse (or UniData) kernel would be appreciated. --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] Friday query logic
I take it that you checked to make sure that the fields were associated so let's take a different look. Are the values separated by value marks or sub-value marks? What does the dictionary contain? What does the record below look like in the editor? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, June 24, 2008 12:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Friday query logic Eric: That doesn't work either. list APOPEN WITH ANY ACCTS UNLIKE 52... OR WITH ANY ACCTS UNLIKE 29... INVDATE COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS 58*6-4 06-01-08 LOAN #123456, 06/2008 5230246.04 2910 1,025.50 2365 61.08 2980273.70 5230 50.00 I wouldn't have expected this to work anyway because every MV meets one or the other of the criteria. The dicts ACCTS and AMTS are associated with each other. I would have expected the following to work though: list APOPEN WITH ACCTS UNLIKE 52... AND WITH ACCTS UNLIKE 29... INVDATE COMMENT ACCTS AMTS APOPEN INV-DATE DESCRIPTION ACCT. ACCT/AMTS 58*6-4 06-01-08 LOAN #123456, 06/2008 5230246.04 2910 1,025.50 2365 61.08 2980273.70 5230 50.00 Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] AR collection software
You could also look into Ontario Systems. They work on a Cache system which allows you to still program in Pick. www.ontariosystems.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Wednesday, July 02, 2008 1:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] AR collection software FYI, I've done autodial from MV (as well as outbound calling for collections with voice/DTMF response). With a character interface or thick/thin GUI, the MV system sends a message to Skype running on the user's local PC. The call is made and statistics logged back to the app. Doing it yourself starts with the Skype API, and a web service client and server. Having it done for your starts with an email to me. Depending on the results of your user requirements study, you may not need a separate package but a GUI and various components which can be assembled for a much lower cost than a new business application package. Feel free to contact me for free consultation. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com -Original Message- From: John Hester I think the main feature we need right now is automation of the collection specialist's process of deciding who to call next. But, as I replied to Roger, there may be other needs that we don't know yet because we're still gathering user requirements. I'm expecting they'll probably want a dialer feature, though. We would be plugging this into our existing AR invoicing and aging system. --- 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 - Pick mentioned in letter to the editor... [not-secure]
Karen, Aren't you already doing those jobs on U2? Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bessel, Karen Sent: Tuesday, July 08, 2008 3:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure] LOL I agree. He should speak for himself. I'd trade my legacy software developer job for a data warehousing/business intelligence/database developer job tomorrow. Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Tuesday, July 08, 2008 2:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OT - Pick mentioned in letter to the editor... [not-secure] Interesting, it's a shame that what he says isn't really true. George On 08/07/2008 19:59, Hennessey, Mark F. [EMAIL PROTECTED] wrote: This appeared in the letters to the editor section of the July 1 Software Development Times HIS PICK FOR AN OS IS CLEAR I read your article about virtualization (Virtualization 3.0, May 15, page 25, or http://tinyurl.com/5j4dnc) with some amusement. I am an old Pick database programmer, and Pick has done virtualization since the 1970s. The Pick OS will load and run on just about any platform, including Microsoft's. It uses built-in tools to create one of the easiest-to-use and most versatile 3D relational database models on the market. Yet, it never merits mention in any of the mainstream media periodicals. Just about every buzzword and acronym you guys punch out every month, Pick has been doing since bell-bottoms and afro hairdos were in style. All the techno-weenies out there owe a great deal of what's happening in their careers to this venerable OS, yet I'll bet less than 5% have ever heard of it. Had Dick Pick not passed away in the mid-1990s, things might have been different today. But wherever you find a Pickie out there, they'll tell you that they wouldn't trade their legacy system for all the whiz-bang buzzword-laden toys in the world. So how about a nod to the good old days once in awhile? Gary Lass Wilsonville, Ore. Mark Hennessey State of Connecticut Department of Social Services Information Technology Services Child Support Systems Voice: 860-424-5261 Fax: 860-424-4813 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England Wales ** --- 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] Malcolm Bull
Gone...all gone... :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Wednesday, July 09, 2008 1:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Malcolm Bull Malcolm had a great site. A real loss the the MV world. But *not* entirely lost, at least for now. The links I searched for on the Wayback Machine site: http://www.archive.org/web/web.php , were available there. Here are the links I saved from his site a few years ago to get you started: Remember our websites: + Instructions for loading ZIPped files: http://members.aol.com/_ht_a/mbtraining/fileload.html + Books training courses for Pick MultiValue users: http://members.aol.com/_ht_a/mbtraining/index.html + MB-Cyclopfdia for Pick MultiValue users: http://members.aol.com/_ht_a/mbtpublish/index.html + MB-OnLine Publications for Pick MultiValue users: http://members.aol.com/_ht_a/mbtexts/index.html + Request a No-Obligations Quotation for our Training Products Publications: http://members.aol.com/_ht_a/mbtraining/proform.html + Our This is ... series of Books for Pick MultiValue users: http://members.aol.com/_ht_a/mbtraining/thisis.html + Our series of MB-Master Self-Tuition Courses for Pick MultiValue users: http://members.aol.com/_ht_a/mbtraining/mbslist.html + Our On-Line series of MB-Master Self-Tuition Courses for Pick MultiValue users: http://members.aol.com/_ht_a/mbtexts/134.html Enjoy, Tom Derwin [EMAIL PROTECTED] 07/08/08 2:31 PM Malcolm has been talking about pulling the site for a few years now. Both Glen Batchlor and I offered to re-host it for him, but he declined. - Chuck JPB-U2UG wrote: Has something happened to Malcolm Bull? His site is no longer on AOL. Jerry - 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/
RE: [U2] Malcolm Bull
Actually I was more concerned about Malcolm then the resource, has he retired and closed up shop. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Wednesday, July 09, 2008 7:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Malcolm Bull From: Thomas Derwin Malcolm had a great site. A real loss the the MV world. From: JPB Gone...all gone... :-( It's not all gone, some documents are still out there but I don't think it's appropriate to make a last-ditch effort to grab resources that Malcolm later offered for-fee. IMO, there's a difference between how we can use technology and how we should. YMMV If the resources were so precious, perhaps people should have been paying Malcolm for his efforts while the resources were available for purchase? I offered years ago to host, sell, and send him the proceeds for any of his materials. He declined as he has with all similar offerings. It's all great work but now it's a bit dated as well, and would need a tremendous amount of redacting to be a current, accurate, and quality sort of reference for today's IT personnel. There are at least two things that can be said about old documentation. First, it's better than nothing. Second, if it's old or incomplete it could be worse nothing. Both can be true depending on the specific context. Not only do you not want people to be influenced by obsolete notions of how things work, but you also don't want them talking to management, family, or competitors about how your company can't afford software with documentation from this decade. Then again, for a lot of it, not much has changed since the last decade. As always, lots of angles. I hope something can be done to ensure Malcolm gets what he wants while preserving the resource for the community so that it can be reincarnated later. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.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] Re: Going to U2 University 2008?
This is only the second year for U2U. Before that they were part of the general IBM yearly conferences. They decided that U2 had enough of a specialized and enthusiastic following that they could have conferences in multiple areas of the world. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Bergsagel Sent: Wednesday, July 16, 2008 12:25 PM To: u2-users@listserver.u2ug.org Subject: [U2] Re: Going to U2 University 2008? Ah, found the U2 University session abstracts: http://www-306.ibm.com/software/info/u2/university/index3.jsp --- 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] converting from UniVerse on Redhat Linux to UniVerse on Windows
Actually 99% of our business data and logic is contained on the Universe database but 90% of the fluff that connects to it is in windows. This has created a problem in that the majority of personnel dedicated to the fluff far exceeds the number of personnel dedicated to UV, and there's power in numbers. The problem Brenda is talking about started just before I started with the company and caused us to loose the manager and a couple of other UV programmers. Unfortunately I came in during the middle of it with a signed contract that said I wouldn't leave for at least a year. I had to learn their applications very rapidly and finally found that everything that went wrong was due to screwed up cross reference files that had multiple entries making the reports all come out with double or triple entries. The data was not wrong it was just reporting wrong. I created programs to rebuild the cross reference files, tested the reports for accuracy, and was happy to tell the new manager that the problem was fixed when he walked in the door. I celebrated my 10th year with the company in May. You tell me, how difficult would it be to convert close to 40 GB of data in thousands of files all of which have multi-valued and some sub-multi-valued data, to SQL Server tables. Plus over 4000 programs to access, manipulate, display, or print the data. -- From: Brenda Price [EMAIL PROTECTED] Sent: Tuesday, July 22, 2008 7:45 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows If, on the other hand, your U2 system and processes make up much more than 1% of your business IT, which can easily be imagined because SQL and OO infrastructure is bloated beyond belief, then realize you can pretty much do anything with MV. It is a far, far, far better platform for transaction processing than anything else you can imagine. We are a billing and collections company, UniVerse runs that. We also sell a VisualFoxPro software that clients can use to run their Martial Arts, Tanning Salons, Health Clubs on, checking customers in and for those who want to handle the billing themselves, do the billing. For those who want us to do the billing, that data is uploaded into our UniVerse system. We have clients that do not have the VFP software that we do billing and collections for, and clients that use our Windows terminal services so that the data is in one repository at our site running the VFP software, that data is also uploaded into the UniVerse system for billings and collections. Everything except our old dialer and UniVerse is on a Windows platform. That said, UniVerse is the core of the business. You break that and you break the business. In fact about 10-11 years ago, they did do something that screwed up the reports where nothing matched for several months and almost folded because of that. I don't know the exact details since I've only been here about 7 years. --- 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] Green Software - Green Business
In our area of the Ozarks none of this would work because most of our roads are two lane and, except for the main roads, they are unpaved. We have several people that have changed to driving motor cycles and higher powered motor scooters. Most of the people in this area have to drive 4 wheel drives because of the dirt roads and they know how to drive 55 mph on the winding roads so anything that is underpowered, like a bicycle, would be risking their lives. Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, July 31, 2008 5:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Green Software - Green Business Ross, That's funny - and sad. My sister lives in Norway - and maybe that explains why I haven't heard of any other companies doing it. Maybe US companies are concerned with just such a lawsuit! Now who can I sue because the US has developed such a litigious reputation? S Date: Wed, 30 Jul 2008 19:00:48 +1000 From: Ross Ferris [EMAIL PROTECTED] Subject: As an observer from across the water, and given the litigious nature I perceive pervading the US, I just wonder what will happen to this initiative the first time an employee is hit injured whilst travelling to work? If the community had bike lanes and/or trails that were JUST for bikes, it would be safer -- unless of course one of the bike riders runs over an innocent pedestrian I'm probably just FAR too cynical :-( Ross Ferris Stamina Software Visage Better by Design! --- 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] Available printer memory exceeded
Last night during our month end batch process it aborted the proc when we got Available printer memory exceeded during one of the programs. I ran the program this morning and it ran without getting the error, same program, same data files. Can anyone tell me where I could look to keep it from doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Available printer memory exceeded
1. It's not a printer, it's a program run from a proc. 2. see 1 3. Red Hat Linux AS3 4. Universe release 10.1.12 It seems that all memory errors are printer memory errors on Universe. Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, August 01, 2008 1:32 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Available printer memory exceeded 1. What kind of printer is it? 2. Is there a JetDirect or some other print server involved? 3. What OS is it running on? 4. Is it UniData or UniVerse? --B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of jpb-u2ug Sent: Friday, August 01, 2008 12:54 PM To: u2-users@listserver.u2ug.org Subject: [U2] Available printer memory exceeded Last night during our month end batch process it aborted the proc when we got Available printer memory exceeded during one of the programs. I ran the program this morning and it ran without getting the error, same program, same data files. Can anyone tell me where I could look to keep it from doing this? It has always run without problems in the past, it only runs at month end, but there were some minor changes made to the program that shouldn't have caused any problems and don't when run by itself. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert Affiliated Acceptance Corp --- 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] Basic Match...
The help file specifies: A tilde (~) placed immediately before pattern specifies a negative match. That is, it specifies a pattern or a part of a pattern that does not match the expression or a part of the expression. The match is true only if string and pattern are of equal length and differ in at least one character. Since you are testing for length and the lengths are the same the tilde doesn't come into play. Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Monday, August 04, 2008 5:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Basic Match... UV 10.2/aix Can someone tell me if this would be expected output. Specifically the tilde modifier on the match pattern appears to not be working. I would have thought that the last column was the opposite result... TEST.MATCH 001 cell = '' 002 for i = 1 to 6 0003 cell := i 004 crt cell, cell match '4X', cell match '~4X' 005 next i 006 end RUN TEST.BS TEST.MATCH 1 0 0 120 0 123 0 0 1234 1 1 12345 0 0 1234560 0 Cheers, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniobjects help needed!
Have you contacted IBM yet? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Thursday, August 07, 2008 9:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects help needed! Jeff Powell wrote: May I add my experience here? PLEASE! We are going on day 8 (or 9 I am losing count) with little to no progress. One thing I was wondering could it be an issue with the unix memory segments having issues? also I am noticing what I think is a huge amount of tcp bad checksum errors but very few rebroadcasts does anyone more familiar with tcp/networks have a base line for what is normal we have several hundred users. Also what would happen if uvrpc ran out of licenses? also I am noticing that when our crappy system gets really loaded the application seems to lock up more as well as take long times to respond, could this be an indication of something? I wanted to say thank you to everyone (those who have responded and everyone else who has not complained about the fact that this is not truly a universe issue but maybe a network/socket/VB/uvrpc one) dougc --- 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 Buy (or develop in) UniVerse?
These questions have come up so many times I'm almost sick of hearing it. I really wish that IBM would get off their duff and get some of these questions answered. I just wonder why they don't run the tests against the other databases. If their afraid to run them against DB2 for fear that their shinning star can be beat then don't do it against it, but at least they could run the tests against their competitors. And don't tell me that it's like testing apples and oranges because we all know that we can build either U2 product to act like an SQL database. If you do find that U2 is not up to other relational databases in their world then try using it natively. Jerry -- From: Louie Bergsagel [EMAIL PROTECTED] Sent: Tuesday, August 12, 2008 6:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] Why Buy (or develop in) UniVerse? Has anyone compiled any reasons for buying or developing in UniVerse vs. Oracle or some other relational database? I keep hearing things like: - UniVerse doesn't cache like a relational db - UniVerse doesn't use indexes properly - UniVerse selects aren't as fast as a relational db and I don't know what to reply. I've googled Multivalue vs. Oracle and found a bunch of complaints that UniVerse doesn't manage data or security like some people think it should. I have a friend who said that sometimes he just wished someone would tell him what to do. He would probably not like UniVerse. I found one white paper on IBM: ftp://ftp.software.ibm.com/software/data/u2/pubs/whitepapers/202452.pdf It would be nice to see hard data like: - Universe vs. Oracle speed benchmarks such as - time to select a 4 million record file. - time to update 4 million records. - time to LIST 4 million records. - UniVerse vs. Oracle tables per (Order Entry, for instance) app - number of UniVerse programmers to support a $100m sales company vs. Oracle - Cost of a UniVerse system vs. Oracle. Oracle here is generic for any relational data base management system, I suppose, including DB2. -- Louie in Seattle --- 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 to Universe port
Dave, Been a while since you've used UniVerse? The print job numbers are 6 digits. I have worked on both Unidata and UniVerse and depending on the flavor used the dictionary's can be the same. Since Eugene has been developing with SB+ more than likely he has been using the Pick flavor which would run well on the Universe Pick or Reality flavors. Unidata does have V dictionary items but Universe has I dictionary items which work the same. I think there use to be a conversion program. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Thursday, August 14, 2008 11:57 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata to Universe port Eugene, I'm sure others will have a longer list, but for starters: 1.The structure of dictionary items is completely different. 2.You lose the ability to expand the print job numbers beyond before they restart numbering print jobs at 1 in UniVerse. Best wishes, 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: Eugene St. Clair [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, August 14, 2008 6:41 PM Subject: [U2] Unidata to Universe port Hello: Does any one have any experiences they would be willing to share regarding the effort required to port applications from UniData to Universe? 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] Unidata to Universe port
I didn't realize you were referring to the HOLD file. In that case you are correct about the numbers being only 4 digits. However, you can expand the usage by giving the hold entries names as well as numbers by using the BANNER option. Here is from the manual: BANNER [ name ] In mode 3, specifies the record ID of the record in HOLD which stores the report. If you do not specify name, the record ID is P#. If you specify name, it is the record ID of the output record. In either case, each subsequent print job uses the same record ID and overwrites the previous job. BANNER NEXT [ name ] In mode 3, appends a sequential number to the name under which successive reports are created in HOLD. If you do not specify name, the record ID is P#_nn, where nn is increased for each new print job. If you specify name, the record ID is name_nn. BANNER UNIQUE [ name ] In mode 3, append a sequential number to the name under which successive records are created in HOLD. If you do not specify name, the record ID is P#_nn, where nn is increased by each subsequent SETPTR command. If you specify name, the record ID is name_nn. -- From: Dave Taylor [EMAIL PROTECTED] Sent: Friday, August 15, 2008 6:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata to Universe port Jerry, Ref: Universe Rel. 10.1, Pick flavor account. Perhaps I didn't describe the limitation on the print entry numbers (unique print file names) in Universe correctly, as I understand it. The Universe User Reference Guide describes the use of the HOLD file as follows: -- HOLD Description HOLD is a local type 1 file used to hold spooled reports. If HOLD does not exist in the account, SETPTR(UNIX) or SETPTR (Windows Platforms) creates it when you use the SETPTR command to set a logical print channel to mode 3. Spooled reports to that channel become records in the HOLD file. Once a report has been sent to HOLD, you can edit, delete, or spool the report by using the Editor. The report remains in HOLD until you delete it or until another report with the same name is written to HOLD. The dictionary of HOLD contains a NEXT.HOLD record, which is an X-type item used by the spooler to create unique print file names. Field 2 of NEXT.HOLD contains a sequence number from 1 through . In NLS mode, the spool queue directory holds data in UniVerse internal format. When data reaches the printer, it is mapped to an external character set using the appropriate map for the device. However, the default map associated with this file is NONE, unless the directory existed before you installed NLS. When you spool to a hold file, the spooler stores the data using the map associated with the HOLD directory. The data is then mapped again when it reaches the printer. For more information, see the UniVerse NLS Guide. - If you edit the NEXT.HOLD item in the DICT HOLD file and set Field 2 = , it will look like this: ED DICT HOLD NEXT.HOLD 2 lines long. : 0001: X Next Available HOLD File Entry No. : 0002: Bottom at line 2. : If you then enter a SETPTR command with Mode = 3 and use the BANNER NEXT option, each subsequent print job will end in the number in Field 2 of the NEXT.HOLD dictionary record, incremented by 1 for each print job, and will restart numbering from 1 after it uses the number , as illustrated in the following examples: LIST HOLD 04:04:34pm 15 Aug 2008 PAGE1 HOLD... UV^UVNT.SP OOLER^1^N^ 1_ UV^UVNT.SP OOLER^1^N^ 1_1 2 records listed. Unidata also has a default limitation on print numbers, but it can be expanded. IBM has told me that this unique print number can not be expanded in Universe. Do you get a different result than I do when you run the same test? How do you expand this 4-digit limitation in Universe beyond ? According to IBM, a number of others would also like to do this. Thanks, 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: jpb-u2ug [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, August 15, 2008 7:44 AM Subject: [SPAM] RE: [U2] Unidata to Universe port Dave, Been a while since you've used UniVerse? The print job numbers are 6 digits. 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] What Next?
From what I have seen and have read, Java or C#, if you want to stay in programming. Learn the .NET framework but I wouldn't bet on Microsoft supporting it for long. Seems they change what they will support every time they change their operating system. With Java you can program in everything from cell phones to games to web applications. C#, of course, is the latest resurrection of C which never seems to be a bad bet. With both you can program in both *nix and Windows. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Tuesday, August 19, 2008 11:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] What Next? For the last 14 years or so I have been doing programming support and light DBA work; first in Universe (Prime Information) and now in Unidata (Pick). I'm basically a one-trick pony (UniBasic and System Builder) because my goal has always been to move into a business analyst role, but that has never worked out (I'm too IT). Last fall I decided to stop trying to pursue that and stay in what I'm doing. So now I need to decide what I should invest my educational dollars. I want to stay in application development and support because I like better than techie stuff. So what would you suggest I begin learning that would keep me reasonably employable in the future? Thanks. Albert DeWitt Sr. Programmer Analyst Stylmark, 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] [UV] Cannot launch a UniVerse session
Are you doing this on the server that has UV running on it? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Friday, August 22, 2008 12:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Cannot launch a UniVerse session I've found an issue was with the launch from 'command line'. It appears UniVerse was installed such that as a 'normal' user I get this message: C:\uvaccountuv STARTPROGRAM A fatal error has occurred in uniVerse Unable to create or attach the Printer Segment C:\uvaccount What permissions am I looking to correct in Windows? We must have some piece of UniVerse installed such that only 'admins' can execute a UniVerse shell/command... I can telnet in without issue, but I cannot launch from a command line. TIA for any pointers to a UniData veteran/UniVerse Newbie... David W. --- 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 licensing
Do you have a VAR or are you looking to change? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 25, 2008 4:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] universe licensing We're looking to add 100+ more users to our Universe system and management wants some competive pricing. Any reasonable suggestions? Sorry, no source, so we're stuck with Universe and can't consider qm. Thanks. Roger --- 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 on Windows
We have been a *nix shop forever but are going to start testing our applications on UniVerse for Windows. I need a little bit of information about how the logging in works with UV for Windows. We use Accuterm Secure Shell and the vt220 emulation for our terminal session. The user logs in to the Linux server to an attach point set up in their passwd description. The .bash_profile is run to set up their umask, terminal type, and special characters, then attaches them to the account they will use and starts up UV. What is different about the process when using Windows? I've been reading the documentation on the Windows installation and noticed that they talk about setting up telnet but don't say anything about using secure shell. Does ssh work the same way as on Linux? We also use virtual sessions (VNC) on the server that automatically start up when booting to keep some of our processes running without a terminal or PC being active. We occasionally use VNC from our desktop or remotely to monitor its operation and start up new processes. We also use VNC to monitor the console remotely. Does VNC server work the same on Windows? Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Index Files
It could bump up against your maximum number of files opened. You already have two files open with the dynamic file plus each index is another file. 10 indexes 10 additional files. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Tuesday, August 26, 2008 3:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse Index Files Not sure of a limit, but you will see a decrease in performance at around 6 or so (your mileage may vary, but probably not by much). Bear in mind that every write to an index file is a write. If you have 6 indexes and everything else is perfect (no splits or merges), that means that you have to do 7 writes every time you update. Subject: [U2] UniVerse Index Files Date: Tue, 26 Aug 2008 14:48:42 -0400 From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Does anyone know if there is a limit on the number of index files you can build on a UniVerse Type 30 file?AIX 5.3 uv 10.2Andrea Charles Access Manager: This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you have received this e-mail in error, please immediately notify us by calling the Help Desk at (212) 999-9911 or email us at [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ See what people are saying about Windows Live. Check out featured posts. http://www.windowslive.com/connect?ocid=TXT_TAGLM_WL_connect2_082008 --- 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 Index Files
The indexes are btrees and not controlled by the t30limit. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield Sent: Thursday, August 28, 2008 6:45 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Index Files Check your uvconfig file.There is a t30 limit. Looks like default is 200. Do the indexes get counted among the 200? Or are they counted separately? Roger Ray Wurlod wrote: The limit is 1000. This results from the actual index files following the naming convention INDEX.nnn starting from 000. Every index degrades update performance, so you should still be selective. --- 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] UniData Keys
I would go for #1 because the time slice may be short and cause a problem with key creation the other ways. It would create lots of records but small ones and may be faster. You can then move them into another file, periodically, deleting the single valued records and creating multi-valued ones using the email address as the key. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: Thursday, August 28, 2008 7:39 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniData Keys I am tasked with building an log file for our customers using our web site (Redback). I have figured out how to grab what I need, but am not sure the best way to make the file structure. I need to track the user (their E-mail address), the web page, the various request options, the date and time. Should I: 1) make each record a unique hit on the web (i.e. not multi-valued) with a sequential number as the key? 2) make each record a unique hit on the web (i.e. not multi-valued) with the key being the emailAddress*date*time (a big key depending on the emailAddress)? 3) make the key the emailAddress*date, with each hit that person makes a multi-value based on the time? The issue here is that while I am not storing a lot of pieces of data for each hit, some of the data will be big (emailAddress, web page). Option 2 could have a big key and I believe UniData would prefer a smaller one (half the data is the key). To take it to an extreme, since there are no multi-values, the entire key could be the record, but clearly, this is not preferred. Option 3 would take advantage of multi-values, but a user who hits a lot of pages will have a HUGE record for each day. I am leaning towards option 1 (many small records, with a sequential number as the key), but wanted to throw this out for debate. John Israel --- 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
Are you running it from the administrators account? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 02, 2008 3:49 PM To: u2-users@listserver.u2ug.org Subject: [U2] port.status New install of Universe 10.2.4 PORT.STATUS There are no uniVerse sessions that match the specified conditions. But one user is logged on as root and then starting /usr/ibm/uv/bin/uv. And is running a multple program jobstream, so something Universe should have been detected. And we get the same results if a user logins with a unique login, is then pointed to the /bin/ksh and starting uv. Thanks. Roger --- 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
Yes, but it should have already been set. If you want it to work with everyone then set the sticky bit in the /usr/bin/ipcs. -- From: Lloyd Cottrell [EMAIL PROTECTED] Sent: Wednesday, September 03, 2008 12:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] port.status i've found that you need to flip on the sticky bit on the list_readu program to fix this problem, which makes it run as root On Tue, Sep 2, 2008 at 2:49 PM, [EMAIL PROTECTED] wrote: New install of Universe 10.2.4 PORT.STATUS There are no uniVerse sessions that match the specified conditions. But one user is logged on as root and then starting /usr/ibm/uv/bin/uv. And is running a multple program jobstream, so something Universe should have been detected. And we get the same results if a user logins with a unique login, is then pointed to the /bin/ksh and starting uv. Thanks. Roger --- 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
My mistake, thanks Ken. It's just that when you don't do it too often the names get jumbled together. Beside the fact that '+s' sounds like it should be sticky. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Wednesday, September 03, 2008 10:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] port.status OK, I ignored it the first time, but if this is going to keep rolling then I need to jump in with a correction before people assume it must be correct. This is not the 'sticky' bit. The purpose of the sticky bit on some (older) unix implementations is to keep the text segment of an executable loaded in memory once it has been executed rather than unloading it at completion. This was designed to make commonly used programs load faster, but is now pretty much irrelevant in that context and is ignored by some unix implementations such as Linux. The sticky bit is most often used now on directories such as /tmp where it requires the actual owner of a file to delete or modify that file, even though other users might have write permission on the directory. The sticky bit gets set with chmod +t. If you want a program to run with the credentials of another user (such as root) when it is executed, then you set the 'setuid' bit with chmod +s and make sure the file is owned by the appropriate user and executable by relevant people. I won't get into arguments about how good an idea it is to set the setuid bit on random bits of the operating system. Cheers, Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Thursday, 4 September 2008 11:24 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] port.status Yes, but it should have already been set. If you want it to work with everyone then set the sticky bit in the /usr/bin/ipcs. -- From: Lloyd Cottrell [EMAIL PROTECTED] Sent: Wednesday, September 03, 2008 12:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] port.status i've found that you need to flip on the sticky bit on the list_readu program to fix this problem, which makes it run as root On Tue, Sep 2, 2008 at 2:49 PM, [EMAIL PROTECTED] wrote: New install of Universe 10.2.4 PORT.STATUS There are no uniVerse sessions that match the specified conditions. But one user is logged on as root and then starting /usr/ibm/uv/bin/uv. And is running a multple program jobstream, so something Universe should have been detected. And we get the same results if a user logins with a unique login, is then pointed to the /bin/ksh and starting uv. Thanks. Roger --- 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] UNIVERSE on Red Hat?
Actually when I moved the data over from the Solaris system I used uvbackup to a file. Copied the file to the Linux server through an NFS mount and used uvrestore to restore the accounts. So I didn't have to do an fnuxi on the data files. I did have to compile all of the programs and I-descriptors in the dictionaries. Any operating system command that was used in our procs or programs had to be checked to see if they needed changing. Most of these had only an option that was available but not being used on the Solaris system but was needed on Linux so I made the changes before the move. I had a little bit of practice doing the move during a month of testing our apps on the new system so I had the procedure down pat. The UV was loaded on the Linux system and I set up all of the printers ahead of time and named them the same as the printers on the Solaris system so I didn't have much to do with that when we moved the data. All of our spooler scripts had no problem. The mail program had some slightly different options as did the 'cp' and 'rm' commands. The uv account was in a different location but updating the account after it was moved took care of that. I started to move our data accounts on a Friday night, just to be safe, I was able to move all of our database over in one night and it was ready the next morning. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Friday, September 05, 2008 10:02 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UNIVERSE on Red Hat? We switched from Solaris to Redhat about 3-4 years ago. Some unix commands were a little different that we had in scripts and some programs, those had to be changed. It is on a Dell box and it was like comparing a Jet to a prop plane in terms of performance. I remember it being an easy switch over. Hardest part was porting the data over, for us we had to funxi the data. I can't think of anything negative about the switch at all. It has been a very stable environment, we have 117 user license, and most of those get used. We use uniobjects for several applications. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO -Original Message- From: Doug Chanco [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 8:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] UNIVERSE on Red Hat? Hey all, Does anyone have any experience running universe on red hat in an enterprise environment? I have run UV PE on centos and red hat just fine BUT I am talking about 400+ users, uniobjects, tons of printers, etc .. I would LOVE to hear about enterprise experiences running universe on a red hat system in particular; 1. any gotchas? 2. any praises? 3. any performance issues? 4. any universe/OS issues? 5. any printing issues? 6. any issues with terminals or termdefs/termcaps? 7. uniobject problems? 8. anything else anyone may have run across that I did not mention This is really a question for fitzgerlad/long but what about running FAST on linux? (a wonderful chance for a plug here) :-) Any and ALL experiences/thoughts/whatever are welcomed! IF we move it would be from aix 5.2/universe 10.1 to red hat enterprise server/universe 10.2 on a beefed up dell server Our current setup is about @400 users @40 printers @250 uniobjects connections (from a windows app) Connections from datastage throughout the day @3000 pick databases The biggest being @ 5 gig in size Also while this is not really pick related does anyone have any experience with flash copy on linux/red hat? It allows us to unmount file systems and 'flash copy the data to another area and the remount the file system and then make a backup from the flash copy area. Thanks! Dougc --- 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 trigger errors - log daemon issue
Could you send what you did to set up the trigger, maybe then we could come up with an answer? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jayones0317 Sent: Tuesday, September 09, 2008 8:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe trigger errors - log daemon issue Hi guys... I have been setting up some test file triggers on our system.. Very simple test and getting the following error.. If you guys could point me in correct direction to resolve error message below, it would be greatly appreciated... thx, Jay Jones Careplus Inc Tampa, FL Universe version- 10.1.8 SB+ version - 3.04 Unix version- HP-UX 11.11 Error messages when attempting to file a change to the file with trigger.. Program ED: pc = 7408, FATAL: Timeout waiting for log daemon to accept new ent ries. Program ED: pc = 7408, Error performing trigger for PHP_PHP.F000. Failed to file 457310 in file PHP_PHP.FTP.LOG. STATUS = 909025 -- View this message in context: http://www.nabble.com/Universe-trigger-errors---log-daemon-issue-tp19391955p 19391955.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] [UD] Tab characters in output
If the command is like the one in UV then it actually comes from the operating system (who), at least in the Unix world. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 8:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 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/
[U2] U2UG Board
I want to thank you for the offer to join the Board of Directors of U2UG. It was an honor to be chosen. Unfortunately, with a recent shortage of programmers and increased work load here at work, I will have to respectfully decline the offer at this time. I would not have the time to give the job the attention it deserves. Sincerely, Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- 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] Crystal Reports and UniData
Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, September 19, 2008 9:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData There is, unfortunately, a question of market power here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk the same - BROKEN - dialect of SQL. It's all very well a vendor (like IBM, for example) saying we comply with the standard, but if the official and the de-facto standards don't agree, then the smaller vendors (and here I include U2) are likely to get trampled. Like it or not, IBM should treat any problems with a market-influential tool like CR as high priority, even if it is CR that's at fault. In an ideal world, if IBM said CR is broken, and here's how, it would result in CR getting fixed. In the world we live in, CR can probably get away with saying tough, on yer bike, mate. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- 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] Updating UV/UD PE
This may be true but it really isn't a smart move even in windows, almost everything in programming is delimited by spaces. Personally I think it was one of the dumbest things implemented by MS. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, October 02, 2008 5:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Updating UV/UD PE CREATE.FILE FILE WITH SPACES IN'T 30 Creating file FILE WITH SPACES IN'T as Type 30. Creating file D_FILE WITH SPACES IN'T as Type 3, Modulo 1, Separation 2. Added @ID, the default record for RetrieVe, to D_FILE WITH SPACES IN'T. -Original Message- I'm not quite sure what you're getting at here, but never mind ... Don't forget UV comes from a heritage where space was an illegal character in file names. (And it still is, for quite a lot of other programs that run under Windows, too. Spaces cause me grief, even in Windows itself!) ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Copying UV data
SUSPEND ON Copy SUSPEND OFF Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, October 03, 2008 3:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Copying UV data Re: UV 10.1 on Linux Is there any tricks to picking up a data account from one system and porting it over to another? Do we have to stop UV before the move, or can it be paused like with Unidata? -Kevin 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/
RE: [U2] RE: spaces in file names
Do you wake up on the wrong side of the bed every morning? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Friday, October 03, 2008 3:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: spaces in file names For reference, Windows still stores path/file names internally in short 8.3 format. Support for long names and additional characters was added in Windows 95 as an abstraction (a view) over that for common usage where non-technical people want to use file names like: J. Jones Budget, 2007-2008 (revised).doc Chelsea smashed! at homecoming '07.jpg Windows was designed to be an operating system for home users and later became a server. (Most people forget that PC stands for Personal Computer.) Macintosh supported long, friendly filenames back in 1984 for the same reasons. Unix is a system for engineers, not intended to be used by people creating OS-level filenames for their docs or pictures. Now, just to be clear, I didn't suggest that DBMS files should be allowed to have spaces in them, like CUSTOMER MASTER. I was giving IBM a little grief for not making use of a file system enhancement which was added to Windows 13 years ago so that we can put IBM programs under Program Files. There's no need for *nix compatibility at this level, commands like uv, udt, UniAdmin, and the UniSDK tools are all platform-specific, OS-level programs, and have nothing to do with the data in the DBMS. It's almost understandable that paths to data may give the DBMS grief if they contain spaces, like: D:\Data Sources\ABC Company\UV\Accounts\WAREHOUSE But even in this case, if ported to *nix anyone would know to move that to something more appropriate like: /home/data/abc_company/uv/acccounts/WAREHOUSE In either case, the DBMS-level file system should abstract the MV DBA from OS-level issues. For example, we should be allowed to create files like the following without OS-related issues: .TEMP OPEN-A/R CUSTMAST*DEPT That said, the CREATE.FILE verb should also prevent the creation of filenames that are commonly agreed as being a bad idea, like CUSTOMER MASTER. As always (like case sensitivity) this whole situation is just another case of engineers who decide not to make changes because they speak Unix and they expect the rest of the world to do so as well. The burden is not on them to make software work for the target OS but on developers to have to know how another OS works so that they understand why their own platform isn't working. That's just lazy and backwards thinking. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.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/
FW: [U2] Copying UV data
Sorry it should be SUSPEND.FILES ON and SUSPEND.FILES OFF Jerry Banker -Original Message- From: jpb-u2ug [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2008 4:23 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Copying UV data SUSPEND ON Copy SUSPEND OFF Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, October 03, 2008 3:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Copying UV data Re: UV 10.1 on Linux Is there any tricks to picking up a data account from one system and porting it over to another? Do we have to stop UV before the move, or can it be paused like with Unidata? -Kevin 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/
Re: [U2] RE: spaces in file names
Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. -- From: Allen Egerton [EMAIL PROTECTED] Sent: Friday, October 03, 2008 5:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names jpb-u2ug wrote: Do you wake up on the wrong side of the bed every morning? snip Um, I'm not sure why you found what Tony wrote offensive. I thought it was a reasonable presentation of his point of view. -- Allen Egerton [EMAIL PROTECTED] 860-912-8067 --- 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] RE: spaces in file names
That could be the answer to my question. Tony, you've got to slow down. We all enjoy your posts on this list and you would be missed, but, life is too short, smell some roses. You and I don't know each other personally but I can tell by your writing that you should probably take a vacation instead of paying for a doctor to take one. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Saturday, October 04, 2008 3:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: spaces in file names I enjoy Tonys insights, what I dont understand is how he ever finds the time to post such long responses not only in here but in cdp and on his own blog as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 04 October 2008 16:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.5/1702 - Release Date: 01/10/2008 09:05 --- 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 10.2
Anybody know what it means when your program goes into a break condition and it says: Printer memory out of space Or something like that, and not doing anything with a printer. We are processing several hundred thousand records but not any print files. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD HP-UX] I need to track user logins
The problem with last is that the file it uses for logging the users wtmp is usually cleared every month, at least on Red Hat. What I do is create a text file from the output of the last command at the end of each month and import the results into the database. That way I have the start and stop time and day for every user that has logged onto the system during the month. This had made it easy to show when a user has been at work and for how long. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lunt, Bruce Sent: Wednesday, November 05, 2008 11:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD HP-UX] I need to track user logins Hi All, I need to provide a report that shows what users have not been on the system for the last 90 days. I don't know how to do this and was hoping that someone out there could help me. Thanks in advance, Bruce Lunt --- 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] Antivirus and UV
Does anyone know if we would have a problem with antivirus software, specifically Symantec EndPoint 11, running UniVerse 10.1.12 on Red Hat Linux AS3? Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: {Blocked Content} RE: [U2] Need help with GCI system
Are you doing this as the administrator or as a common user? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Little Sent: Friday, November 07, 2008 7:54 AM To: u2-users@listserver.u2ug.org Subject: RE: {Blocked Content} RE: [U2] Need help with GCI system Hi David, Yeah - I've done make, install, make, install, make install so many times in the last few days, I think I can do it in my sleep. :) Luckily I am not on a production box. You mention the registry entry, but that gets updated when you do the install, and currently says UvGciLibraries bin\magci.dll;bin\gci.dll. I've done the environment variable thingie too, and it didn't seem to make a difference. So... I don' know. I'm waiting on a reply from the VAR but I aint holding my breath their gonna be of any help. -bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Friday, November 07, 2008 3:14 AM To: u2-users@listserver.u2ug.org Subject: RE: {Blocked Content} RE: [U2] Need help with GCI system Hi Bob, Ah, forgot to ask the obvious, does this file exist: e:\IBM\UV\bin\magci.dll As Windows error 126 means missing file or registry entry is invalid. I see you said you ran Make a GCI Library from a GCI Definition File from the GCI Admin menu. I don't see you saying you ran Install a GCI Library from the GCI Admin menu. Quote: This option does the following: - Copies the DLL file from the gcidir directory to the bin directory in the UV account directory - Adds the name of the copied file to the GCI library list held in the Windows Registry The DLL is now ready for use. Note it also states you can use the UVGCIDLLS variable to test your DLL, before committing to updating your UV GCI configuration. Probably a wise thing to do in a production or live environment! :) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Little Sent: Friday, 7 November 2008 1:41 PM To: u2-users@listserver.u2ug.org Subject: {Blocked Content} RE: [U2] Need help with GCI system Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for more information. From: [EMAIL PROTECTED] on behalf of Hona, David S Sent: Thu 11/6/2008 7:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with GCI system Isn't your module called magci and not test? As your error indicates it's looking for TEST in your GCI library. From the GCI documentation: Hi Davd, Thanks for the reply. The library is indeed called test.lib built from test.c/test.obj. In it is the function getSum() I am trying to integrate. The GCI definition file I've created on UV is called MAGCI. UniVerse creates all the magci.* items in the gcidir when I take GCI.ADMIN menu option 5. Make a GCI Library from a GCI Definition File. The way I thought it worked was: The subroutine visible to UV would be getSum and the external subroutine name is the same and the module (.lib) is test because the function is in test.lib. What's odd is that the *hello example and it's accompanying BP GCI1 calling program don't run either. I'm using straight out of the box IBM examples and using the default GCI definition file: GCI. -bob This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment winmail.dat was believed to be infected by a virus and has been replaced by this warning message. If you wish to receive a copy of the *infected* attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Thu Nov 6 18:40:48 2008 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20081106 (message mA72ejno008182). -- Postmaster --- 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] Batch conversion of 32bit files to 64bit
I believe you can do this by using the uvbackup and uvrestore utilities. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Arnold Bosch Sent: Tuesday, December 23, 2008 3:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Batch conversion of 32bit files to 64bit Hi Does anyone know of an easy way to convert a lot (+/- 100) 32 bit UV files to 64 bit ? Doing them one-at-a-time is a pain, and I'd like to convert all of our files, as we regularly run into the 32bit filesize limits. Is it possible to RESIZE.FILE on a 32 bit file to convert it to 64 bit? My System: UV 10.2.10 on W2K3 Server. Regards Arnold Bosch IT Administrator Taeuber Corssen SWA (Pty) Ltd Tel +264 (0)61 293 2106 Cell +264 (0)81 124 8625 Fax +264 (0)61 293 2104 Email: arno...@tc.com.na -- --- 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] POSTED ON BEHALF OF NONMEMBER: SB+ Error Message
My first guess would be, since you are printing to the HOLD file (which is a directory type) is that your disk is getting full of temporary files. The second is that there is a record already in the file and the permissions are such that you can't write over it. -- From: Kevin King precisonl...@gmail.com Sent: Friday, January 16, 2009 10:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] POSTED ON BEHALF OF NONMEMBER: SB+ Error Message We are running a weekly batch process that runs multiple streams via phantoms simultaneously. The process consists of a mixture of SB+ processes, paragraphs, report writer reports BASIC programs. No changes have been made to the particular area of the process for quite some time, all of a sudden, we have started having it crash with the following error message:- Program SH.PRINT.MANAGER: Line 846, Queuing disabled for requested printer. Once the stream is manually restarted (by rerunning the process that crashes), it continues through to the end without any problems, never crashes a second time. The same weekly batch process is run on 2 other live, several other test systems with no problems. Can anyone tell us exactly what this line is trying to do, what the problem could be? - Could it be anything to do with DMSECURITY, as the phantom logs on to a specific SB+ Account to perform its tasks ? None of the reports in the area where the crash occurs actually print - they all go to HOLD. We are running on SB+ 5.4 UV 10.2 on Solaris (all systems). No changes have been made to any printers or setups recently either. None of the programs actually call SH.PRINT.MANAGER, so it must be being called from 1 of our SB+ report writer reports. Any ideas anyone ??? MARY --- 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] Unidata to Oracle
I'm sure we would all like to see how that turns out as well. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Ritchie Sent: Thursday, February 19, 2009 4:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Leaving U2 World to the Dark Side (SQL) Good luck Don, actually finding MSSQL pretty easy to use in a web application I am helping to develop. Excellent integration with MS's Visual Web Developer. If it makes you feel any better I am currently involved in a project to move a long term Unidata db to Oracle. Cheers, Jeff -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Don Verhagen Sent: Thursday, 19 February 2009 10:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] Leaving U2 World to the Dark Side (SQL) To those that know me on this group. I have been using the Unidata databases since 1998 when introduced to it by my former CIO. Over the years and throughout my IT career, it has served me well. Decreasing software production and maintenance costs, while at the same time increasing the value of the software I (we) developed to solve complex business solutions. I have accepted an Application Development management position with a company here in the Philadelphia area. However, they are not a U2 shop. I view this opportunity as a chance to build my skills in and around the .NET platform and evaluate the use MSSQL in a true business application that I myself have built on a U2 platform in a previous time. While this doesn't exclusively rule out U2 in the future, for now, I'll be in SQL-land. Just wanted give a heads up to those that know me here. Don Verhagen Application Development Manager People 2.0 www.people20.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/
RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not
We do it all of the time with no problem. UV 10.1.12 on RH Linux AS 3. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G Sent: Monday, February 23, 2009 9:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not We have a client on UV/HP-UX running a BASIC routine from a Cron job. The BASIC code shells out from EXECUTE and Captures data from the OS. The Capture is failing and it looks like COMO gets the StdOut that should be directed into a variable. I'm not sure yet if Como plays any part or if all Execute/Capturing instructions will fail when executed from Cron. The code works fine from TCL. I'm also checking to see if there are any other options or middleware, and exactly what's being executed in the Cron line. Until I get more info though, I'd like to know if this is a recognized issue. Under what conditions can we expect something like this to fail?: Execute sh -c ... Capturing result Thanks. Tony Gravagno Nebula Research and Development Info@ removeNebula-RnD.com (Various other email addresses are currently down ... it's Monday...) --- 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] Select Problem
It's using it like matching. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, April 14, 2009 11:07 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Select Problem I have just encountered an inconsistency between the native UniData select and the PICK flavored select. From a PICK flavored account, it I use the lower case sselect to force native UniData syntax, I get: sselect ITMMST WITH F2 LIKE ...J1A... (6,213 keys - wrong) If I immediately follow this with the PICK select: SELECT ITMMST WITH F2 = [J1A] (No keys - correct) These two statements SHOULD return the same results. Interestingly, if I use a less restrictive select (search for J1 instead of J1A), I get the following: sselect ITMMST WITH F2 LIKE ...J1... (188 keys which is correct) I am guessing that the UniData flavor is treating the J1A as something else, but until I can figure out what it is doing, I can not come up with a work-around. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 --- 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 to SAP migration disaster
I can't speak for everyone but if it's anything like at our place, it's due to lack of education. UniVerse is contains all of our business logic and Microsoft is used for our presentation layer, desktop and web. We have 3 programmers working on UniVerse with an average age of 55. In our windows area we have 10 programmers with an average age of 25. Most of the people coming out of the colleges and universities only know one platform Microsoft. They are taught nothing about processing data, database structure, proper logic, or problem solving. They are not even being taught Unix anymore. I think the colleges are doing their students a disservice because most businesses are still running other platforms for their business logic and only have windows as the presentation layer. This causes a problem because when the business wants to hire someone they don't have anything except these 90 day wonders to choose from. The candidate has problems because they have never been taught how to use anything other than the windows tools. This isn't exclusive to U2, it's a problem with any of the proprietary operating systems/products and anything on Unix/Linux. This gives the PHB's the mistaken impression that anything not windows is obsolete and they should scrap what they have and go towards all MS or anything else that looks pretty. The new programmers are more than happy to get on board with the idea because most of them want to be working in what they are taught. They don't know what business logic is and they think it would be a walk in the park to switch. After all they were able to build that web page, right? They, of course, forget that the data had to be there before they could present it. The PHB's find that there is a bigger pool of willing low cost employees to choose from and force all of their people that actually know the business logic off the payroll. Then the nail is in the coffin. The new programmers all of a sudden discover that there is something happening in the background that they were not aware of, they try to reproduce it but nothing seems to work the same as it use to. Pride takes over and nobody wants to admit that they may have made a mistake. They don't notify the PHB's that there is a problem, they start panicking, they don't want to rehire the employees they got rid of, so they hire some consultants that don't know the business logic any more than the people that are there. It's not the consultants fault they were expecting that someone at the company knew something about how the company operates. By the time all of the problems come to light the company is on the brink of bankruptcy. Where does the blame go, the people that left were at fault for not giving the youngsters all of the information they needed. -- From: Rex Gozar rgo...@autopower.com Sent: Friday, April 17, 2009 4:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster I've been wondering why the Shane Co. felt the need to migrate away from UV. * Was their IT staff unable to meet business requirements due to the limitations of UV? * Was their IT staff to blame, rather than the UV database environment? (i.e. understaffed, lack of skills, etc.) At any rate, it appears that either (or both) caused Shane Co. management to look for a different solution. Under the assumption if it ain't broke, don't fix it I would think that management thought something was broken, and they needed to spend money to fix it. Does anyone have any first-hand knowledge of the specifics? Anyone care to share their insights? rex John Hester wrote: There were a few posts back in January about Denver jewelry retailer Shane Co. and their disastrous migration from UV to SAP. Today they're starring in an eWeek slideshow about I.T. disasters: --- 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 to SAP migration disaster
In our particular case the IS Manager, who was a Pick programmer retired. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Monday, April 20, 2009 9:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster I guess the basic premise of your argument is that the PHB's are listening to 90-day-wonder windows programmers, and they encouraged said PHB's that they needed to replace the UV database. I don't buy it. Even PHB's don't go spending millions of dollars on SAP just because their 25 year old windows programmers don't think UV is productive. In the case of Shane Co. the PHB's decided to spend millions of dollars -- and no one bothered to do an ROI study? Or it was fabricated by a bunch of idiots without any concept of reality? At some point, Shane Co. must have been doing good. They were expanding. It seems a short time ago I heard they opened a new store here in Orlando, FL. (Or maybe they weren't doing that good after all and the expansion was a feeble attempt at opening new markets to generate revenue.) During this expansion, one of the PHB's must have said we AREN'T getting what we need from IT; let's look into other solutions. Or maybe they said, we CAN'T get what we need. (The former speaking to an unwillingness to address needs; the latter, lacking capability to do so.) And this brings me back to my original question: what was Shane Co.'s REAL reason for deciding to migrate away from UV? If Universe is supposed to be a superior environment for building and deploying business solutions, why couldn't their existing IT staff deliver? Why? It's too easy to characterize management decisions like this as frivolous or political. But it's irresponsible to ignore the true business reasons behind these decisions, dooming ourselves to repeat history's mistakes. rex JPB-U2UG wrote: I can't speak for everyone but if it's anything like at our place, it's due to lack of education. UniVerse is contains all of our business logic and Microsoft is used for our presentation layer, desktop and web. We have 3 programmers working on UniVerse with an average age of 55. In our windows area we have 10 programmers with an average age of 25. Most of the people coming out of the colleges and universities only know one platform Microsoft. They are taught nothing... --- 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 to SAP migration disaster
I resemble that remark. Actually what I was trying to get at was the education and marketing factors. I'm not trying to slam MS or any other operating system. I think that all technology should be used for what it is good at. The right technology for the right task. I just think that the education these new programmers are getting has no depth. They're not being told that what they are being taught may not be what they will encounter in the business world. A case in point is the new thread that just started with the subject: [U2] Getting a graphical view of my data in UniVerse Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, April 20, 2009 2:23 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster I second that. And don't forget those people who have been in the same company and the same office for over 20 years and still reminisce about the 'good old mainframe days'. The first thing a new guy hears is, 'We don't like change here!' Upgrading? Don't fix it if it ain't broke! If you get a request, tell the requester that this is very difficult to do and could have all sorts of implications for the rest of the system. Or even better, 'we can't make any changes because then we can't upgrade the software later, and therefore only the software vendor can make changes to the code.' And of course at #1000 a day for their consultants it better be important. If he or she still wants it, ignore it until they ask again. If they don't, it obviously wasn't important enough anyway. Users will find a way to solve their problems without IT, and in no time the whole business runs on spreadsheets because the stupid 'legacy' software is useless anyway. And who's fault is that? And then you get stupid software vendors who want to sell only their latest web-based, platform independent software product and tell management they will stop support for that old product soon and therefore they should rather not upgrade and buy their latest toy. Or of course the old IT-manager retires and they hire a follower of the Church of Codd as replacement. I've been around and seen it all. It isn't always a PHB. Symeon Breen wrote: There can also be blame at the coalface as well - I know many pick guys who really are dinosaurs and who bury their head in the sand if xml, web services, web access etc are mentioned ... -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glenn Sallis Sent: 20 April 2009 14:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV to SAP migration disaster It's yet another story that makes people who know and understand the multivalue database model cringe. Often one of the reasons for migrating seems to be due to decisions being made upstairs by people who have not bothered to consult the people with the knowledge to inform of the technical realities and work involved in such a major change. I have noticed over the years that SAP has been very heavily marketed. There is usually a reason for a product needing to be advertised ;-). Just because a product has massive marketing muscle behind it doesn't mean it's the bee's knees. I'm sure this story won't be the last expensive disaster! Glenn Sallis Software Developer Flextronics Logistics B.V --- 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] Employment disaster
I wouldn't say that too loudly there's a lot of potential employers on this list. Most smart companies like to have someone that is willing to stick around long enough to learn their business logic. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, April 22, 2009 5:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster jpb-u2ug wrote: snip Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker Not me Jerry, I usually don't stay long enough for that to happen. If there's nothing new to learn I move on. --- 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] Help with encryption
Charles, If you have Outlook you have to use the out of office assistant on the tools menu. You can make it so no message goes to the list. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, May 12, 2009 3:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello, This is to the moderator. I will be going on vacation next week for two weeks and will set my out of office message before I go. How do I stop from sending these messages to the list and how do I reenable the list when I get back. Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] SELECT from PHANTOM
I don't know about Unidata but Universe phantoms run as the person that kicked them off. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, May 15, 2009 8:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] SELECT from PHANTOM We are using Unidata 7.1 on RedHat and are testing a new system. A barcoding system drops transactions into a UNIX directory and a batch processor running in background (PHANTOM) periodically checks the directory to see if there are any transactions to process. Transactions are making it to the directory OK. And when you select the file at ECL it selects the transactions, but when the batch processor selects the file, it selects no records. I guess I suspect an issue with the user that the PHANTOM process is running as. Who is that? The user that started the PHANTOM? Or the system? Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] Best algorithm for UV part files
We use one part file made up of 13 different files. The record key makes it easy for us because they are all numeric. We just made the algorithm MOD(key,13) + 1. The reason for 13, it's a prime number and the number of records per file seem to come out about equal. Of course we don't have a special purpose for each part file it's just to reduce the size of the file. The set of files contains 2.3 million records but each part has less than 180 thousand. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, May 28, 2009 11:16 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best algorithm for UV part files Hi Baker Unless I misunderstand the question - it don't work like that :) UniVerse uses the partitioning algorithm to determine which part file the record goes into, based on some operation performed on the key that must yield as its result a valid part file number. So you could, for example, perform a hashing algorithm on the key by multiplying the seq() of each character together and divide the whole lot by the number of parts to get a modulus - just like the addressing inside a hashed file... Once that algorithm is in place, every time you request a key it will perform the same operation to determine in which part file it will find the record. So you don't need to specify the part file number along with the key - the key determines the part file. Regards Brian -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 28 May 2009 16:06 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best algorithm for UV part files Very helpful Stuart (and Brian) thanks. 1 follow-up question: given your algorithm below, when you edit or copy those records over, what does the key look like. E.g. do you have to prefix the key generated by your algorithm, with the part file number or name? To edit the record would you simply: AE HAIRY.PF.NAME B123456 Or AE HAIRY.PF.NAME 23-B123456 ? 74 Clear regards from Ft Worth, -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/
[u2u] UV on Windows question
I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
How interesting, you can't just reply to the email anymore, you have to change the to address. Jerry Banker From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz U7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
Let's see now. I have been working on Unix type systems for 30 years and never had an anti-virus program running on any of them. Can you say the same about Windows? In that time only one of them got hacked. Can you say the same about Windows? I can go on if you wish. Jerry Banker From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, June 02, 2009 3:07 AM To: 'U2 Users List' Subject: Re: [U2] [u2u] UV on Windows question It is the rated by the experts as the best of the systems, What experts ? The first reason is that Unix systems are not susceptible by Windows viruses. A protected windows server would not be either - we are not talking desktops here with users surfing the internet all day. From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz U7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
I really didn't want the question of the differences in administration of Universe to turn into a Unix vs Windows battle. Jerry Banker Ps: However if you want to then bring it on.:-) On the community list. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, June 02, 2009 3:07 AM To: 'U2 Users List' Subject: Re: [U2] [u2u] UV on Windows question It is the rated by the experts as the best of the systems, What experts ? The first reason is that Unix systems are not susceptible by Windows viruses. A protected windows server would not be either - we are not talking desktops here with users surfing the internet all day. From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz U7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
I just rebooted my Linux systems last week the first time in about 6 months. The reason, because the windows servers on our network have been changed so many times that they were finally starting to affect Samba on the Linux server. I couldn't just change the IP addresses anymore and restart Samba, I actually had to reboot the system. I have had the system up so long that I got a message like Lee's but I try to reboot at least once a year just so the heads don't weld themselves to the disk surface if I do have to bring them down for some reason. I don't think we have ever had a windows server stay up more than a week so I think you are either lucky or you very seldom install a patch on your server. Jerry Banker From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, June 02, 2009 9:04 AM To: 'Lee Bacall'; 'U2 Users List' Subject: Re: [U2] [u2u] UV on Windows question My main web server running windows server 2003 was last rebooted Feb 2008 ! I think people when you say windows think about their own experience of their desktop whereas when it is on a server the whole usage is very different, that is what i am trying to get across ! Having said all this yes i would prefer linux just because of its ease of tuning using the shell and text based config files is much easier than say a gui and the registry. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lee Bacall Sent: 02 June 2009 14:14 To: U2 Users List Subject: Re: [U2] [u2u] UV on Windows question Right on Jerry. We recently experienced a violent lightning storm here in South Florida. While we have a backup generator and multiple UPS systems, transient protection, etc., we thought it prudent to bring down some systems, do some spring-cleaning and vacuum out the dust bunnies and cat fur from the fans and filters. When bringing up one of the SUSE Linux servers, running uniVerse, I was greeted with the message: System has gone 220 days without a shutdown. To quote Jerry, Can you say the same about Windows? Lee Bacall http://www.binarystar.com - Original Message - From: jpb-u2ug mailto:jpb-u...@hotmail.com To: 'U2 mailto:u2-users@listserver.u2ug.org Users List' Sent: Tuesday, June 02, 2009 8:58 AM Subject: Re: [U2] [u2u] UV on Windows question Let's see now. I have been working on Unix type systems for 30 years and never had an anti-virus program running on any of them. Can you say the same about Windows? In that time only one of them got hacked. Can you say the same about Windows? I can go on if you wish. Jerry Banker ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Unit Testing
Doug and Brian, Could you give me some numbers on how long and how many people (man hours) it took to do the changes? Approximately how many programs did you have to convert to the new way and what did you end up with? Jerry Banker From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, June 11, 2009 7:55 AM To: U2 Users List Subject: Re: [U2] UniVerse Unit Testing Brian, You say that you designed all our server code as subroutines such that all of our subroutines had one of two calling interfaces. This would seem to mean that you built and maintained two different versions of every external subroutine/function. Is this correct or am I just missing something? Thanks. Perry _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, June 11, 2009 3:19 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse Unit Testing Hi At my last company, we spent a lot of effort on building an automated test rig for our software, because we had to support multiple platforms and all our code required full regression testing. It may be a slightly different scenario to yours, since we were primarily building tools, and also this was complicated by the fact that all of our software was client/server in some way, and usually involved several languages .. but here is our experience for what it's worth: The bad news is that you really need to design these in from the start. We designed all our server code as subroutines such that all of our subroutines had one of two calling interfaces, either: Subroutine name(InData, OutData, ErrText) or Subroutine name(Action, InData, OutData, ErrText) That meant that we could generate a test rig that could feed the InData (and Action) and then test for the OutData and log any ErrText values. For reports, we would capture the report text and do 'spot checks' on the expected results. We also version stamped our routines, so we were certain we were testing the right versions, and had build scripts to recompile everything. Nothing left to manual operation since that opens up the opportunity for something to get forgotten: there is no point testing stuff to QA and then doing something different when you come to release! Incidentally, since this was client/server, these involved VBScript scripts for the client end calling cutting paragraphs on the server along the line. Because Universe code doesn't break down into simple blocks, unless you want to instrument your code and capture all your file I/O - which is possible - and test for that, your only sensible option is to unit test at the subroutine/external function level. The good news is that because UniVerse caches subroutines in memory, the overheads to breaking out code are not as high as on systems that do not. it also means you end up with a more manageable system, better options for reuse and if you adopt different client front ends, easier to migrate. You may also find out that your code mass reduces as you split these out, because there is less duplication (sorry if I'm stating the obvious here) and so your testing domain is reduced also. If you want clean-room regression testing, I highly recommend Virtual PC is it will support your OS. We kept clean images of all the platforms we supported, which was a huge time saver. One nice thing about VPC is that it supports 'undo disks' which means that you can snapshot the image at a particular point, and then any changes e.g. brought on by software loads for testing are physically and transparently stored outside the virtual disk and you choose at the end whether to commit those changes or not, making it very easy to go back if that version didn't pass. Finallly, having a predictable way to load routines from dev to QA and from QA to live is a must - so I'll put in a very small [AD] for mvInstaller... Regards Brian _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: 10 June 2009 20:33 To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse Unit Testing The powers that be have been discussing the possibility of going to a unit test model for QA. As I understand the concept, portions of code are broken down into smaller manageable chunks against which a dedicated unit test for each may be run. This seems like a good idea in an object oriented world where methods of object can be easily invoked. This would seem less practical in with a procedural language like BASIC. It feels like we would end up breaking out thousands of lines of code into external subroutines which could then be run through a dedicated unit test. This would introduce significant overhead with all the CALLs to hundreds (thousands) of external subroutines. Then there are
Re: [U2] [UV] Currently preferred Linux distro
This won't be a problem if you use uvbackup and uvrestore. Otherwise you will have to do a fnuxi. If you've been testing with fedora then your best bet would be RH Linux. It's supported and a fairly good track record. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 16, 2009 7:46 AM To: U2 Users List Subject: Re: [U2] [UV] Currently preferred Linux distro When you convert your data, be aware of the endian-ness of the two platforms. AIX to x86 will require a conversion. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor for long filename in type 1 file
Create a type 19 file and redirect the logs to the new file. UFD is a bad place to store these types of files anyway because it is the account directory. When yo go to clean up the file you may accidently remove part of your account. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, June 23, 2009 8:55 AM To: U2 Users List Subject: Re: [U2] I Descriptor for long filename in type 1 file Why not just resize UFD to a type 19? Norman, David (Health) wrote: UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1 level. I have created an I-type to extract delimited fields within the @ID which either spans the 2 levels, or is wholly in the 2nd level. Using this I-type to display in a LIST works perfectly. However, as soon as a WITH references this field, nothing is returned. E.g.: LIST UFD WITH @ID LIKE ...as... SAMPLE 5 DATE2 11:10:14 23-06-09 PAGE 1 OS filename...DATE LOG.as13713_15125_49176 29.05.09 LOG.as13713_15125_58659 29.05.09 LOG.as13713_15125_59104 29.05.09 LOG.as13713_15125_59132 29.05.09 LOG.as13713_15125_60631 29.05.09 Sample of 5 records listed. ::LIST UFD WITH DATE2 = 29.5.09 0 records listed. The DICT of DATE2 is: 0001: I 0002: FIELD(@ID,'_',2) 0003: D2. 0004: DATE 0005: 8R 0006: S I don't want to resize UFD to type 19 on this mission-critical 24x7 system - how else can I get WITH to use these fields ??? David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mixed Case UV Basic Programming Standards.
Code in uppercase and mixed case for Comments, displayed messages/queries, and error messages. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, June 24, 2009 1:39 PM To: U2 Users List Subject: [U2] Mixed Case UV Basic Programming Standards. I don't like the way I use mixed case, so it tends to evolve. Not good, because consistency in programming style throughout an application makes for easier maintenance, maintainability is the god of software quality. So I am wondering how others use mixed case. Do you capitalize/lower/mix case for commands? Operators? Variables? Equates? etc. How do you use/not use special characters in variable names? For example: readu OrderMaster from ORDER.MASTER, OrderMasterId locked ... readU OE_rec from OE_f, OE_id locked ... ReadVU OE_Date From ORDER.MASTER, OE$Id, OE$Date Locked ... READU order.master.rec( oe$date ) FROM order.master.file, order.master.id LOCKED ... That sort of thing. I hesitate to even ask this for fear of starting a war. So ground rules for this thread: 1. NOT about MERITS of Uppercase only vs. Mixed Case programming. I am only interested in answers from people who actually use mixed case. 2. NOT about GOTO. Take it outside. 3. This is about PREFERENCE, NOT SUBSTANCE. By substantive I mean rules like: - Only open a file once. - Readu should always have a locked clause. By preference I mean stuff like my example. They are all functionally equivalent. 4. NO ARGUMENTS about whether someone's style is good or bad, or yours is better. Explaining why you do it a certain way is helpful, though. Just remember, when it comes to preferences, no two programmers will agree, yet consistent style, whate'er it be, increases maintainability. Thanks, Chuck Stevenson ___ 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] General guidelines on indexing
It's been a long time since I've been in hardware so I may be all off on this, but, this could be possible because after it sends the WRITESEQ it's basically up to the disk subsystem to actually do the writing. The written sequential record get's put in the queue and the subsystem sends back a signal that it's been done and to continue. However that doesn't necessarily mean it has completed the write. By the time the process is done the sequential file may not have completed writing all of the records in the queue but the process will think it has. I know I have noticed this happen when writing to a networked file system and it makes the file unusable until the writing has completed. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere Sent: Wednesday, July 08, 2009 10:44 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing In one test I did a couple of months back, I found that appending IDs to the end of a dynamic array perfomed _much_ _much_ slower than a WRITESEQ to the end of a disk file and the dynamic array wasnt even a 100 000 records long. We were able to reduce the time required to produce a report from over 30 minutes to less than 2 minutes by removing the dynamic array operations and replacing them with WRITESEQs. We tried all the different syntaxes of appending to the array with no noticeable difference in poor performance once the array got large. - Original Message From: Baakkonen, Rodney A (Rod) 46K rodney.baakko...@cigna.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, 8 July, 2009 17:15:57 Subject: Re: [U2] General guidelines on indexing In theory, I would have to agree with you. Who knows how all this stuff really works under the hood. You have Unidata Shared memory management and shared basic code server. We also have a huge SAN with a lots of cache. Measuring performance and impacting it is different these days. There are so many layers and events, finding the bottleneck can be tricky. All I can tell you is that we did extensive testing and we would not be doing what we are unless it worked. Maybe on you site, on your server and your database, these techniques don't enhance performance. I'm telling you what we found, your mileage may vary. We have been told to use concatenate with a @AM to build our arrays, as Unidata has a pointer to the end of a variable. We have been told to use REMOVE when pulling data out of the array. We know that. We still had performance gains that went from days to hours when we changed to a well sized work file. There are many reasons why we use the work file. Typically this is used in the selection part of the process. The sorting and reporting is after. Sometimes the work file contains more than keys ( vs. having multiple dynamic arrays). Sometimes multiple reports are generated from the same work file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, July 08, 2009 6:47 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing I don't agree. Disk access is inherently slower than RAM access. Therefore a process that makes efficient use of RAM will be faster than an equivalent algorithm making efficient use of disk. In your case, it's just a matter of scale: 50 million records at (lets say) 14 bytes per ID plus the multivalue marker needed to build up the dynamic array. 15 * 50,000,000 = 750,000,000 bytes. That's 732,422KB, 715MB If your process is running on a modern server then this kind of op becomes practical. Assumptions: - that the dynamic array isn't using Unicode. If it is then memory reqirements double. - That you select every record - normally (presumably) it would be just a fraction? In fact isn't all of this theoretical? Using the index select / readfwd / own tests method, there's no need to build workfiles or dynamic arrays at all - simply do the tests as each record is retrieved with readfwd and then create the report / do the processing all within the same loop? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 08 July 2009 12:30 To: U2 Users List Subject: Re: [U2] General guidelines on indexing When you have a file with 50 million records, it does not matter how you build the or parse the dynamic array. A well sized work file will run circles around the dynamic array. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, July 08, 2009 6:12 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing After indexing, we made a lot more use of the SETINDEX and READFWD logic in our programs. I find this curious
Re: [U2] General guidelines on indexing
I tried it on my system UV 10.1.12 on Linux AS3 0.643 seconds. -- From: Martin Phillips martinphill...@ladybridge.com Sent: Thursday, July 09, 2009 3:38 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] General guidelines on indexing Hi Adrian, I just tried this example on Universe 10.2.6 - it took 0.0665 seconds basically instant, can't complain about that. I am sure that something must have been wrong with your test. This probably isn't long enough to do even the empty loop with no string copy. I have just repeated my test on a different system running UV 10.2.8 and the test took 38 minutes. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org 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] General guidelines on indexing
I have 2 RH Linux AS3 64bit servers one on a Dell 6800 with 4 processors and 16GB memory with UV 10.1.12 and 117 users. The other is a Dell 2500 with 2 processors and 16GB memory with UV 10.2.4 and 6 users. The first takes 0.1876 seconds and the second is 0.1106 seconds. The time varies with the amount of activity and if I run them consecutively but I haven't had any trouble with memory or going over 1 second. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, July 10, 2009 4:15 AM To: 'U2 Users List' Subject: Re: [U2] General guidelines on indexing Ok I am very jealous now of all these quick times, when my one crashed out Can someone remind me (its been years since i did any udt config stuff) what should i be looking at to fix this error Thanks PS - i like this thread i think this can be of benefit to people to fine tune both code and their os and u2 configuration ! -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 09 July 2009 14:04 To: 'U2 Users List' Subject: RE: [U2] General guidelines on indexing Unidata 7.1 (32bit) on redhat EL 3 64bit, on XEON E5335 with 4 gig ram. Error when creating a shared memory segment (size=35682416), errno=22 Lol Hmmm ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings Sent: 09 July 2009 13:40 To: u2-users@listserver.u2ug.org Subject: Re: [U2] General guidelines on indexing IBM BOX (OLDER) PICK.FORMAT 10.0.11 6.9377 seconds Linux box PICK.FORMAT 10.2.0 0.3522 seconds Date: Thu, 9 Jul 2009 11:20:25 +0800 From: adrian.wom...@rac.com.au To: u2-users@listserver.u2ug.org Subject: Re: [U2] General guidelines on indexing I just tried this example on Universe 10.2.6 - it took 0.0665 seconds - basically instant, can't complain about that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, 9 July 2009 12:59 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing By way of a simple expample, I just tried the following program... s = '' z = str('*', 1000) t1 = time() for i = 1 to 10 s-1 = z next i t2 = time() crt t2 - t1 This took six seconds on QM but 32 minutes on UniVerse. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ HotmailR has ever-growing storage! Don't worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutoria l_Storage_062009 ___ 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] which files have triggers
All this talk about triggers and I just received the following from IBM. 7. UniVerse: Flashes Using fixtool to repair UniVerse dynamic file header corruption may result in data loss at 10.3.0 http://www.ibm.com/support/docview.wss?uid=swg21376672myns=swgimgmtmynp=OC SSCRY4mync=E At UniVerse 10.3, modifications made to the new.record contents in a trigger subroutine are not applied when the WRITE completes. http://www.ibm.com/support/docview.wss?uid=swg21392473myns=swgimgmtmynp=OC SSCRY4mync=E Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 13, 2009 3:43 PM To: U2 Users List Subject: Re: [U2] which files have triggers Thanks, I found the article. That would make tracking triggers easier. One thing however, in the routine, you have notriggers = dcount(triggers,@fm) for trigno = 1 to notriggers trigger = triggers(trigno) call @trigger(...,newid,newrec,oldid,oldrec,...) next trigno Just curious, since with this routine, you effectively can have a trigger run as many triggers as needed, but, what I see as a problem, is if the 2nd trigger routine modifies NewREC, it will overwrite any modifications that the first trigger may have made to NewREC (assuming a BEFORE trigger). I guess you could assign a temp varible to oldrec, then for each iteration make oldrec = newrec, but then each successive trigger wouldn't have the original data to go by. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, July 13, 2009 3:24 PM To: 'U2 Users List' Subject: Re: [U2] which files have triggers Hi George I wrote about this in one of the back issues of Spectrum (you can download these from www.intl-spectrum.com). I use a master trigger that reads a list of sub-triggers based on the file name. Okay it's an extra read, but it's worth it: the list of sub- triggers (which have the same calling arguments) are all called using regular Call @ syntax; and it allows you to swap in and out sub-triggers without having to drop the main trigger, log everyone off, and recreate it. Since I first wrote that for a 24x7x365 site, that wasn't an option. Also, because UniVerse caches subroutines in memory, it means that when you recompile any changes you want to change the name e.g. MySubTrigger.1, MySubTrigger.2 and so forth. Then change the name in the sub-trigger list(s) when you are sure you've tested it. Brian ___ 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 and triggers
If I remember correctly in Prime Information if you used a return in a subroutine it returned to the calling program but if you used a stop it stopped. I have also seen it happen in UV when running a program from Proc. I don't remember how it happened but after converting the program from stop to return I didn't have a problem with it anymore. After that happened I just started using returns all of the time when I built a new program. Jerry -- From: Anthony W. Youngman u...@thewolery.demon.co.uk Sent: Sunday, July 19, 2009 10:29 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV and triggers In message 4a63297f.2030...@comcast.net, Charlie Noah cwn...@comcast.net writes John, I can't believe you're recommending this. The only reason Universe treats a RETURN as a STOP in a top-level program is that Universe tries to be everything to everyone, forgiving mistakes and blunders, and trying to determine what the user really wanted, no matter how badly the code is written. In 1998, we converted from Universe to Jbase, and you can't imagine all the problems we had fixing bad Universe code that worked (sort of) so that it would work in a system that requires you to do things correctly. When coding and breaking rules, you have to consider that the code may be migrated someday. This is a case of just because you can, doesn't mean you should. I doubt that's the case ... STOP may mean stop, but RETURN means go back one level. So RETURN makes perfect logical sense even in an outer program... I'm not talking about using the strengths of your particular implementation even though they are unique to your implementation, just doing dumb things that will bite you (or your predecessor) down the road. I put program in quotes in my last paragraph, because I'm not even sure all variants of BASIC accept the PROGRAM keyword! Certainly in my early days programming PI I never used it, and I *think* the reason I didn't was because it didn't exist in INFOBASIC. iirc it was added at the same time as the FUNCTION keyword. So I wouldn't say John is recommending you use return, I'd say RETURN *always* works because subroutines should always end in a return, and at one time everything BASIC was a subroutine. Oh - and I think PROGRAM and SUBROUTINE are actually synonyms as far as the compiler is concerned :-) Just my 2 cents worth. And my tuppence. Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk '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 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] Converting from mvBase to Universe
Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product. The only significant difference between mvBase (and all other generic Pick databases for that matter) and Universe is that Universe does not support the generic Pick print spooler for assigning user print output to a queue and assigning a printer to the same queue to enable the printing of the print job to the printer, and all the other features of holding and spooling print jobs to selected printers. None of the generic Pick print spooler commands are available to perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPEQS, SP-EDIT, etc. So all embedded SP-ASSIGN commands have to be converted to SETPTR commands, new print procedures have to be developed and all users have to be retrained in using a much less robust print architecture than they're used to using. AD To bridge this gap in functionality, we developed SpoolerPlus, a generic Pick print spooler, that runs on Universe, Unidata and QM, to provide the generic Pick print spooler commands and functionality built into software migrated from generic Pick databases. I will be pleased to send you some infomation about SpoolerPlus if you wish./AD. Also, please feel free to ask any specific questions about minor differences between mvBase and Universe and I'll be glad to answer them if I can. Best wishes for a successful conversion, 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: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 2:43 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ 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
Re: [U2] Converting from mvBase to Universe
I'm sorry if I wasn't clear. After looking at what I wrote I can see why but I think you answered my question. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: Monday, July 20, 2009 12:10 PM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe I'm not sure what you're asking, Jerry, but this may help. The SP-ASSIGN commands differ in syntax between the generic Pick print spooler and the Reality spooler, as follows: Ex. (PickR syntax): SP-ASSIGN (options) (copies) F(queuenumber), R(printfilenumber) Ex. (RealityR syntax): SP-ASSIGN = (queuename) (options) (copies) AD SpoolerPlusR supports both of these forms of the SP-ASSIGN command./AD Universe has its own form of SP.ASSIGN (SP-ASSIGN works also) command, and their syntax is slightly different for Universe/nix vs Universe/doz platforms and is unlike both the generic Pick and Reality syntax above. I don't know if there is a difference between the syntax of the Universe SP-ASSIGN command in a Pick-flavor account vs in a Reality-flavor account on the same operating system. There is no indication in the IBM documentation of such difference based on the flavor of the account. In Universe/nix: the documentation states Use SP.ASSIGN to set the line printer spooler options for each of the 256 logical print channels. In Universes/doz: the documentation states Use SP.ASSIGN to set the line printer spooler options for Windows platform. These differences are due to the fact that Universe/nix does have a spooler that provides some ability to manage and control print jobs other than just print them to the printer, where as Universe/doz has no spooler whatsoever and prints directly to the doz printer, after which ofcourse you lose all control over the print job from Universe. In both cases, regardless of the platform, Universe prints to printers, not to queues, and does not support the print architecture used in both Reality and in other generic Pick databases (which afterall began with Reality) of printing to queues and then printing from queues to printers, including all the flexibilty of holding/suppressing/both any print job, redirecting a print job from one printer to another, using the same printer for multiple print jobs with time to change paper before changing queues, listing and managing all print jobs on hold, etc. AD Changing the printing practices of an entire organization, including rewriting printing procecedures, retraining personnel, expanding the number of printers and serial/network connections and network support necessary to implement a far less powerful and flexible print architecture is usually far more costly than the license fee for a complete generic Pick print spooler solution like SpoolerPlus./AD If I didn't anwer your question, please rephrase it so maybe I'll understand it. 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: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Monday, July 20, 2009 9:23 AM Subject: Re: [U2] Converting from mvBase to Universe Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you
Re: [U2] UniBasic - Multiple Accounts
I haven't been following this thread so excuse me if 'm off in left field, but, wouldn't it be better just to set up a file pointer in the VOC that points to where you want to write rather than setting up an entire account and logging to it before you write? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, July 21, 2009 1:52 PM To: U2 Users List Subject: [U2] UniBasic - Multiple Accounts Does it make any sense to . execute LOGTO UPS open 'UPS' to F.UPS else null . write R.UPS to F.UPS... . . execute LOGTO METAL open 'PACK.SLIPS' to F.PS else null . write R.PackSlip to F.PS... Our visiting UPS tech support rep (Ralph Sorrano) suggested creating a new account with a single file in it. Thus, the UPS WorldShip desktop software would not be overwhelmed with hundred of files upon launch. I have not tried it yet. Perhaps there is a better way. Suggestions 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] Universe just quits
Sounds like a job for indexing. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 4:54 PM To: U2 Users List Subject: Re: [U2] Universe just quits Barry: Thanks for resonding. The main activity is running thru text files (narratives), identifying the next word then updating a file (DEXNAR) used to cross-reference all the words. For example, in record ABC123 in the narrative field the next identified word is DECOMPOSING. I read the record DECOMPOSING from the DEXNAR file. The record DECOMPOSING has 10 lines in it, because 10 other prior narratives had the word DECOMPOSING. The program seeks the current record key (ABC123) in the fields using the LOCATE command. If not found, the key ABC123 is appended to the end of the DECOMPOSING record and DECOMPOSING it is written out, now with 11 fields. Some of the records in DEXNAR get long as they are for fairly common words, like ALIAS. (The most common words I do not bother to cross-reference, of course, like the word THE). Thus, the LOCATE is looking thru an ever increasing number of fields as we go along. Some records currently have over 11000 fields. Is that the problem? Maybe the sytem tries to 'fit' the next very long record in memory to do the LOCATE and it overflows something? The dropping out, however, occurs normally after updating 25000+ records. Shorter runs seem to 'hold out'. What might be building up in memory space? These are also overnight runs, typically, so there are fewer users to contend with making it unlikely that it's exceeded limits for all users, I would think. The point of the cross-reference file is to allow users to quickly search thru all the 700,000 available (crime) narratives for the ones that match a set of entered search words. Searching that many narratives using brute force would probably take 5+ minutes for each search on our system, which would really stifle the crime analysts. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, July 21, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] Universe just quits Can you elaborate a little on these tasks Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 2:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should look at? A unix kernal parameter? Any ideas appreciated. Thanks- Harold Oaks Sr. Analyst/Programmer Clark County Information Systems Clark County, Washington ph: (360) 397-6121 x4132 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 21/7/2009NOT 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,
Re: [U2] FW: Universe just quits
It also cleans the session up and leaves a system message (050005) in the errlog file of the uv folder so you can track who has been leaving their sessions active. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, July 22, 2009 7:20 PM To: 'U2 Users List' Subject: Re: [U2] FW: Universe just quits Harold, Is there any reason you don't use the UV command AUTOLOGOUT to time out idle sessions? It does what you want already from within UV already (and can be setup individually or globally for all UV sessions) and doesn't have the problem of just looking at terminal keyboard input idle time like the UNIX who command does. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, 23 July 2009 7:01 AM To: U2 Users List Subject: Re: [U2] FW: Universe just quits Thanks to all who made suggestions. I'm definitely going to use some of them to improve processing. Good news: Universe is not at fault! So why did the process just end? Because a background process we run logs out processes idle for more than 3 hours. To determine idle time we check the 7th column of the output from the unix command who -HTR. Here was the surprise for me: even though the process was furiously performing I/O, as far as that unix command was concerned, it was idle. Oops! Easy to fix that, of course. The best parts of this were that UniVerse came through as more robust than I had worried it wasn't, and that contributors gave me some great advice. Thanks again to all. Harold Oaks ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV on Windows
We are setting up a networked UniVerse Windows 2008 server for future use and coming from a long line of 'Nix processing systems I have some questions about how database administration is handled from those that use a Windows system. The users will all be entered through the network so I know I won't have to worry about doing that any more but what about the other things like file administration? I already know that there is no spooler anymore. Do you use the UniAdmin much or is everything done from the command line? Do you use a separate database administrator login to do database administration or do you have to be the system administrator? The network administrator wants to, understandably, lock the system down as tightly as possible without shutting down the business so how far do you go? When resizing files do they carry the same properties over or do they have to be reset? For those that have moved from Linux to Windows, did you have to change any configuration settings? I tested a short program that was recently bench marked by several people on this list, building a dynamic array, and I was really surprised by the difference in the speed between the various times reported and also my own testing of our current Linux server and the new Windows server (0.6 seconds as opposed to 35 minutes). I reported the difference to my VAR and they sent the results on the IBM. I'm thinking, hoping, that we will just need to change some of the environment variables. I know I can ask my VAR these questions but I want to get more of a consensus from the list. Please let's not get caught up in the 'Nix/Windows battle J. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SBClient 5.3.8 on 64 bit vista
Accuterm has device licensing too. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Friday, August 21, 2009 10:34 AM To: U2 Users List Subject: Re: [U2] SBClient 5.3.8 on 64 bit vista Thanks Steve. I tried running Accuterm and a few other wyse60 emulators but I was getting errors from system builder. I forgot to mention that we have device licensing which is one of the reasons I need to use sbclient. Thanks again. Jeff Steve Romanow wrote: Jeff Powell wrote: I have a user who needs to work from home with his Vista PC. We are having trouble installing sbclient on this machine it is saying this program is not compatible with 64 bit. Has anyone made sbclient 5.3.8 work on a 64 bit vista machine? If not what can I do for this user. We are running Unidata 7.1 with SystemBuilder 5.3.8. We only use character mode. Thanks. Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Does he use smart query or any dde transfer capability? If not, you can use other clients with SB+. I personally use Putty (on windows and linux) but pretty much any terminal emulator will work (with enough tweaking.) I have TERM.DEFN records for VT100, VT220, and wy60 if you want to tinker. It is a pretty painstaking process, most times you will find that for each offering, almost everything works, but different things broken with each one. Things to check are F1-F4, F11 and F12 for insert and delete. Backspace and Delete compatibility. All of this is easier if you do not require 16-color. I have color working with mine, but it takes out half the work if monochrome is satisfactory. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Error UV 10.2.4 Reality flavor
I was wondering if any of you have an answer for this problem. We are trying to connect to our test box using ado.net and getting errors. In visual studio we are getting the messages: An error occurred while connecting to the database. The database might be unavailable, An exception of type 'System.Data.ProviderlncompatibleException occurred. The error message is: 'The Provider Manifest is incorrect. File Unknown(399,6): error 0019: Function 'DB2.LEFT with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(427,6): error 0019: Function 'DB2.LOwER' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(441,6): error 0019: Function 'DB2.LTRIM' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(484,6): error 0019: Function 'DB2.REPLACE with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown (501,6): error 0019: Function 'DB2.REPUCATE' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(515,6): error 0019: Function 'D82.REVERSE' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown (530,6): error 0019: Function 'DB2.RIGHT' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown (544,6): error 0019: Function 'D82.RTRIM' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(603,6): error 0019: Function 'D82.STUFF with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(647,6): error 0019: Function 'DB2.UpPER' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous.. On the Universe side I am getting the following in the runtime errlog: Wed Aug 26 12:00:25 -11765 root Program *HS.OLEDBINFO: Line 431, Message[0400 24] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 652, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 653, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 653, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 654, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 662, Message[0400 36] And repeats from there. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] What ever happened...
Whatever happened to the Toucan? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hmmmm...Learn something new every day!
You can tell it's Friday :-) Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steven M Wagner Sent: Friday, September 04, 2009 3:56 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! And a fine PERFORMance you are providing us. . . . . -- Sent from my Palm Pre George Gallen wrote: I wonder if you use EXECUTE without any CLAUSES, the compiler converts it to a PERFORM? sounds like I'm anti-Santa hereEXECUTING CLAUSES! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, September 04, 2009 4:33 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! But the question is, why does removing the CAPTURING CLAUSE fix the problem (allow passing the data). with the CAPTURING, user0 won't pass without the CAPTURING, user0 passes fine I thought PERFORM and EXECUTE were the same? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, September 04, 2009 4:30 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! EXECUTE creates a new environment, try PERFORM. From BASIC Help: EXECUTE creates a new environment for the executed command. This new environment is initialized with the values of the current prompt, current printer state, Break key counter, the values of in-line prompts, KEYEDITs, KEYTRAPs, and KEYEXITs. If any of these values change in the new environment, the changes are not passed back to the calling environment. In the new environment, stacked @variables are either initialized to 0 or set to reflect the new environment. Nonstacked @variables are shared between the EXECUTE and calling environments. Tom ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users