Re: [U2] RE: UVTSORT config parameter
Yes. According to my conversations with DG, the project was referred to as Firestorm and had DG's affinity throughout. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Aug 9, 2007, at 6:35 PM, LeRoy Dreyfuss wrote: Not sure, but I believe VMark had DG do the actual development for affinity. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Printing Printer controls from Universe
Hi All, Does anyone know how to send a control code to a printer connected as a slave? I have tried to send the escape sequence but it is not being interpreted by the printer, just printed out. Change HP printer to landscape. Using print CHAR(27): l1O Thanks, James Hutchinson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to use LOCATE in an I Descriptor
If you like gymnastics and particularly wish to avoid a subr, you can use the vector EQS function with INDEX to find stuff - it's fugly but works reasonably efficiently... 001 I 002 MV.ATTRIBUTE.TO.SEARCH;EQS(REUSE('SEARCH.STRING'),@1);IF SUM(@2) THEN @11,(INDEX(@2,1,1)+1)/2 ELSE 'NOT FOUND' 003 ... The EQS produces a string like 0:v:0:v...0:v:1 and if the SUM() is 0 then there has been a hit. The INDEX() function then finds the 1 in the string. The MV position can be derived by the index() result + 1 and division by 2. -Original Message- I have someone asking me how to use a LOCATE statement in an I Descriptor. I have never done that and would not know if it is possible, or what the syntax is. Does anyone know if you can do this, and what the syntax would be to use the resultant location? ** 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] [UD 7.1] [Solaris 9]
REPOSTED FOR NON-MEMBER ADDRESS: [EMAIL PROTECTED] Hi, Are there any NFA users out there that can help me with an issue? I 'd like to copy 10 files from our production server to our test server. The problem is that NFA doesn't allow me to use the ECL command COPY. I don't want to run through every file copying record by record since that will take some time and it's not a neat solution. We are also implementing RFS so we can't use unix copy. Does anyone have a way to solve this I'd be glad. TIA Bjvrn Eklund --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to use LOCATE in an I Descriptor
Thanks for the example, We will try it out -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Ed Sent: Friday, August 10, 2007 9:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to use LOCATE in an I Descriptor I use this on UD. SUBROUTINE DICT.LOCATE(OUT,LOOKER,FN,ITEM,ATT.LOOK,ATT.OUT) * * UCONV.BP DICT.LOCATE * CALLED BY DICTIONARIES * ED BURWELL * 07/23/1999 * * OUT - FILE NAME, SENT BACK TO DICT * LOOKER - THING TO LOOK FOR * FN - FILE TO OPEN * ITEM - ITEM IN FILE TO READ * ATT.LOOK - ATTRIBUTE TO LOOK IN * ATT.OUT - ATTRIBUTE TO RETURN OR POS TO RETURN POSITION * OUT= IF DCOUNT(FN, )=2 THEN D=FIELD(FN, ,1) FN=FIELD(FN, ,2) END ELSE D= END OPEN D,FN TO F.FILE ELSE RETURN READ REC FROM F.FILE,ITEM ELSE RETURN MAX=DCOUNT(LOOKER1,@VM) FOR I=1 TO MAX LOOK=LOOKER1,I LOCATE LOOK IN RECATT.LOOK,1 SETTING POS THEN IF ATT.OUT=POS THEN OUT1,I=POS END ELSE OUT1,I=RECATT.OUT,POS END END ELSE IF ATT.OUT=POS THEN OUT1,I=POS END NEXT I RETURN END Here is an example of how it's used: 001: V 002: SUBR('DICT.LOCATE',MISC.CODE,CARRIER.PARAM,FEDEX_SERVICE.LEVEL,5,13) 003: 004: C 005: 1R 006: S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard A. Wilson Sent: Friday, August 10, 2007 3:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How to use LOCATE in an I Descriptor left over from old prime days. basically a global catalog so voc items dont have to exists in each account where the subr might be used. I beliee its still legit for UV but probably not UD,Pick,etc Rich Jeff Butera wrote: SUBR('*YOUR.LOCATE.SUBR',VALUE,@RECORD,AM.POS,VM.POS,SVM.POS,LR.JUST) Can I ask a naive question: When using SUBR what is the point of the preceding * before the subroutine? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Printing Printer controls from Universe
James, Reinstall your printer on (whatever) operating system using the Generic Text Driver rather than the manufacturer's printer driver. This will allow the ESC sequences to pass thru to your printer as ESC sequences. On Windows, set the Print Processor to WinPrint and the Default Data Type to Raw. If your HP printer is a laser printer, this should work. If it's an ink jet printer, it may not have the intelligence to respond to your ESC sequence commands. hth, Dave Dave Taylor CEO Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (F) 310-377-3550 www.sysmarkinfo.com Your Source for Integrated EDI Translation, DataSync Integration and Software Migration Authorized IBM Business Partner - Original Message - From: James Hutchinson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, August 09, 2007 10:32 PM Subject: [U2] Printing Printer controls from Universe Hi All, Does anyone know how to send a control code to a printer connected as a slave? I have tried to send the escape sequence but it is not being interpreted by the printer, just printed out. Change HP printer to landscape. Using print CHAR(27): l1O Thanks, James Hutchinson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Looking for a White Paper
Hi Brian, It would be nice to know... a) just what this benchmark actually did. I guess that PDSC do not publish the source code. b) how this would run on the new flash disk technology announced this week by EasyCo. 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Looking for a White Paper
Past 12,000. It was part of an internal benchmark for a new rollout (and succeeded). I don't know if there was a white paper (I haven't seen one) or if there was a separate test run elsewhere up to 2,000. Anyway - hiked up to 12,000 on AIX - if there is a public document I'm sure someone will pitch in. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: 10 August 2007 14:58 To: u2-users@listserver.u2ug.org Subject: [U2] Looking for a White Paper All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. They pushed it somewhere past 2K users without breaking things and only stopped when they ran out of testing time. I have a client who is part SQL shop and part UniVerse. I'd love to get them a copy of this White Paper so that I can help guide them to a better choice on an upcoming project which could be implemented on either architecture. Showing the robustness of the U2 system would go a long way. Anyone have a link to the paper? -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVTSORT config parameter
Dear Messrs. Dreyfuss, Oliver, Wurlod, gurus all, My original request was for words of wisdom. History lessons count. The older I get, the more I value them. Thank-you. But I was more interested in the future (my own): - Why would I enable multi-threading? (UVTSORT 1) - Why would I disable multi-threading? (UVTSORT 0) - If 1 is always right, why did IBM make it configurable by the user? - What symptoms would make me suspect I have it wrong? - How would one test it? - Is there any documentation? Cherishing your every word, Chuck P.S. I'm anticipating upgrade to HP Itanium, HPUX11.23, UV 10.2.5. I assume multi-threading sorting applies there, although it wasn't stated. -Original Message- From: LeRoy Dreyfuss Thx Mr. Oliver. I recall our pal Pete Simonson telling me that some years ago. Just didn't want to stick my neck too far out without some caution :-) -Original Message- From: Clifton Oliver Yes. According to my conversations with DG, the project was referred to as Firestorm and had DG's affinity throughout. Not sure, but I believe VMark had DG do the actual development for affinity. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Looking for a White Paper
Charles Do you must mean the internal tests done for IBM's own system? The announcement below was posted to this list by Stephen O'Neal under the thread: 15,200 users attained on IBM's U2 UniVerse (which is a bit more than 2K..). He or Tim may have more details. Here's the original post: This last weekend, we attained a new high number of users on a U2 database of 15,200 on a single system running an application! Tim Snyder, Principle Consultant of the U2 Lab Services group, performed this formal benchmark at one of the IBM benchmark centers on an IBM p590 + 64 dual core CPUs for a total of 128 processors + 124gb memory (no, that's not a typo - that's all the benchmark center had available - odd number though) + 34 disk drives, striped with JFS2 on two FAStT controllers It required an IBM p570 divided into 4 LPARs (logical partitions) to push the load which simulated 30 different processes. It took 6 weeks of preparation before the 3 weeks to set up the simulation at the benchmark facility. The application was from Pacific Decision Sciences Corporation (www.pdsc.com). The database had over 1 billion records in it. Cheers Brian All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. They pushed it somewhere past 2K users without breaking things and only stopped when they ran out of testing time. I have a client who is part SQL shop and part UniVerse. I'd love to get them a copy of this White Paper so that I can help guide them to a better choice on an upcoming project which could be implemented on either architecture. Showing the robustness of the U2 system would go a long way. Anyone have a link to the paper? -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to use LOCATE in an I Descriptor
I use this on UD. SUBROUTINE DICT.LOCATE(OUT,LOOKER,FN,ITEM,ATT.LOOK,ATT.OUT) * * UCONV.BP DICT.LOCATE * CALLED BY DICTIONARIES * ED BURWELL * 07/23/1999 * * OUT - FILE NAME, SENT BACK TO DICT * LOOKER - THING TO LOOK FOR * FN - FILE TO OPEN * ITEM - ITEM IN FILE TO READ * ATT.LOOK - ATTRIBUTE TO LOOK IN * ATT.OUT - ATTRIBUTE TO RETURN OR POS TO RETURN POSITION * OUT= IF DCOUNT(FN, )=2 THEN D=FIELD(FN, ,1) FN=FIELD(FN, ,2) END ELSE D= END OPEN D,FN TO F.FILE ELSE RETURN READ REC FROM F.FILE,ITEM ELSE RETURN MAX=DCOUNT(LOOKER1,@VM) FOR I=1 TO MAX LOOK=LOOKER1,I LOCATE LOOK IN RECATT.LOOK,1 SETTING POS THEN IF ATT.OUT=POS THEN OUT1,I=POS END ELSE OUT1,I=RECATT.OUT,POS END END ELSE IF ATT.OUT=POS THEN OUT1,I=POS END NEXT I RETURN END Here is an example of how it's used: 001: V 002: SUBR('DICT.LOCATE',MISC.CODE,CARRIER.PARAM,FEDEX_SERVICE.LEVEL,5,13) 003: 004: C 005: 1R 006: S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard A. Wilson Sent: Friday, August 10, 2007 3:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How to use LOCATE in an I Descriptor left over from old prime days. basically a global catalog so voc items dont have to exists in each account where the subr might be used. I beliee its still legit for UV but probably not UD,Pick,etc Rich Jeff Butera wrote: SUBR('*YOUR.LOCATE.SUBR',VALUE,@RECORD,AM.POS,VM.POS,SVM.POS,LR.JUST) Can I ask a naive question: When using SUBR what is the point of the preceding * before the subroutine? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Getting current SETPTR values
Is there a way to get the values reported by SETPTR, especially the destination without parsing the results of the ECL command? If you're on UniData, take a look at the UniBasic GETPU() and GETPTR() functions. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVTSORT config parameter
I'll answer part of this. We were having trouble with creating pipes and they asked us to turn off multi-threading as a possibility that it may have been a problem on our Linux server. The selects may have been taxing our resources. Most modern systems can handle multi-threading but some of the older systems may not. Since UV defaults to multi-threading you may have to turn it off. Jerry -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Friday, August 10, 2007 9:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVTSORT config parameter Dear Messrs. Dreyfuss, Oliver, Wurlod, gurus all, My original request was for words of wisdom. History lessons count. The older I get, the more I value them. Thank-you. But I was more interested in the future (my own): - Why would I enable multi-threading? (UVTSORT 1) - Why would I disable multi-threading? (UVTSORT 0) - If 1 is always right, why did IBM make it configurable by the user? - What symptoms would make me suspect I have it wrong? - How would one test it? - Is there any documentation? Cherishing your every word, Chuck P.S. I'm anticipating upgrade to HP Itanium, HPUX11.23, UV 10.2.5. I assume multi-threading sorting applies there, although it wasn't stated. -Original Message- From: LeRoy Dreyfuss Thx Mr. Oliver. I recall our pal Pete Simonson telling me that some years ago. Just didn't want to stick my neck too far out without some caution :-) -Original Message- From: Clifton Oliver Yes. According to my conversations with DG, the project was referred to as Firestorm and had DG's affinity throughout. Not sure, but I believe VMark had DG do the actual development for affinity. --- 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] UVTSORT config parameter
We had to disable multi-threading sort as we were getting unable to create pipe errors on occasion and we were having problems with our indices. We would do a BUIILD.INDEX ALL and one or more of the builds of an index would abort leaving the phantom hanging and all the other phantoms would hang up, making the whole process come to a standstill. We've not had either problem since we disabled it. We are on Redhat Linux running 10.1. Brenda -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Friday, August 10, 2007 9:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVTSORT config parameter Dear Messrs. Dreyfuss, Oliver, Wurlod, gurus all, My original request was for words of wisdom. History lessons count. The older I get, the more I value them. Thank-you. But I was more interested in the future (my own): - Why would I enable multi-threading? (UVTSORT 1) - Why would I disable multi-threading? (UVTSORT 0) - If 1 is always right, why did IBM make it configurable by the user? - What symptoms would make me suspect I have it wrong? - How would one test it? - Is there any documentation? Cherishing your every word, Chuck P.S. I'm anticipating upgrade to HP Itanium, HPUX11.23, UV 10.2.5. I assume multi-threading sorting applies there, although it wasn't stated. -Original Message- From: LeRoy Dreyfuss Thx Mr. Oliver. I recall our pal Pete Simonson telling me that some years ago. Just didn't want to stick my neck too far out without some caution :-) -Original Message- From: Clifton Oliver Yes. According to my conversations with DG, the project was referred to as Firestorm and had DG's affinity throughout. Not sure, but I believe VMark had DG do the actual development for affinity. --- 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] Printing Printer controls from Universe
On UD we try to make sure we've done a CONTROLCHARS IGNORE first. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, August 10, 2007 10:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Printing Printer controls from Universe If you're using a pass-through slave function, there are two possibilities I've seen for solutions: 1. Your emulation is 'converting' the escape to its ASCII equivalent. If so, there is usually a setting for that. 2. Try using CRT instead of PRINT. HTH Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Hutchinson Sent: Friday, August 10, 2007 1:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Printing Printer controls from Universe Hi All, Does anyone know how to send a control code to a printer connected as a slave? I have tried to send the escape sequence but it is not being interpreted by the printer, just printed out. Change HP printer to landscape. Using print CHAR(27): l1O Thanks, James Hutchinson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 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 and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing Printer controls from Universe
James: The terminal emulator often has a slave print mode of text or raw. This is the easiest. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Friday, August 10, 2007 1:12 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Printing Printer controls from Universe Your ESCAPE [CHAR(27)] may well be intercepted. Check your terminal / terminal emulation specification for what it might intercept. Odds on it that never gets to the printer. You might be able to send an alternate character (155 for example - 128+27) or use a different slave print mode (e.g. passthru'). Otherwise there may well be something in the emulation documentation that tells you how to escape and ESCAPE. I've seen this done a few ways: CHAR(27) meaning escape; followed CHAR(27) meaning ESCAPE again - but the ESCAPE was escaped meaning send an ESCAPE. The addition of 128 to the ASCII value was another, I've also seen games with SI and SO to escape a character. Hope it helps JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Hutchinson Sent: 10 August 2007 07:32 To: u2-users@listserver.u2ug.org Subject: [U2] Printing Printer controls from Universe Hi All, Does anyone know how to send a control code to a printer connected as a slave? I have tried to send the escape sequence but it is not being interpreted by the printer, just printed out. Change HP printer to landscape. Using print CHAR(27): l1O Thanks, James Hutchinson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Combining report writer reports
I have some report writer reports that are called from the programe that creates the data that the reports use, however I would like to consolodate these in to one print job and send that at the end, I cannot output to one dummy printer (a file on the server) as that would mean only one person using the programme at a time. I have tried experimenting with the Additional Report Parameters (/MP process, F5, F9), the spooler options look as though they may be useful but I cant get the HS option to work as I expect, Is there a way to get the _HOLD_ file name created and concatenate that to another file, then do the same with the next etc, etc. Or is there an easier way to combine the output of separate report writer reports? -- Important Manager : Hello, is that the chief neologist? Chief neologist : Yes, speaking. IM : I need a new word to replace implement in I.T. system. CN : Yes, far, far too wordy a phrase. IM : And too accurate! I need something dynamic, but vague, something that people wont know how to pronounce when they see it written. CN : Let me think ... how about, ititize? Like dramatize but with I.T.? IM : Brilliant! CN : And the beauty part is you get ititization or itism for free! -- * This message has been scanned for viruses and dangerous content by * Blairs MailScanner, and is believed to be clean. * * 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 at Blairs * via email at [EMAIL PROTECTED] * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Website Questions
Hi All Can someone answer these two questions, posted on the U2UG website? Thanks in advance Brian 1. Is there a 64 bit ODBC/OleDB driver available for UniVerse? 2. Users getting kicked out of UniVerse. We have Universe 10.1 running in Windows 2003. It seems like when we are getting close to our license limit, users that are currently logged in are getting kicked out. We are using telnet to connect to the server. The strange thing is that it only seems to be happening on Barcode scanners (using VT100 emulation). A PC using AccuTerm, Reflections, etc. emulation software has no problems. This only seemed to happen after we switched from Universe 10.0 on Linux to 10.1 on Windows. Any help would be greatly appreciated!! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Looking for a White Paper
Look at http://www-306.ibm.com/software/info/u2/university/index3.jsp in the AD3xxx section. I did a find on 15,200 and found the statement in question. Ron White Charles Barouch wrote: All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. They pushed it somewhere past 2K users without breaking things and only stopped when they ran out of testing time. I have a client who is part SQL shop and part UniVerse. I'd love to get them a copy of this White Paper so that I can help guide them to a better choice on an upcoming project which could be implemented on either architecture. Showing the robustness of the U2 system would go a long way. Anyone have a link to the paper? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Getting current SETPTR values
Hi Jonathan, Is there a way to get the values reported by SETPTR, especially the destination without parsing the results of the ECL command? Take a look at the !GETPU() subroutine. 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing Printer controls from Universe
Your ESCAPE [CHAR(27)] may well be intercepted. Check your terminal / terminal emulation specification for what it might intercept. Odds on it that never gets to the printer. You might be able to send an alternate character (155 for example - 128+27) or use a different slave print mode (e.g. passthru'). Otherwise there may well be something in the emulation documentation that tells you how to escape and ESCAPE. I've seen this done a few ways: CHAR(27) meaning escape; followed CHAR(27) meaning ESCAPE again - but the ESCAPE was escaped meaning send an ESCAPE. The addition of 128 to the ASCII value was another, I've also seen games with SI and SO to escape a character. Hope it helps JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Hutchinson Sent: 10 August 2007 07:32 To: u2-users@listserver.u2ug.org Subject: [U2] Printing Printer controls from Universe Hi All, Does anyone know how to send a control code to a printer connected as a slave? I have tried to send the escape sequence but it is not being interpreted by the printer, just printed out. Change HP printer to landscape. Using print CHAR(27): l1O Thanks, James Hutchinson --- 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] How to use LOCATE in an I Descriptor
left over from old prime days. basically a global catalog so voc items dont have to exists in each account where the subr might be used. I beliee its still legit for UV but probably not UD,Pick,etc Rich Jeff Butera wrote: SUBR('*YOUR.LOCATE.SUBR',VALUE,@RECORD,AM.POS,VM.POS,SVM.POS,LR.JUST) Can I ask a naive question: When using SUBR what is the point of the preceding * before the subroutine? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVTSORT config parameter
Why was it made a switch ? (pass) -- Not all platforms supported the function but if it was not supported then it didn't use it regardless (naturally). It was fortunate that it *was* a switch though - as there were occasional issues where you needed to turn it off (see the release notes for fixes) - however that's history. The possibility of issues may have been in the developer's minds (a guess on my part). Nowadays I would always turn it on. Shedding some (albeit dim) light in the shade. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: 10 August 2007 15:52 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVTSORT config parameter Dear Messrs. Dreyfuss, Oliver, Wurlod, gurus all, My original request was for words of wisdom. History lessons count. The older I get, the more I value them. Thank-you. But I was more interested in the future (my own): - Why would I enable multi-threading? (UVTSORT 1) - Why would I disable multi-threading? (UVTSORT 0) - If 1 is always right, why did IBM make it configurable by the user? - What symptoms would make me suspect I have it wrong? - How would one test it? - Is there any documentation? Cherishing your every word, Chuck P.S. I'm anticipating upgrade to HP Itanium, HPUX11.23, UV 10.2.5. I assume multi-threading sorting applies there, although it wasn't stated. -Original Message- From: LeRoy Dreyfuss Thx Mr. Oliver. I recall our pal Pete Simonson telling me that some years ago. Just didn't want to stick my neck too far out without some caution :-) -Original Message- From: Clifton Oliver Yes. According to my conversations with DG, the project was referred to as Firestorm and had DG's affinity throughout. Not sure, but I believe VMark had DG do the actual development for affinity. --- 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] HASH.HELP
Thanks everyone, it is reassuring to know it is only the HASH.HELP prog and not our data that has corruption. I see that HASH.HELP had been fixed in 10.2.4 - maybe it is time to upgrade? Schalk We are running 10.1.21 on Linux so not exactly the same as you but we have reported a bug in HASH.HELP for this exact failure. IBM has put it on an ecase to be fixed. Until it is you might consider using HASH.HELP.DETAIL which does not have this problem. HASH.HELP.DETAIL has two pages of output, the second of which is identical to that of HASH.HELP. Hope this helps. Perry Taylor Zirmed, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to use LOCATE in an I Descriptor
And don't forget SHM.TO.LOAD Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard A. Wilson Sent: 10 August 2007 08:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] How to use LOCATE in an I Descriptor left over from old prime days. basically a global catalog so voc items dont have to exists in each account where the subr might be used. I beliee its still legit for UV but probably not UD,Pick,etc Rich Jeff Butera wrote: SUBR('*YOUR.LOCATE.SUBR',VALUE,@RECORD,AM.POS,VM.POS,SVM.POS,LR.JUST) Can I ask a naive question: When using SUBR what is the point of the preceding * before the subroutine? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Speeding up a big BY.EXP select
This is looking very promising but probably also needs 'niced up' dictionaries - our collection of randomly generated dicts doesn't cut it and I'm getting some fields unnesting and some fields as MV lists per unnested row. AA 12345 description of 12345 Description of Description of 7625 AA description of 12345 Description of Description of 7625 AA 7625 description of 12345 Description of Description of 7625 Should I be looking at using @ASSOC_KEY? -Original Message- If so, use an SQL UNNEST keyword, e.g. SELECT SURNAME,FORENAME,TITLE_ID,QTY,PRICE FROM UNNEST BOOK_SALES ON SALE_ITEMS; You can explode a field to a select list by using the TO SLIST clause, e.g. SELECT TITLE_ID TO SLIST 0 FROM UNNEST BOOK_SALES ON SALE_ITEMS; ** 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] Getting current SETPTR values
Is there a way to get the values reported by SETPTR, especially the destination without parsing the results of the ECL command? I have noticed that the format of the output of the SETPTR command is not consistant, making parsing difficult. -- Important Manager : Hello, is that the chief neologist? Chief neologist : Yes, speaking. IM : I need a new word to replace implement in I.T. system. CN : Yes, far, far too wordy a phrase. IM : And too accurate! I need something dynamic, but vague, something that people wont know how to pronounce when they see it written. CN : Let me think ... how about, ititize? Like dramatize but with I.T.? IM : Brilliant! CN : And the beauty part is you get ititization or itism for free! -- * This message has been scanned for viruses and dangerous content by * Blairs MailScanner, and is believed to be clean. * * 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 at Blairs * via email at [EMAIL PROTECTED] * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Getting current SETPTR values
Does !SETPTR (or !SET.PTR - can't remember) do what you want? Cheers, Wol -Original Message- From: Jonathan Leckie [mailto:[EMAIL PROTECTED] Sent: 10 August 2007 09:55 To: u2-users@listserver.u2ug.org Subject: [U2] Getting current SETPTR values Is there a way to get the values reported by SETPTR, especially the destination without parsing the results of the ECL command? I have noticed that the format of the output of the SETPTR command is not consistant, making parsing difficult. -- Important Manager : Hello, is that the chief neologist? Chief neologist : Yes, speaking. IM : I need a new word to replace implement in I.T. system. CN : Yes, far, far too wordy a phrase. IM : And too accurate! I need something dynamic, but vague, something that people wont know how to pronounce when they see it written. CN : Let me think ... how about, ititize? Like dramatize but with I.T.? IM : Brilliant! CN : And the beauty part is you get ititization or itism for free! -- * This message has been scanned for viruses and dangerous content by * Blairs MailScanner, and is believed to be clean. * * 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 at Blairs * via email at [EMAIL PROTECTED] * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- 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/
SV: [U2] [UD 7.1] [Solaris 9]
Thanks Tim and Brian, We will have to go with the copy record by record as it seems. Bjvrn Eklund -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Timothy Snyder Skickat: den 9 augusti 2007 16:32 Till: u2-users@listserver.u2ug.org Dmne: Re: [U2] [UD 7.1] [Solaris 9] I 'd like to copy 10 files from our production server to our test server. The problem is that NFA doesn't allow me to use the ECL command COPY I've seen NFA users write their own copy utilities in UniBasic. It really isn't any less efficient than the COPY command, since your bottleneck will be on the network more than anything you're doing on the hosts. I envision a cataloged program called something like NFA.COPY that can take the same command-line parameters as the standard COPY command. Naturally, you could work off of saved lists, and all of that good stuff. We are also implementing RFS so we can't use unix copy. And you're right about recoverable files under RFS - please don't copy them at the UNIX level! :-) Actually, I'm not a fan of using O/S commands to copy database files unless it's done in a very controlled fashion. And even then... Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- 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] Phil Harris is out of the office.
I will be out of the office starting 10/08/2007 and will not return until 20/08/2007. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Looking for a White Paper [not-secure]
snip All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. T /snip If you are going to go to U2University, look into this session in the application development track. AD 3003- Case Study: U2 Technology Powers the New IBM Strategic Call Management System IBM is implementing a new call management system based on U2 technology. As part of the evaluation, U2 Lab Services completed a benchmark of our business partner, PDSC's, call management application, wherein 15,200 concurrent users ran on a single system. We will present the key components that made this system scalable enough for a worldwide IBM implementation. Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing Printer controls from Universe
If you're using a pass-through slave function, there are two possibilities I've seen for solutions: 1. Your emulation is 'converting' the escape to its ASCII equivalent. If so, there is usually a setting for that. 2. Try using CRT instead of PRINT. HTH Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Hutchinson Sent: Friday, August 10, 2007 1:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Printing Printer controls from Universe Hi All, Does anyone know how to send a control code to a printer connected as a slave? I have tried to send the escape sequence but it is not being interpreted by the printer, just printed out. Change HP printer to landscape. Using print CHAR(27): l1O Thanks, James Hutchinson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 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 and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Combining report writer reports
I've used the Process At End in the report definition to chain reports together. Everything ends up in the same spool file that way. One report's process at end calls another process that generates a report, and so on and so on. I've used this method to create an empty shell report to run non-SB+ output through the report writer. I suppose you could hold a list of the reports you want to run in a common variable, and make it general. Only gotcha I can think of is if you have too many, you may hit the subroutine CALL nested level limit. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Leckie Sent: Friday, August 10, 2007 9:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] Combining report writer reports I have some report writer reports that are called from the programe that creates the data that the reports use, however I would like to consolodate these in to one print job and send that at the end, I cannot output to one dummy printer (a file on the server) as that would mean only one person using the programme at a time. I have tried experimenting with the Additional Report Parameters (/MP process, F5, F9), the spooler options look as though they may be useful but I cant get the HS option to work as I expect, Is there a way to get the _HOLD_ file name created and concatenate that to another file, then do the same with the next etc, etc. Or is there an easier way to combine the output of separate report writer reports? -- Important Manager : Hello, is that the chief neologist? Chief neologist : Yes, speaking. IM : I need a new word to replace implement in I.T. system. CN : Yes, far, far too wordy a phrase. IM : And too accurate! I need something dynamic, but vague, something that people wont know how to pronounce when they see it written. CN : Let me think ... how about, ititize? Like dramatize but with I.T.? IM : Brilliant! CN : And the beauty part is you get ititization or itism for free! -- * This message has been scanned for viruses and dangerous content by * Blairs MailScanner, and is believed to be clean. * * 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 at Blairs * via email at [EMAIL PROTECTED] * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Looking for a White Paper - 15,200 Users - Link U2U
Charles asked for a link to the 15,200 user benchmark white paper. While there is not a white paper, there is an article: ftp://ftp.software.ibm.com/software/data/u2/pubs/ibmdb2_3-06.pdf Martin asked about the specifics of the benchmark. They will be presented at U2 University around the world. The U2 University Link: http://www.ibm.com/software/info/u2/university/index.jsp The session is Tuesday, 5:15-6:30pm: AD 3003 - Case Study: U2 Technology Powers the New IBM Strategic Call Management System Martin asked about the flash disk technology announced by EasyCO. When I spoke to EasyCO this week, they stated it runs only on Linux at this time and will not be available for AIX or HP/UX until certified (in about a year). Keeping you fully informed, Steve Stephen M. O'Neal U2 Lab Services Sales Specialist Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Looking for a White Paper
All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. They pushed it somewhere past 2K users without breaking things and only stopped when they ran out of testing time. I have a client who is part SQL shop and part UniVerse. I'd love to get them a copy of this White Paper so that I can help guide them to a better choice on an upcoming project which could be implemented on either architecture. Showing the robustness of the U2 system would go a long way. Anyone have a link to the paper? -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Website Questions
Brian, I can't go to the website from the client I'm at (security restrictions) but here's the likely answer to the second question: The terminal emulators probably are doing a 'keep alive' pulse and the barcode scanners probably aren't. My suspicion is that if you turn off keep alive on a terminal emulator, it will fall off as well. -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 Brian Leach wrote: | 2. Users getting kicked out of UniVerse. | We have Universe 10.1 running in Windows 2003. It seems like when we are | getting close to our license limit, users that are currently logged in are | getting kicked out. We are using telnet to connect to the server. | | The strange thing is that it only seems to be happening on Barcode | scanners (using VT100 emulation). A PC using AccuTerm, Reflections, etc. | emulation software has no problems. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UVTSORT config parameter
Thx Mr. Oliver. I recall our pal Pete Simonson telling me that some years ago. Just didn't want to stick my neck too far out without some caution :-) Regards, LeRoy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Friday, August 10, 2007 3:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: UVTSORT config parameter Yes. According to my conversations with DG, the project was referred to as Firestorm and had DG's affinity throughout. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Aug 9, 2007, at 6:35 PM, LeRoy Dreyfuss wrote: Not sure, but I believe VMark had DG do the actual development for affinity. --- 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 University
Martin, from our company, will be there. Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Looking for a White Paper
I found the mention of the 15,200 users in a Spectrum interview with Susie Siegesmund. Look at page 4 of the pdf. ftp://ftp.software.ibm.com/software/data/u2/events/intl-spectrum-QA.pdf Ron White Charles Barouch wrote: All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. They pushed it somewhere past 2K users without breaking things and only stopped when they ran out of testing time. I have a client who is part SQL shop and part UniVerse. I'd love to get them a copy of this White Paper so that I can help guide them to a better choice on an upcoming project which could be implemented on either architecture. Showing the robustness of the U2 system would go a long way. Anyone have a link to the paper? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Looking for a White Paper
From the web address: AD 3003- Case Study: U2 Technology Powers the New IBM Strategic Call Management System IBM is implementing a new call management system based on U2 technology. As part of the evaluation, U2 Lab Services completed a benchmark of our business partner, PDSC's, call management application, wherein 15,200 concurrent users ran on a single system. We will present the key components that made this system scalable enough for a worldwide IBM implementation. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron White Sent: Friday, August 10, 2007 12:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Looking for a White Paper Look at http://www-306.ibm.com/software/info/u2/university/index3.jsp in the AD3xxx section. I did a find on 15,200 and found the statement in question. Ron White Charles Barouch wrote: All, IBM did a test on the volume of users successfully supported on a U2 (UniVerse, I think) server. They pushed it somewhere past 2K users without breaking things and only stopped when they ran out of testing time. I have a client who is part SQL shop and part UniVerse. I'd love to get them a copy of this White Paper so that I can help guide them to a better choice on an upcoming project which could be implemented on either architecture. Showing the robustness of the U2 system would go a long way. Anyone have a link to the paper? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Speeding up a big BY.EXP select
I'm not exactly sure how the programming is done on this but from the outside it is all relative to how you look at it. Let's take the statement: SSELECT CUSTOMERS BY NAME BY CITY In one way it can be seen as: Sort by name with each name sort by city with each city sort by key. In another way of looking at it: Sort by key go through the list pulling out, but retaining the key order, sorting the cities then, retaining that order, sort by name. Either way if you throw a BY @ID in there the SSELECT becomes redundant and the SSELECT is done for no reason. Jerry -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Speeding up a big BY.EXP select Jerry: Are you sure. Please make sure that what you are saying is correct. The SSELECT statement has traditionally sorted on the @ID last for the last 30 years. It would be news to me to learn that it sorts BY @ID automatically first because of the double S in SSELECT. Thus SSELECT FILE BY CITY should be different than SSELECT FILE BY @ID BY CITY as the first would gather all the records BY CITY then within each CITY, they would be sorted by @ID (the default). Using @ID anywhere but the last sort field (or implied) would not make sense as they are guaranteed to be unique and not need a tie breaker. Please check again. Thanks Mark Johnson - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, August 09, 2007 9:39 AM Subject: RE: [U2] [UV] Speeding up a big BY.EXP select The way I see it the first one will take longer than the second, although it would have to be a large file you are selecting on. The reason would be that the first one sorts the ID's, redundantly, twice before it gets to the BY.EXP whereas the second one sorts by the ID only once. -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 2:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Speeding up a big BY.EXP select I have a large file with an MV set I need to do an exploding sort against (about 2 million records, about 20 MVs per record). I'm not actually after any particular sort order but it's taking hours. I'm wondering if there is any efficiency advantage by telling it to use a primary sort on the ID or just to sort on the MV attribute? My (probably flawed) reasoning is that if the primary sort is on the id then the sort process wouldn't have to build up one big explode - as it would have a primary sort by record, it then only needs to explode each record at a time. Eg. SSELECT BIGFILE BY @ID BY.EXP MV.ATTRIBUTE Or SSELECT BIGFILE BY.EXP MV.ATTRIBUTE Anyone know the answer to that one? 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/ --- 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] How to use LOCATE in an I Descriptor
Since I like to avoid subroutines when I can, this is how I would do it (using Perry's sample data slightly modified): EVENTCODE P]B]F]B]R And EVENTSTATUS A-T]B-T]FP-T]K-P]A-P TRIM(IFS(EQS(EVENTCODE,REUSE('B')),EVENTSTATUS,REUSE('')),@VM) Which returns all values for EVENTCODE 'B', else empty. My concern with using INDEX is that you usually end up with only the first occurence in the results. Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert -- U2 Family Application Development Sr. Programmer/Analyst Nu Skin Enterprises --- On Fri 08/10, Boydell, Stuart [EMAIL PROTECTED] wrote: From: Boydell, Stuart [mailto: [EMAIL PROTECTED] 001 I 002 MV.ATTRIBUTE.TO.SEARCH;EQS(REUSE('SEARCH.STRING'),@1);IF SUM(@2)THEN @11,(INDEX(@2,1,1)+1)/2 ELSE 'NOT FOUND' 003 ... ___ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Editor for Fedora, Linux and Windows
U2logic, Inc. the leading independent tool developer for Eclipse plug-ins for IBM's U2 database has released a new version of its Editor and tools. Version 1.2 of XLr8Editor is fully tested on Mac's, Linux (Red Had and Fedora 7) and Windows. We have added many new features to this FREE tool including dictionary editor and compiler errors are clickable to source code. Those are just a few of the many enhancements and bug fixes. XLr8 Environment and Tools is the only plug-in available for Universe and Unidata that gets updated regularly, has full set of documentation, and allows programmers to run the best of the breed on tools not from U2logic. In addition to making this tool, we use it everyday and believe that our productivity is second to none because of the features incorporated therein. Please check it out at www.u2logic.com for download instructions. U2logic Team --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Speeding up a big BY.EXP select
My premise was that SSELECT FILE BY @ID BY FIELDNAME is not the same as SSELECT FILE BY FIELDNAME. The second one is technically SSELECT FILE BY FIELDNAME BY @ID My 1 cent Mark Johnson - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, August 10, 2007 10:32 AM Subject: RE: [U2] [UV] Speeding up a big BY.EXP select I'm not exactly sure how the programming is done on this but from the outside it is all relative to how you look at it. Let's take the statement: SSELECT CUSTOMERS BY NAME BY CITY In one way it can be seen as: Sort by name with each name sort by city with each city sort by key. In another way of looking at it: Sort by key go through the list pulling out, but retaining the key order, sorting the cities then, retaining that order, sort by name. Either way if you throw a BY @ID in there the SSELECT becomes redundant and the SSELECT is done for no reason. Jerry -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Speeding up a big BY.EXP select Jerry: Are you sure. Please make sure that what you are saying is correct. The SSELECT statement has traditionally sorted on the @ID last for the last 30 years. It would be news to me to learn that it sorts BY @ID automatically first because of the double S in SSELECT. Thus SSELECT FILE BY CITY should be different than SSELECT FILE BY @ID BY CITY as the first would gather all the records BY CITY then within each CITY, they would be sorted by @ID (the default). Using @ID anywhere but the last sort field (or implied) would not make sense as they are guaranteed to be unique and not need a tie breaker. Please check again. Thanks Mark Johnson - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, August 09, 2007 9:39 AM Subject: RE: [U2] [UV] Speeding up a big BY.EXP select The way I see it the first one will take longer than the second, although it would have to be a large file you are selecting on. The reason would be that the first one sorts the ID's, redundantly, twice before it gets to the BY.EXP whereas the second one sorts by the ID only once. -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 2:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Speeding up a big BY.EXP select I have a large file with an MV set I need to do an exploding sort against (about 2 million records, about 20 MVs per record). I'm not actually after any particular sort order but it's taking hours. I'm wondering if there is any efficiency advantage by telling it to use a primary sort on the ID or just to sort on the MV attribute? My (probably flawed) reasoning is that if the primary sort is on the id then the sort process wouldn't have to build up one big explode - as it would have a primary sort by record, it then only needs to explode each record at a time. Eg. SSELECT BIGFILE BY @ID BY.EXP MV.ATTRIBUTE Or SSELECT BIGFILE BY.EXP MV.ATTRIBUTE Anyone know the answer to that one? 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/ --- 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/