RE: Avante Job Scheduler
I am pretty sure the Scheduler only works in Avante Release 9.3.5. Alan Bateman EVOLUTION Software Services Pty Ltd solutions for changing needs 4-10 Bridge Street PYMBLE NSW 2073 Phone : (02) 9497 4340 Mobile : (0417) 685 246 Fax : (02) 9497 4370 E-mail : [EMAIL PROTECTED] Web : www.evoss.com.au http://www.evoss.com.au The information contained in this e-mail is intended only for the named recipient(s) and may be confidential and/or privileged.Unauthorised use or reproduction (including storage or re-distribution) is prohibited. Except as required at law, Evolution Software Services Pty Ltd does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Raven Sent: Wednesday, 4 February 2004 4:29 AM To: [EMAIL PROTECTED] Subject: Avante Job Scheduler I am looking for the Avante Job Scheduler Manual or instructions on how to use it or ... if it works at all. Haas Automation Inc. Dave Raven Mobile(949) 228 2224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UCI Error
Ah, forgot to ask what your uvodbc.config (or is called uci.config in UV 10.x?) file looks like on the client side (your Oracle server). On one of our client servers the uvodbc.config has this section at the end of the file... these parameters are documented in the UCI manual (somewhere). [UNIVERSE] MAXFETCHBUFF = 32768 MAXFETCHCOLS = 1000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Wednesday, February 04, 2004 5:04 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? UniVerse version - 10.0.6 OS version? UniVerse Box OS - HP/UX 11.0 What is the different server? Oracle Box OS - HP/UX 11.0 Does this query complete from the TCL prompt on the UV server? YES -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 9:32 PM To: 'U2 Users Discussion List' Subject: RE: UCI Error UV version? OS version? What is the different server? Does this query complete from the TCL prompt on the UV server? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Sidhu Sent: Tuesday, February 03, 2004 10:11 AM To: 'U2 Users Discussion List' Subject: RE: UCI Error Does anyone know if there is some time out variable in Universe that would cause this or maybe something that kicks my connection after a certain time (only a couple minutes) or kicks me due to memory faults? I'm connecting from a different Server to the Universe Server. I've never worked with Universe before so anything would help, Thanks, Dave -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 3:03 PM To: U2 Users Discussion List Subject: RE: UCI Error Hi David, The docs say IM985 Error in RPC interface I think I would be checking the network and/or ensuring your rpc daemon is still running. The error 81002 is a universe system error ED SYS.MESSAGE 081002 The file SYS.MESSAGE is read-only and cannot be updated. 2 lines long. : P 0001: unirpc: No Connection 0002: Bottom at line 2. : EX Hope this helps Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Sidhu Sent: Tuesday, 3 February 2004 9:23 AM To: 'U2 Users Discussion List' Subject: UCI Error Anyone know what this error is when using UCI? I got it after running a query numerous times with different id's. I checked the sql statement and the ID both are correct. Just after a four thousand iterations I get this error. ERROR!! SQLExecDirect Died in SQLExecDirect with SQLSTATE IM985 Native error: 81002 [IBM][SQL Client][RPC] error code = 81002 The Query is simply: SELECT A.MEM.ID, A.REG.BEG.DT, A.REG.END.DT, A.GROUP FROM MEM.REG.HIST A WHERE A.MEM.ID = 'X*01'; Where the X's is the id number. Thanks, Dave ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[ADMIN] Why multiple digests, and a lecture on Netetiquette
Greetings, All. I have received some inquiries as to why the new list server will sometimes send out two digests in one day. The digest normally is generated at 23:55 PST (USA). However, sometimes the volume of the postings is such that the digest can get huge. When that happens, not only does it take a long time to send them all, but some people do not get them; their mail service limits the size of incoming messages. So I have a threshold of 300KB set. During the day, if that is reached, it will kick off a digest at that point in addition to the one that goes out at night. Notice that I said volume of the posts, not number of posts. What causes this volume in most cases? OVER-QUOTING. When you hit Reply, add a couple of lines at the top of the message, and do not bother to delete all but the most relevant lines of the most recent message, you contribute to the problem. There is no reason to be constantly quoting the entire thread. Even worse is the quoting and re-quoting of all of the footer garbage that HR departments tack on to email these days. (Or that list servers like this one add for identification, to be fair.) The general (very general) guideline of netiquette is that you should quote only about four lines of the most recent post for each point to which you are responding. If you are replying to several points, do not top-post. Quote four or five lines, add your point, quote some more, add your point, etc. (There are many lists where you will get yelled at by the Moderator, as I found out the hard way, for even top-posting at all. This list is not one of those. :-) 'Nuff said. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Help wanted creating an efficient SELECT statement
Hi All, I have a file with IDs like this: 1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ... Each ID is N.X where X is a numeric secondary ID number from 1 going upwardsand N is the primary ID number which may or may not be numeric.Different primary IDs have a different number of secondary IDs. For a certain report, I want to select only the records with the highest numerical value of X for each of N. For the above example, I want to end up with 1.3, 2.4, 3.1, 4.1, 5.2, Can aSELECT statement(s) be composed without having to write a program? If not what would be the best approach. Thanks for any help. Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VARIABLE-1 = '' Inconsistent behaviour
For what it's worth, the Arev knowledgebase has a great article on optimising BASIC code (for speed!), which mentions that the -1 concept is the slowest structure. Admittedly we have processors that thrash these things out in milliseconds today, but for the purist... The A = A : newvalue : @fm process is (to quote Andrew McCauley) 20-30 times faster dennis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 04 February 2004 03:06 To: [EMAIL PROTECTED] Subject: RE: VARIABLE-1 = '' Inconsistent behaviour -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) To nitpick - but it catches out a LOT of people - SAMBA is NOT NOT NOT the appropriate software here. It will NOT do what you claim. Samba allows Windows boxes to access a unix server (and allows that server to join a Windows domain). If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: 03 February 2004 21:49To: 'U2 Users Discussion List'Subject: RE: Document scan and retrieval (looking for software) Could also have the PC that is scanning save to a specific directory. then have a program monitor that directory for new entries, read them, encode them and save them somehow then the saved filename would have be linked into the system. I'm just using pcpaint as an example of a program that might be able to read directly from a scanner and save in .jpg/.bmp format. If volume is high, and a number of scanners are being used, then have one central PC share it's directory and each scanner saves to that directory. Since the directory is shared, you could even have unix system running SAMBA monitor the directory (thus bringing unix into the picture). The only drawback to having unix in the setup is that it is more difficult to have unix bring up IE on a PC. But that could be gotten around if you run a lpr/lpd daemon on the PC which can then take a print job and pass it to a program (ie. RPM www.brooksnet.com). or use a PC with rsh daemon that would allow the unix system to send the launch command to the PC. or even a small custom PERL socketed program on the PC which could listen for a command and launch IE. Depending on the $$ wanted to be spent. I don't think a having the image be a type 1/19 file would be good, unless it's base64 or mimeencoded, as you could have char(255)'s imbedded in the image. George *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help wanted creating an efficient SELECT statement
You can get part way there through SQL, though you cannot (sadly) capture an SQL SELECT to a select list if it contains a GROUP BY clause. So here is a kind of work-around using a scrudgy bit of a program. I'm sure someone can come up with something better, but this is what first came to mind :-) 1. Create dict items for ID (@ID right justified) andMAIN (@ID[".",1,1]). 2. In a program: TCL = "SELECT MAX(ID) FROM yourfile GROUP BY MAIN COL.SUP COUNT.SUP;" Execute TCL, OUT. Text Convert " " To "" In Text ;* remove leading spaces Text = [EMAIL PROTECTED], 3, DCount(Text,@FM)-3] ;* remove leading and trailing blank lines Open "SAVEDLISTS" TO FL Then Write Text On FL, "MyList" End CHAIN "GET.LIST MyList" Hope this helps, Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco ManyevereSent: 04 February 2004 08:20To: [EMAIL PROTECTED]Subject: Help wanted creating an efficient SELECT statement Hi All, I have a file with IDs like this: 1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ... Each ID is N.X where X is a numeric secondary ID number from 1 going upwardsand N is the primary ID number which may or may not be numeric.Different primary IDs have a different number of secondary IDs. For a certain report, I want to select only the records with the highest numerical value of X for each of N. For the above example, I want to end up with 1.3, 2.4, 3.1, 4.1, 5.2, Can aSELECT statement(s) be composed without having to write a program? If not what would be the best approach. Thanks for any help. Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV SELECT Info Display
Mark, This is probably too late, but FYI it's EXPLAIN Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: 03 February 2004 21:59 To: 'U2 Users Discussion List' Subject: UV SELECT Info Display Brain FreezeWhat's the Keyword you enter at end of SELECT statement to display the Index info it's using? TIA -__ This e-mail, including any attachments, may contain information that is protected by law as privileged and confidential, and is transmitted for the sole use of the intended recipient. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying or retention of this e-mail or the information contained herein is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by telephone or reply e-mail, and permanently delete this e-mail from your computer system. Thank you. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help wanted creating an efficient SELECT statement
This is a bit messy ... Firstly create an i-descriptor as follows 0002: FIELD( @ID, ",", 1, 1); FIELD( @ID, ",", 2, 1)+1; TRANS( @FILENAME, @1:".":@2, 0, "X") (I think I've got that right...) What it's doing is adding 1 to the X bit, and doing a trans to see if the record exists. If I've got it right, this i-descriptor should return the next id if it exists, and null if it doesn't. So just select with this thing equal to null. Of course, it'll be fooled if you have a non-sequential X list. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco ManyevereSent: 04 February 2004 08:20To: [EMAIL PROTECTED]Subject: Help wanted creating an efficient SELECT statement Hi All, I have a file with IDs like this: 1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ... Each ID is N.X where X is a numeric secondary ID number from 1 going upwardsand N is the primary ID number which may or may not be numeric.Different primary IDs have a different number of secondary IDs. For a certain report, I want to select only the records with the highest numerical value of X for each of N. For the above example, I want to end up with 1.3, 2.4, 3.1, 4.1, 5.2, Can aSELECT statement(s) be composed without having to write a program? If not what would be the best approach. Thanks for any help. Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unix - Windoze Account(s) Move
I'm attempting to build up an archive copy of our finance system on Windows XP (Professional). The app normally runs on an HP Unix machine. So far I've been able to move the files, run fnuxi on them and gain rudimentary access to the data from the command prompt. What has me a bit stumped is that the application itself consists of several accounts full of little subroutines that don't seem to be linked in correctly. Is there a magic program that will fixup things like cataloged programs when an account is moved from Unix to Windoze?? Or should I go through each and every account and fix these myself? Thanks, -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COM Exception
Gene, More information needed, I'm afraid. What are you actually using to access UniVerse: is it UniObjects, UniOjbects for Java, ODBC, OleDB ? Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene W. McDonald Sent: 04 February 2004 13:55 To: [EMAIL PROTECTED] Subject: COM Exception I am new to the list and I have search the archives without finding a result. SO I apologize, in advance, if this is 'old hat' for some of you. I am in a situation where we are moving from D3 to Universe. I have written a VB.Net application which will interact with D3 or with Universe depending upon the value of a switch. I have been successful in setting up the application to run in a distributed environment (forgive me if that is the wrong term, the executable and the supporting dll's reside in a centralized drive on the server and are accessed by the users via a shortcut. The intention being that when I make mods to the executable I do not have to reditribute it to each user PC). ANyway, the application runs fine when accessing the D3 server, but when I try to access the Universe server, I get the following error: System.Runtime.InteropServices.COM exception (0x80040154): COM object with CLSID {blah blah blah} is either not valid or not registered. at ISOComplaintLog.ISOForm.Connect_To_UV() at ISOComplaintLog.ISOForm.Build_Employee_List_UV() at ISOComplaintLog.ISOForm..ctor() Does anyone have any suggestions or ideas? Thanks, Gene -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: Re: [UD] Determining if list exists
At 06:34 PM 02/03/2004, you wrote: Goo'day, Are you sure the IF E = 401 bit works in UV? This would not work within UV unless proc had been rewritten (doubtful). The error handling within uv is different and this is one of those areas affected by that difference. You can only test IF E or IF #E. AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick flavo*u*r. Yep. The 401 bit is vanilla Pick, which I remember we had to change on conversion to UV back in 9.3???. Dunno about UD, though At 10:06 04/02/04, you wrote: In a proc you would have: PQ HSELECT SOMEFILE SAMPLE 3 P IF E = 401 G 99 HLIST SOMEFILE P 99 O No Items Selected __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COM Exception
I am sorry... I am using Uniobjects and the code is written in Visual Basic, VB.Net is would say is more appropriate. -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 8:15 AM To: 'U2 Users Discussion List' Subject: RE: COM Exception Gene, More information needed, I'm afraid. What are you actually using to access UniVerse: is it UniObjects, UniOjbects for Java, ODBC, OleDB ? Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene W. McDonald Sent: 04 February 2004 13:55 To: [EMAIL PROTECTED] Subject: COM Exception I am new to the list and I have search the archives without finding a result. SO I apologize, in advance, if this is 'old hat' for some of you. I am in a situation where we are moving from D3 to Universe. I have written a VB.Net application which will interact with D3 or with Universe depending upon the value of a switch. I have been successful in setting up the application to run in a distributed environment (forgive me if that is the wrong term, the executable and the supporting dll's reside in a centralized drive on the server and are accessed by the users via a shortcut. The intention being that when I make mods to the executable I do not have to reditribute it to each user PC). ANyway, the application runs fine when accessing the D3 server, but when I try to access the Universe server, I get the following error: System.Runtime.InteropServices.COM exception (0x80040154): COM object with CLSID {blah blah blah} is either not valid or not registered. at ISOComplaintLog.ISOForm.Connect_To_UV() at ISOComplaintLog.ISOForm.Build_Employee_List_UV() at ISOComplaintLog.ISOForm..ctor() Does anyone have any suggestions or ideas? Thanks, Gene -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memo: Re: [UD] Determining if list exists
I realize the context of the original reply was a PROC, but for the sake of completeness, you can also handle it within a paragraph. Check @SYSTEM.RETURN.CODE. SELECT SOMEFILE WITH F1 EQ XYZ IF @SYSTEM.RETURN.CODE LT 1 THEN GO NONE.SEL Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED]-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV command failing mystery
The 'uv' command is basically a small front ender to the 'uvsh' executable, which is really the guts of universe. The uv command does little more (for universe) then to check ulimit settings, increasing them when necessary, then issuing an execve() call to uvsh. If you bypass 'uv' and just use 'uvsh', does the problem still occur? Your universe configurables seem reasonable, as well as your kernel params, but I do recall an issue whereby the OS would disallow exec's (and /or forks) due to system resource exhaustion, although it has been a while and I cannot recall the details. At 05:23 PM 02/03/2004, you wrote: We are having a very strange intermittent problem with the UV command not working from Unix. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UDT SELECT optimization
Title: Message i seem to remember this way of thinking from the "old" days too, but i thought that all of the newer sql based command parser / optimizers didn't care what order you put things in .. they made sure to do the filter part first, and then the sort part .. i was hoping that this way of thinking naturally made it's way into u2 .. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Dennis BartlettSent: Wednesday, February 04, 2004 8:46 AMTo: 'U2 Users Discussion List'Subject: RE: UDT SELECT optimization I've always thought that a SELECT that reduces the results first then SORTS would be quicker, eg SELECT ORDERS WITH DATE = "01/01/04" BY TIME where WITH DATE = "01/01/04" is what reduces the results and BY TIMEis the selection criteria based on the logic that the reduced list would be quicker to sort... Dunno where I picked up this thought process, but I am from a Prime / R83background. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark JohnsonSent: 03 February 2004 02:34To: U2 Users Discussion ListSubject: Re: UDT SELECT optimization Cached in memory is correct as well as the second statement will only have to process fewer records if the WITH was done in the first. Breaking up a SELECT statement into 2 parts may be advantageous, regardless of caching, if there are multiple ANDed WITH clauses and one or more of them involve translates. For example: SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" AND WITH PERIOD = "199910" would be faster as SELECT HUGE.ARCHIVE.FILE WITH PERIOD = "199910" then SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" assuming that CUST.ZIP is translated and the PERIOD is a local field. Note the SSELECT in the second statement as well. I've often wondered if, when using consecutive ANDs the filter processor skips the record if the first WITH is false. Why bother testing the second field if both are ANDed. my 1 cent. - Original Message - From: Brian Leach To: 'U2 Users Discussion List' Sent: Monday, February 02, 2004 11:24 AM Subject: RE: UDT SELECT optimization Chuck, The order should be immaterial ( it is on every other database I can think of ). Just be aware that if you test it byissuing the commands one after the other, the second may may complete quicker, simply because the file may be cached in memory. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck MongioviSent: 02 February 2004 16:16To: U2 Users Discussion ListSubject: UDT SELECT optimization Does anyone know whether one of these two statements is faster? SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE Does the parser / optimizer (if there is one) do the filter portion of the statement first regardless of the order that you build it in or does it do things EXACTLY in the order that you enter them on the command line? -ChuckThis email was checked by MessageLabs SkyScan before entering Microgen.This email was checked on leaving Microgen for viruses, similarmalicious code and inappropriate content by MessageLabs SkyScan.DISCLAIMERThis email and any attachments are confidential and may also beprivileged.If you are not the named recipient, please notify the senderimmediately and do not disclose the contents to any otherperson, use it for any purpose, or store or copy the information.In the event of any technical difficulty with this email, pleasecontact the sender or [EMAIL PROTECTED]Microgen Information Management Solutionshttp://www.microgen.co.uk ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ADMIN] Why multiple digests, and a lecture on Netetiquette
Cool, saving bits - most of us over 40 grew up doing that ;-) -dawn PS Video attachment omitted -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) "Included with" and "part of" aren't the same thing. That's why the samba teamdumped smbclientfrom the samba package! (but put it back when too many people moaned.) By the way - "smb" is an IBM acronym for "Server Message Block" so even the fact that the names are similar is no evidence that they are part and parcel of the same thing. They just happen to have the same ancestor way back, like a load of your cousins share the same surname as you ... Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff SchasnySent: 04 February 2004 15:32To: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) Actualy smbclient is part of samba and works quite nicely in reading and writing to windows shares. smbmount is only available on linux samba installs.If someone would like a couple UVBasic programs to "put" and "get" via smbclient I'd be glad to send them along. -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED] If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Document scan and retrieval (looking for software)
George, When did 'google' become a verb? I'm not objecting to your use - I say it, too. I'm just not sure when we started verbing that noun. - Charles 'I was an English Major In College and Look What Happened' Barouch George Gallen wrote: RE: Document scan and retrieval (looking for software) I thought smb was simple message block? I haven't googled it, just from memory... George -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 04, 2004 11:04 AM To: U2 Users Discussion List Subject: RE: Document scan and retrieval (looking for software) "Included with" and "part of" aren't the same thing. That's why the samba teamdumped smbclientfrom the samba package! (but put it back when too many people moaned.) By the way - "smb" is an IBM acronym for "Server Message Block" so even the fact that the names are similar is no evidence that they are part and parcel of the same thing. They just happen to have the same ancestor way back, like a load of your cousins share the same surname as you ... Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jeff Schasny Sent: 04 February 2004 15:32 To: U2 Users Discussion List Subject: RE: Document scan and retrieval (looking for software) Actualy smbclient is part of samba and works quite nicely in reading and writing to windows shares. smbmount is only available on linux samba installs.If someone would like a couple UVBasic programs to "put" and "get" via smbclient I'd be glad to send them along. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED]] If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) Could be. Whatever it is, it's ancient history :-) You know Tridge originally wrote samba to communicate with DecNET, and was surprised to discover that it could be used to communicate with MS too? When his company retired the PDPs or Vaxen (can't remember...) he was going to drop it and was surprised when users said not to! Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: 04 February 2004 16:06To: 'U2 Users Discussion List'Subject: RE: Document scan and retrieval (looking for software) I thought smb was simple message block? I haven't googled it, just from memory... George -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 11:04 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) "Included with" and "part of" aren't the same thing. That's why the samba teamdumped smbclientfrom the samba package! (but put it back when too many people moaned.) By the way - "smb" is an IBM acronym for "Server Message Block" so even the fact that the names are similar is no evidence that they are part and parcel of the same thing. They just happen to have the same ancestor way back, like a load of your cousins share the same surname as you ... Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff SchasnySent: 04 February 2004 15:32To: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) Actualy smbclient is part of samba and works quite nicely in reading and writing to windows shares. smbmount is only available on linux samba installs.If someone would like a couple UVBasic programs to "put" and "get" via smbclient I'd be glad to send them along. -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED] If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol***This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system.Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.*** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV command failing mystery
Thanks for the suggestion. We will try uvsh the next time we have the failure. Last night we had the problem occur for 50 mins. Because it continued for so long we were able to have users in our various locations make multiple attempts to login from multiple PCs. Surprisingly, some locations claimed they could not login at all, others claimed that some PCs could be logged in while other could not. Either our assumption that the problem affects all users is false or the problem occurred many times but each time for only a short period of time. Once again users already in Universe noticed no problems and no unusual locks we noted when we used the command list.readu every. analyze.shm -s does not show any unusually high numbers of Collisions. Are there any log files we should be checking? We are more puzzled than ever. Vance Dailey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert Sent: Wednesday, February 04, 2004 10:13 AM To: U2 Users Discussion List Subject: Re: UV command failing mystery The 'uv' command is basically a small front ender to the 'uvsh' executable, which is really the guts of universe. The uv command does little more (for universe) then to check ulimit settings, increasing them when necessary, then issuing an execve() call to uvsh. If you bypass 'uv' and just use 'uvsh', does the problem still occur? Your universe configurables seem reasonable, as well as your kernel params, but I do recall an issue whereby the OS would disallow exec's (and /or forks) due to system resource exhaustion, although it has been a while and I cannot recall the details. At 05:23 PM 02/03/2004, you wrote: We are having a very strange intermittent problem with the UV command not working from Unix. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) Guess that answers the what is...looks like it is...Server Message Block... George -Original Message-From: Jeff Schasny [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 11:16 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) Smbclient has been part of every samba release I've used (that would be all of them) since 1.2. The samba makefile compiles it along with smbd, nmbd, testparm, smbstatus, and lately winbind and smbtar as well as a few other things. At rev. 3.0 the team decided that in order to more closely emulate the syntax of the Windows environment they wouldinclude the "net" command syntax to perform the functions that smbclient had always provided. Oh yeah... if you would really like to get a nice overview of what SMB is and where it comes from you might try: http://www.samba.org/cifs/docs/what-is-smb.html -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 9:04 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) "Included with" and "part of" aren't the same thing. That's why the samba teamdumped smbclientfrom the samba package! (but put it back when too many people moaned.) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) they would intresting to see. Either offlist or onlist. George -Original Message-From: Jeff Schasny [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 10:32 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) Actualy smbclient is part of samba and works quite nicely in reading and writing to windows shares. smbmount is only available on linux samba installs.If someone would like a couple UVBasic programs to "put" and "get" via smbclient I'd be glad to send them along. -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED] If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Proc or Para
Procs are definitely a subject that will start a good debate. I don't think Procs offer any performance advantage at all. It does offer the ability to do things that are possible in paragraphs like PROCWRITES. That said, I personally have never been a fan of procs. I started out in the Pick marketplace as a programmer for a software company that had an R83 Pick based manf package and was just moving to Prime Information (yes, way back when dinosaurs ran wild). I had to opportunity to work on both coming from a neutral background. My reaction to Pick with the cryptic Procs over Information with it's online help and command stacker was you'd have to have some fascination with pain to prefer Pick. I am no fan of proc. I consider it a necessary skillset to support a few systems. Never would use it on Universe if I wasn't forced to. My 2 cents. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 12:38 PM To: [EMAIL PROTECTED] Subject: Proc or Para All, I am accustomed to using paragraphs. Some systems I work on rely on Procs for almost every task. The ProVerb guide mentions that Procs ...are a bridge from a Pick system to UniVerse, allowing those of you with Pick backgrounds to port Pick applications to UniVerse... and ...ProVerb is a good tool for minor programming tasks Is there a performance advantage to using one or the other? I realize this might be a touchy topic but it's one I've been wondering about for some time. the ProVerb manual makes it sound like procs were a migration tool of sorts. Regards, L. Slingford -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
kibbles and bits
remember TRON, it took him a while to figure out that floaty thing was a bit. That was really a neat movie as far as geeky terms go... George -Original Message-From: John Cassidy [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 12:44 PMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: Re: [ADMIN] Why multiple digests, and a lecture on Netetiquette Bits? You had Bits? All we had were1's. Uniary. And we were darn glad to have 'em. [EMAIL PROTECTED] 2/4/04 11:27:09 AM Back in my day, bits were smaller. We only had 0.5 and 1. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Proc or Para
At 12:38 PM 02/04/2004, you wrote: All, Is there a performance advantage to using one or the other? I realize this might be a touchy topic but it's one I've been wondering about for some time. the ProVerb manual makes it sound like procs were a migration tool of sorts. Paragraphs are only slightly more efficient than a proc for the simple reason that a line within a paragraph is first scanned for any inline prompting, then immediately handed off to the command line execution process, whereas a proc must first interpretively assemble the command line then, when the P command is found, hands it off to the command line execution process (which of course scans for any inline prompting). Think of a paragraph as simply a stack of command lines executed in order (albeit with some testing/branching logic). Think of a proc as... well.. cryptic... *S* With processor speeds being what they are today, I doubt very much that the minute speed differences matter much (IMO). The reason uv proc was considered a migration tool is that within the original implementation of uv, there was no pick support (only ideal and prime flavors). It was envisioned that people would migrate those nasty, cryptic procs (which by the way, I DO not consider nasty) to paragraphs. Only hitch was that paragraphs did not support all the functionality available with procs (jump backwards to labels, error handling, etc...) so a proc processor was created. Granted, it was not 100% compatible with Pick (see other thread related to proc error handling), but it certainly eased those migrations (i was involved in quite a few of them back in the 80s). Regards, L. Slingford -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: user group meeting January 21 (wed)
Mark, I am sorry that I could not make it to this meeting. Did the speaker give any verifiable trend information that was useful? Please stop at our display during the Spectrum show next month in Las Vegas and say hello to Mark Thomas and I. Best regards, Patrick Will Williams - Original Message - From: Mark Pick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 1:02 PM Subject: user group meeting January 21 (wed) Attention U2 users! Calvin Carr partner and publisher of Database Trends and Applications magazine and online services will be here (Southern California) next week speaking about MAJOR TRENDS IN THE MULTIVALUE MARKETPLACE An Executive Summary of the 2003 Multivalue Database and Application Survey. Database Trends and Applications and Unisphere Media LLC recently concluded the most extensive market research study of the multivalue database marketplace. Over 500 active multivalue database developers, resellers, and end-user participated in this comprehensive survey. 60 percent of the respondents represent end-user companies, about 25 percent are value-added resellers (VARS) and the rest are commercial software vendors. Respondents came from a wide range of industries, with large concentrations in manufacturing, financial services, and general services. For more information on this meeting please visit our website at www.cdbma.org -Mark Pick - CDBMA -- Unsubscribe: mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] Moderator : mailto:[EMAIL PROTECTED] Web-site : http://www.oliver.com/lists/u2 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Re: [UD] Determining if list exists
I think that the reason so many mv'ers don't like procs is they don't understand them. /snip HSSELECT AR WITH PAYMENT.DATE GE 2-9-04 STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR P snip\ I don't want to hurt anyone's feelings, but, this is almost funny. Why would you stack on just prior to the perform? Why would you stack on, carriage return then perform hushed? The idea is to load your output buffers, primary and secondary, and execute them. Sigh... I guess I'm one of the few left who even know what STON or STOFF does... Here's a test for you. Some psycho left this on your system, what does this proc do? PQ HGET STON HLIST STOFF H-LIST STON H VOC STOFF H BMN PW Bruce M Neylon Health Care Management Group -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Re: [UD] Determining if list exists
How about this one to end this thread? M S1 IH%1:U50BB: T %2,,+ IBP %1 H%1 P GO B -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Re: [UD] Determining if list exists
Now that is elegant ! :-) Bruce M Neylon Health Care Management Group Glenn Herbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/04/2004 02:09 PM Please respond to U2 Users Discussion List To:U2 Users Discussion List [EMAIL PROTECTED] cc: Subject:Re: Re: [UD] Determining if list exists How about this one to end this thread? M S1 IH%1:U50BB: T %2,,+ IBP %1 H%1 P GO B -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Migrating U2 data
Any pointers on what document explains how to move data from an old old UNIX U2 system to a new 10.0 Windows system? Thanks. Cyndi -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UD] Determining if list exists
Title: [UD] Determining if list exists I'm not sure if this is what your looking for, but here goes. Insert the statement IF # S GO 99 after the initial SELECT statement. If no items are selected, then the proc proceeds to label 99 which displays a message and exists the proc. This prevents the situation where you end up printing all transactions, if no items selected. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STONHP IF # S GO 99HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR X+ 99 CONo Items SelectedX+ Regards, Ian Renfrew - Original Message - From: Chris Bugosh To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:51 AM Subject: [UD] Determining if list exists Is there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt. I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR P Thanks for any suggestions you can give. Chris ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniDebugger in SB+
I was inspired by a recent post to take another swing at getting UniDebugger to work w/ our UD6/SB+5.2/HPUX system. I have scripted the login, and can open, edit, and compile code. However, when I try to run a program through UniDebugger, the output window shows - logging into Dual debugging session - - login completed - ...and nothing more happens. If I choose Session | Show Dual Session then I see where something tried to execute tty and received Not a verb Also, I've noticed that CTRL C is caught by the UniDebugger (which complains there is nothing selected). How can I interactively tell a program to break? Any suggestions? I'd really love to see this thing work, it would certainly be an asset. TIA, David Beahm -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniDebugger in SB+
Haven't used the Dual Session so can't offer any help on that but... Try Control T as the break key... -Original Message- From: David Beahm [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 5:13 PM To: U2-Users Subject: UniDebugger in SB+ I was inspired by a recent post to take another swing at getting UniDebugger to work w/ our UD6/SB+5.2/HPUX system. I have scripted the login, and can open, edit, and compile code. However, when I try to run a program through UniDebugger, the output window shows - logging into Dual debugging session - - login completed - ...and nothing more happens. If I choose Session | Show Dual Session then I see where something tried to execute tty and received Not a verb Also, I've noticed that CTRL C is caught by the UniDebugger (which complains there is nothing selected). How can I interactively tell a program to break? Any suggestions? I'd really love to see this thing work, it would certainly be an asset. TIA, David Beahm -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Determining if list exists
Title: Message Hi Chris, Why not just use the 'REQUIRE.SELECT' or 'SELECT.ONLY' keywords in your query? This will then only run if there is a select list present. The Uniquery manual documents this quite well. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATEREQUIRE.SELECT LPTR P Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Thursday, 5 February 2004 8:26 AMTo: U2 Users Discussion ListSubject: Re: [UD] Determining if list existsIf you really need to save the list; HDELETE-LIST ARLIST PH HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON HSAVE-LIST ARLIST PH IF # S G ERROR ROUTINE LABEL HGET-LIST ARLIST STON HLIST AR PAYMENT.DATE LPTR PH If you don't want an error routine, leave out the if # s. Bruce M NeylonHealth Care Management Group "Chris Bugosh" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/03/2004 08:51 AM Please respond to U2 Users Discussion List To: [EMAIL PROTECTED] cc: Subject:[UD] Determining if list existsIs there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt. I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H PH HLIST AR PAYMENT.DATE LPTR P Thanks for any suggestions you can give. Chris ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Windows 2000 ODBC connectivity problem...
I have the UniData 6.0 ODBC client software installed on a Windows NT 4.0 machine and a Windows 2000 machine. Setting up an System DSN ODBC profile on the Window NT box work just fine, however on the Windows 2000 machine, whenever I access the server drop down list box, there are no servers present even though I have several set up properly in the uci.config file. When I just manually type the server in and try to use the ODBC profile elsewhere, it doesn't work. I checked both machines and the uci.config file is identical on both machines (same path and content) and the registry key is consistent on both boxes as well. Registry Key: \HKEY_LOCAL_MACHINE\SOFTWARE\IBM\UniClient\UCI:UciCfgFile uci.config path: C:\IBM\UniDK\Config\uci.config Does anyone have any insight on this one? Any help you can give is greatly appreciated. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Migrating U2 data
Universe or Unidata? What version from? What version to? - Original Message - From: Cyndi Calvin To: [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 1:23 PM Subject: Migrating U2 data Any pointers on what document explains how to move data from an old old UNIX U2 system to a new 10.0 Windows system? Thanks. Cyndi -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Format Text in Output Data File
Title: Message By definition a .csv file is plain text. That means no formatting. Best thing you could do is to setup a macro in your spreadsheet to do the formatting you want after loading and parsing your .csv. HTH, Gordon Gordon J. GlorfieldSr. Systems AnalystMAMSI301-360-8839 -Original Message-From: Simon Adams [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 5:28 PMTo: [EMAIL PROTECTED]Subject: Format Text in Output Data File I am trying to format text outputted to a csv data file. I'm building a string of data and writing it out to a data file with 'comma' separation, line by line, and naming the outputted file with a ".csv" extension. Is there a way to format the text/data line(s), as "bold" or "italics" or "colour" etc. without using a third-party software ? Cheers, Simon. Australia.*This e-mail, including any attachments to it, may contain confidential and/or personal information.If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action based on the information contained within it.Please notify the sender immediately by return e-mail of the error and then delete the original e-mail.The information contained within this e-mail may be solely the opinion of the sender and may not necessarily reflect the position, beliefs or opinions of Salmat on any issue.This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems.For more information, visit our website at www.salmat.com.au.* Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Migrating U2 data
IBM actually has documentation on this. http://publibfi.boulder.ibm.com/epubs/pdf/9155.pdf It's in the first chapter. You just need to copy the data files through the network and use the convdata convcode tools. I would recommend a complete rebuild of indexes as opposed to using convidx. The main issues you will find is things that were coded to interact with the OS. HTH, Doug At 02:23 PM 2/4/2004, you wrote: Any pointers on what document explains how to move data from an old old UNIX U2 system to a new 10.0 Windows system? Thanks. Cyndi -- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Format Text in Output Data File
Karl has one good way to do it. I'd like to slug whoever it is that put it into people's heads that CSV is the universal pipe into Excel. CSV is for raw data only, it has nothing to do with formatting. If you want formatting then you must understand how to use the functionality built into Excel, and how to invoke those functions. wIntegrate and AccuTerm are great tools but they are inadequate for this purpose. I spent months writing software to address the very pain that people mention in forums almost every day, but people insist on trying to put the square CSV peg into the round Excel hole. I'm not making a sales pitch, just encouraging you to take a look at this audio/video presentation to see what's possible: http://Nebula-RnD.com/demos/nebulanalysis/ Good luck. Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl L Pearson Sent: Wednesday, February 04, 2004 2:31 PM To: U2 Users Discussion List Subject: Re: Format Text in Output Data File Open your spreadsheet program and then do a few cells with the attributes you want, save them as HTML/XML and then open the document with a text editor and see what the formatting codes are for those cells. Karl On Wed, 2004-02-04 at 15:28, Simon Adams wrote: I am trying to format text outputted to a csv data file. I'm building a string of data and writing it out to a data file with 'comma' separation, line by line, and naming the outputted file with a .csv extension. Is there a way to format the text/data line(s), as bold or italics or colour etc. without using a third-party software ? Cheers, Simon. Australia. ** *** This e-mail, including any attachments to it, may contain confidential and/or personal information. If you have received this e-mail in error, you must not copy, distribute, or disclose it, use or take any action based on the information contained within it. Please notify the sender immediately by return e-mail of the error and then delete the original e-mail. The information contained within this e-mail may be solely the opinion of the sender and may not necessarily reflect the position, beliefs or opinions of Salmat on any issue. This email has been swept for the presence of computer viruses known to Salmat's anti-virus systems. For more information, visit our website at www.salmat.com.au. ** *** __ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Windows 2000 ODBC connectivity problem...
Title: RE: Windows 2000 ODBC connectivity problem... Just today I added another server into my UCI file and it popped up in the server list right away (running Win2K professional SP4). Have you rebooted the Win2K machine since installing the ODBC client? No other ideas - if your *sure* the uci.config file is correct hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Williams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 04, 2004 3:18 PM To: '[EMAIL PROTECTED]' Subject: Windows 2000 ODBC connectivity problem... I have the UniData 6.0 ODBC client software installed on a Windows NT 4.0 machine and a Windows 2000 machine. Setting up an System DSN ODBC profile on the Window NT box work just fine, however on the Windows 2000 machine, whenever I access the server drop down list box, there are no servers present even though I have several set up properly in the uci.config file. When I just manually type the server in and try to use the ODBC profile elsewhere, it doesn't work. I checked both machines and the uci.config file is identical on both machines (same path and content) and the registry key is consistent on both boxes as well. Registry Key: \HKEY_LOCAL_MACHINE\SOFTWARE\IBM\UniClient\UCI:UciCfgFile uci.config path: C:\IBM\UniDK\Config\uci.config Does anyone have any insight on this one? Any help you can give is greatly appreciated. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Migrating U2 data
Ah, silly me. My brain combined (U2 data = ""> Missed the give away clue of the release being version 10. Disregard my suggestions as they were UniData specific. As I crawl back under my rock... At 05:21 PM 2/4/2004, you wrote: Well, Universe is the RDMS (no?). I just need the data (Unidata, yes?) We have an very old 7.3.1.1 version of UniVerse running on SCO 3.2. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Migrating U2 data
Unidata is a different database (BTW Doug you can move from Unidata to Universe). Make sure you media is compatible between the systems. So you move one tape taking a backup using uvbackup and then restore using uvrestore on the windows box. If you would like some help, we do this for a living, contact me off-line or see our web site www.u2logic.com. - Original Message - From: Cyndi Calvin To: U2 Users Discussion List Sent: Wednesday, February 04, 2004 4:21 PM Subject: Re: Migrating U2 data Well, Universe is the RDMS (no?). I just need the data (Unidata, yes?) We have an very old 7.3.1.1 version of UniVerse running on SCO 3.2. We want to move it to a new Windows XP or 2000 client. I have the UniVerse 10.0 to install on Windows. Someone also mentioned using uvbackup and uvrestore. I'm looking at http://publibfi.boulder.ibm.com/epubs/pdf/9155.pdf page 31. - Original Message - From: D Averch To: U2 Users Discussion List Sent: Wednesday, February 04, 2004 2:40 PM Subject: Re: Migrating U2 data Universe or Unidata? What version from? What version to? - Original Message - From: Cyndi Calvin To: [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 1:23 PM Subject: Migrating U2 data Any pointers on what document explains how to move data from an old old UNIX U2 system to a new 10.0 Windows system? Thanks. Cyndi -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ADMIN] Why multiple digests, and a lecture on Netetiquette
John Cassidy wrote: Bits? You had Bits? All we had were 1's. Unary. And we were darn glad to have 'em. [EMAIL PROTECTED] 2/4/04 11:27:09 AM Back in my day, bits were smaller. We only had 0.5 and 1. There are 10 types of people who understand binary code: those who do those who don't -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Migrating U2 data
So if we are running UniVerse (and UniData is a different DB system)I would not use the document someone referenced http://publibfi.boulder.ibm.com/epubs/pdf/9155.pdf because this is for UniData Here is what I was told to use to determine what we are running on old SCO. This is UniVerse? .L RELLEVEL RELLEVEL001 X002 7.3.1.1003 PICK004 PICK.FORMAT As for uvbackup and uvrestore -- they were notimplemented inUniVerse 7.3.1.1 distribution. Any other ideas for migrating UniVerse UNIX 7.3.1.1 to Windows 10.0? - Original Message - From: D Averch To: U2 Users Discussion List Sent: Wednesday, February 04, 2004 4:09 PM Subject: Re: Migrating U2 data Unidata is a different database (BTW Doug you can move from Unidata to Universe). Make sure you media is compatible between the systems. So you move one tape taking a backup using uvbackup and then restore using uvrestore on the windows box. If you would like some help, we do this for a living, contact me off-line or see our web site www.u2logic.com. - Original Message - From: Cyndi Calvin To: U2 Users Discussion List Sent: Wednesday, February 04, 2004 4:21 PM Subject: Re: Migrating U2 data Well, Universe is the RDMS (no?). I just need the data (Unidata, yes?) We have an very old 7.3.1.1 version of UniVerse running on SCO 3.2. We want to move it to a new Windows XP or 2000 client. I have the UniVerse 10.0 to install on Windows. Someone also mentioned using uvbackup and uvrestore. I'm looking at http://publibfi.boulder.ibm.com/epubs/pdf/9155.pdf page 31. - Original Message - From: D Averch To: U2 Users Discussion List Sent: Wednesday, February 04, 2004 2:40 PM Subject: Re: Migrating U2 data Universe or Unidata? What version from? What version to? - Original Message - From: Cyndi Calvin To: [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 1:23 PM Subject: Migrating U2 data Any pointers on what document explains how to move data from an old old UNIX U2 system to a new 10.0 Windows system? Thanks. Cyndi -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Migrating U2 data
I have done this a number of times and all I did was use the fnuxi command in uv/bin directory. (1) Copy Unix accounts to the windows server. (2) Enter following command in the directory containing the unix dataat the Windows command prompt: dir/b | fnuxi This lists each file name and passes it to the fnuxi command to convert to the correct format for the Windows platform. Alan Bateman EVOLUTION Software Services Pty Ltd solutions for changing needs 4-10 Bridge Street PYMBLE NSW 2073 Phone : (02) 9497 4340 Mobile : (0417) 685 246 Fax : (02) 9497 4370 E-mail : abateman@evoss.com.au Web : www.evoss.com.auThe information contained in this e-mail is intended only for the named recipient(s) and may be confidential and/or privileged.Unauthorised use or reproduction (including storage or re-distribution) is prohibited. Except as required at law, Evolution Software Services Pty Ltd does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Cyndi CalvinSent: Thursday, 5 February 2004 7:23 AMTo: [EMAIL PROTECTED]Subject: Migrating U2 data Any pointers on what document explains how to move data from an old old UNIX U2 system to a new 10.0 Windows system? Thanks. Cyndi -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV command failing mystery
Vance: Is echo $? returning anything meaningful after uvsh fails? Lee -- Lee J. Leitner, Ph.D. [EMAIL PROTECTED] http://www.leitner.org/~leitnerl The world can only be grasped by action, not by contemplation. The hand is the cutting edge of the mind. -- Jacob Bronowski V.13.0 --- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[UV] Problem with GET(ARG.,1)
If the command line contains a trailing '?' character, it appears that GET(ARG.,1)FILTER ...returns an empty string. This is probably documented somewhere, right g? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Problem with GET(ARG.,1)
Hi Barry, Probably is documented but a ? at the end of a command line at TCL will not execute the line and just store it on the command stack. I am surprised your program is executing at all. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, 5 February 2004 1:31 PM To: U2 list (E-mail) Subject: [UV] Problem with GET(ARG.,1) If the command line contains a trailing '?' character, it appears that GET(ARG.,1)FILTER ...returns an empty string. This is probably documented somewhere, right g? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Universe Date Conversions Using the SQL.B.INTDATE
I've been trying to get a date conversion to work for data being inserted into a SQL/Server table with no success. When I use the SQL.B.INTDATE and SQL.DATE parameters in the SQLBindParameter statement, I get the following error: Status for SQLExecute call is: -1 SQLSTATE,NATCOD are:S1C00 0 Error text is: [IBM][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Optional feature not implemented I've tried multiple formats and combos with no success. I'm running on IBM/U2 Release 10.0.10 As always with this group, that's for the great help.. Mark Warner attachment: winmail.dat-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UDT SELECT optimization
Title: Message My example was multiple WITH clauses that are ANDed. Breaking them up may be more efficient. Your example begs the question of what is faster: SELECT ORDERS WITH DATE = "01.01.04" BY TIME vs SELECT ORDERS BY TIME WITH DATE = "01.01.04" I tend to put the WITH's first if that matters. - Original Message - From: Dennis Bartlett To: 'U2 Users Discussion List' Sent: Wednesday, February 04, 2004 8:45 AM Subject: RE: UDT SELECT optimization I've always thought that a SELECT that reduces the results first then SORTS would be quicker, eg SELECT ORDERS WITH DATE = "01/01/04" BY TIME where WITH DATE = "01/01/04" is what reduces the results and BY TIMEis the selection criteria based on the logic that the reduced list would be quicker to sort... Dunno where I picked up this thought process, but I am from a Prime / R83background. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark JohnsonSent: 03 February 2004 02:34To: U2 Users Discussion ListSubject: Re: UDT SELECT optimization Cached in memory is correct as well as the second statement will only have to process fewer records if the WITH was done in the first. Breaking up a SELECT statement into 2 parts may be advantageous, regardless of caching, if there are multiple ANDed WITH clauses and one or more of them involve translates. For example: SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" AND WITH PERIOD = "199910" would be faster as SELECT HUGE.ARCHIVE.FILE WITH PERIOD = "199910" then SSELECT HUGE.ARCHIVE.FILE WITH CUST.ZIP = "12345" assuming that CUST.ZIP is translated and the PERIOD is a local field. Note the SSELECT in the second statement as well. I've often wondered if, when using consecutive ANDs the filter processor skips the record if the first WITH is false. Why bother testing the second field if both are ANDed. my 1 cent. - Original Message - From: Brian Leach To: 'U2 Users Discussion List' Sent: Monday, February 02, 2004 11:24 AM Subject: RE: UDT SELECT optimization Chuck, The order should be immaterial ( it is on every other database I can think of ). Just be aware that if you test it byissuing the commands one after the other, the second may may complete quicker, simply because the file may be cached in memory. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck MongioviSent: 02 February 2004 16:16To: U2 Users Discussion ListSubject: UDT SELECT optimization Does anyone know whether one of these two statements is faster? SELECT FILE BY SOME.DATE WITH SOME.FIELD = "XXX" -or- SELECT FILE WITH SOME.FIELD = "XXX" BY SOME.DATE Does the parser / optimizer (if there is one) do the filter portion of the statement first regardless of the order that you build it in or does it do things EXACTLY in the order that you enter them on the command line? -ChuckThis email was checked by MessageLabs SkyScan before entering Microgen.This email was checked on leaving Microgen for viruses, similarmalicious code and inappropriate content by MessageLabs SkyScan.DISCLAIMERThis email and any attachments are confidential and may also beprivileged.If you are not the named recipient, please notify the senderimmediately and do not disclose the contents to any otherperson, use it for any purpose, or store or copy the information.In the event of any technical difficulty with this email, pleasecontact the sender or [EMAIL PROTECTED]Microgen Information Management Solutionshttp://www.microgen.co.uk ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: Re: [UD] Determining if list exists
I once worked on a UV (SCO/Dell Poweredge) that was ported from a MCD that had a lot of IF E = 401, IF E = 201 etc. Come to think of it, every TCL statement generates an ERRMSG. They're just not all errors. 100 items selected is stored in ERRMSG. The ERRMSG dialect is evoked from the STOP databasic Statement. Does anyone know of any other way to evoke ERRMSG text. I've often wondered. thanks. - Original Message - From: Glenn Herbert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 9:17 AM Subject: RE: Memo: Re: [UD] Determining if list exists At 06:34 PM 02/03/2004, you wrote: Goo'day, Are you sure the IF E = 401 bit works in UV? This would not work within UV unless proc had been rewritten (doubtful). The error handling within uv is different and this is one of those areas affected by that difference. You can only test IF E or IF #E. AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick flavo*u*r. Yep. The 401 bit is vanilla Pick, which I remember we had to change on conversion to UV back in 9.3???. Dunno about UD, though At 10:06 04/02/04, you wrote: In a proc you would have: PQ HSELECT SOMEFILE SAMPLE 3 P IF E = 401 G 99 HLIST SOMEFILE P 99 O No Items Selected __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.8.1 - Release Date: 30/01/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users