Re: [ADMIN] [AD] Passing the Baton (Repeat)
I will be out of the office April 29, 2004 If this is an urgent matter you can call the helpdesk at ext 361. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VOC prompt issue?
Change your prompt A,ENTER BIN LOCATION TO LIST ITEMS FOR: adding the A, tell it to prompt ALWAYS. Marlene Yokoyama Applications Manager Waterpik Technologies 805 529-2000 ext 287 E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] 4/6/2004 9:47:47 AM I have this VOC item we run: ED VOC BIN.LOC 7 lines long. : P 0001: PA 0002: CLEARDATA 0003: CLEARSELECT 0004: SELECT INVMST WITH F12 = ENTER BIN LOCATION TO LIST ITEMS FOR: 0005: SELECT INVMST WITH WAREHOUSE = 1 REQUIRE.SELECT 0006: SELECT INVMST WITH F12 # '' REQUIRE.SELECT 0007: LIST INVMST BY F04 BY ITEM F04 F12 ITEM F13 F14 F28 T48 DOLR DOLS ID.SUP LPTR DBL-SPC HEADING SPECIAL FOR CHRISTINE...ALL ITEMS IN A SPECIFIC BIN LOCATION 'T' PAGE 'P' REQUIRE.SELECT Bottom at line 7. When it's run multiple times, the second time re-prints the first run without prompting for a new bin location. Logging off, which I suspect clears something or other, allows the person to run it on a second item. Any thoughts? -- 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: Modern Universe (TESTING)
Are you ever going to just go away..! So sick of this discussion! [EMAIL PROTECTED] 3/30/2004 3:56:28 PM Dave, I think the results point out the fallacy of your arguments. The results Sara posted here does NOT Prove anything, cause my results show the EXACT Opposite. So the deciding factor is to analyze what Sara wrote to come up with the results she posted Again post the code! Here is my code on MS SQL-SERVER that returns a resultset. Select firstName from Customers where firstName like 'Sar%'; RESULTS Machine: 950 MHZ Athlon Database: MSSQL SERVER 2K Records: 20 Million Indexes: NO Search Time: 2 Seconds What is your code on UV that returns the above results? If you can prove that UV Comes back in 5 Seconds under the above Conditions...I would be most happy to agree that UV is Competitive. Thanks, Joe Eugene -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 6:36 PM To: [EMAIL PROTECTED] Subject: RE: Modern Universe (TESTING) I think the results point out the fallacy of your arguments. It shows, pretty definitevly, that UV can and does perform as well/better as Oracle, albeit under certain circumstances (ie, I'm sure other kinds of queries could produce different results). It doesn't mean you will always get better performance, but rather, it offers competitive performance (better for some things, worse for others) However, one thing I did want to address is your QUAD processor point. You've made it a few times, and I just had to point out that it is irrelevant to the discussion. While UV will take native advantage of multi-processors in it's execution, a single query executed by a single user, especially such as that listed, will execute on a single processor, so no benefits will be seen for being on a QUAD (or a 64-way) machine. So, in reality, you are talking about the performance equivalent of operating on a single processor machine of whatever rating it has (and obviously, memory, other applications running, etc... impact that) Dave -Original Message- From: Joe Eugene To: U2 Users Discussion List Sent: 3/30/2004 6:07 PM Subject: RE: Modern Universe (TESTING) Sara, Can you please post your Query and results... Cause I am seeing the EXACT Opposite...as I posted earlier. Oracle Query is what? Select firstName from Customers where firstName like 'Sar%'; The above takes about 7-9 Times More Time to get any results on Our UV QUAD PROCESSOR MACHINE. Please post your PICK/BASIC Statement. Also you might want to dump the data in a separate table... other than something you use for other things. Thanks, Joe Eugene -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Tuesday, March 30, 2004 4:03 PM To: [EMAIL PROTECTED] Subject: Re: Modern Universe - was: The lists are closing I am probably in the best position to compare apples with apples. I have both UniVerse and Oracle on the same IBM p660 4 processor box with 6Gb RAM. The 800,000 customers are replicated from UniVerse to Oracle, although the Oracle version is only a subset of the attributes required by a different application. Both have an index on the first line of the Postal Address. My query was to show all customers with the first line of the Postal address like %EXPLORATION Results:- UniVerse 9 seconds Oracle 25 seconds Sara Burns Sara Burns (SEB) Development Team Leader Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. -- 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: Modern Universe - was: The lists are closing
Joe 1) Check again... one of IBM's partners is Epicore http://www.epicor.com/www/ which is using a Unidata database and XML technology in several of their products. 3) Our company has two divisions one on Oracle and one on Unidata. The Unidata side has two programmers compared to the 8 on the Oracle side to do the same thing.and we create great stuff and THEY have to try to follow us!! Total cost of an Oracle update cost more that our whole system cost from start to finish!! Just a few comments Marlene [EMAIL PROTECTED] 3/28/2004 7:24:04 PM PICK is LEGACY Technology and does NOT Support alot of advanced level computing we have today. I belive PICK is Similiar to Legacy DB2 that used ISAM type of DataBases Access. Even IBM has moved DB2 (Now UDB) to a completly relational architecture. I belive some of the below are good reasons to Migrate to MainStream (Top 3 - DB2/Oracle/MSSQL etc) Databases. 1. UV has Little/NO support for Emerging Technologies(XML/XQuery/XSLT/WML etc) 2. UV is Not supported in Most Integration Enterprise Software (SAP/PeopleSoft) 3. UV is Not efficient compared to highly evolved databases(DB2/Oracle) 4. UV Folks seem to use PICK, which is Not Compatible with many of of the Current Advanced Technologies and Techniques. 5. UV is very SLOW, TOO Procedural and Not the right tool for an OLTP Environment. It would be nice if IBM provided a Package to convert all UV Stuff to IBM DB2 and perhaps provide some kinda code converter to convert all pick stuff to DB2 Stored Procs or Java Native Compiled Procedures. I belive this would be ideal and would help corportations intergrate systems easily. Joe Eugene From: [EMAIL PROTECTED] on behalf of Phil Walker Sent: Sun 3/28/2004 7:59 PM To: U2 Users Discussion List Subject: RE: The lists are closing David, As the list is closing this is probably not off topic - so I will comment. I believe PICK has been around since the mid to late 1960's, whereas Oracle and the SQL relation model has been around only since the mid to late 1970's early 1980's if you are talking about Oracle etc. I may be wrong. Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Logan, David (SST - Adelaide) Sent: Monday, March 29, 2004 12:36 PM To: U2 Users Discussion List Subject: RE: The lists are closing Best of luck Jeff, however I will point out the obvious, what is your definition of modern? I would have thought the good old relational databases have been around since before pick anyway? 8-) 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 Jeff Ritchie Sent: Monday, 29 March 2004 8:03 AM To: U2 Users Discussion List Subject: RE: The lists are closing Thanks for the memories Cliff :) Sorry to hear the lists are closing, but what the heck time and tide, work committments etc. As some one who is shortly to be ex mv, and moving into the more modern technologies l will decline the offer to join, but wish the site all the best. Cheers, Jeff -Original Message- From: Moderator [mailto:[EMAIL PROTECTED] Sent: Saturday, 27 March 2004 7:14 PM To: U2 Users Discussion List; [EMAIL PROTECTED] Subject: The lists are closing Dear Friends: After 10+ years of either hosting or supporting the info-prime, info-unidata, info-vmark, info-informix, and u2-users etc lists, I have decided to shut down the list server. u2-users and u2-community will cease to exist as of 1 April 2004. IBM is officially supporting the efforts of the new U2UG.org group. (Yes. I am a member of the establishing Board of that group. So this is not a coup or Sour Grapes!) If you check out the forums that have been set up, I think you will will see that they cover everything anyone has asked for over the years in this group. I *really* want to encourage ALL of you to come over the the www.u2ug.org site and support this effort. This is *exactly* what many of you on this list have wanted over the years. If Not Now, When? Almost ten years on my Watch. How many years before that on Mike O'Rear's Watch? In the Net World, this has been a Hell of a good run. (I just
RE: Unidata Flashbasic
Whats the Wiki?? [EMAIL PROTECTED] 3/19/2004 8:49:02 AM David Wolverton wrote: if you compile a routine with UniData's Profiler Option 'on', the really interesting thing is that you can see where the system is spending a lot of time, or doing a lot of recursion - you can see clock time spent, CPU time spent, and number of times the subroutine was called. Would you be willing to post a HOWTO? Where do you set this option, what does the output look like? This sounds very interesting but is yet another thing that would take me half a day to figure out. If you sketch out the basics I'll fill in the details and put it on the Wiki. -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management -- 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
