RE: Primary Index
BUT if you really want to see the primary Index.. Create a secondary index on the ID of the file. Les (I'm sure it was Brian that tolds me to do that) Hewkin -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: 26 April 2004 10:43 To: 'U2 Users Discussion List' Subject: RE: Primary Index uniVerse has no primary index. All items are stored using a hashing algorithm applied to the primary key so there is no need to index it. The only way to access these is to SELECT the file. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 26 April 2004 10:35 To: U2 Users Discussion List Subject: Primary Index I can access a file containing the Secondary indecis, but is it possible to access the Primary index file? Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO Müller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A Müller, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp 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 This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How far can U2 scale?
Over 6000 users across 700 sites. Universe HP superdome. £1.5 billion turnover. Uniobects used for VB apps. Loads of greens. Lots of happy user. Not bad for a UK company. Les. -Original Message- From: Dawn M. Wolthuis [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 14:50 To: [EMAIL PROTECTED] Subject: How far can U2 scale? At what point in the life of application software would it be so large that you could not (or would not want to) support it with your existing UniData or UniVerse database? Is there a point where you would be better served by DB2 or Oracle, for example due to the scale you are working with? I hear people talk about moving way from U2 in order to do ODBC and use standard industry tools (and most find that the grass is not greener for those purposes), but I don't hear about switching because of running into scaling issues. However, we sometimes think of PICK as addressing small-to-mid size businesses and RDBMS folks sometimes think of their products as scaling the best. So, what's the cut-off for U2? Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] Re: GUI from Mv code Re: Crystal Reports
And it was YOU that bought it! m coffee... need more.. Les :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 19 April 2004 11:12 To: [EMAIL PROTECTED] Subject: [OT] Re: GUI from Mv code Re: Crystal Reports Well, let's see... the new car automatically unlocks all the doors when I get in (my wife thinks the carjackers'll love that one), I have to stand on the brake pedal to get it to start, the window decides for itself to go all the way down when I just want it down a crack, and the turning radius sucks. But, hey, that's progress. It's new and improved. Anyway, ignore this as the grumblings of an old codger whose coffee hasn't overcome the arthritis yet this morning. ;^) Regards, Charlie Noah [EMAIL PROTECTED] writes: Change to the process flow is many times the impetus to replace a module or application in the first place. Change is not always terrible, although feared. In truth I have found the fear to be more in the hearts of the IT person who has tweaked the system over the past 15+ years and is insulted that their masterpiece is being considered a dinosaur ready for replacement. How dare they! You don't think that way when you replace your car now do you? You generally move into a newer improved model that outperforms the car you left behind. It may react a little differently, but overall the performance is better. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Modern Universe - was: The lists are closing
Joe, It must be hard for you being so good and perfect!!! The rest of us just have to muddle along in our boring old pick jobs. Oh well, time to go home and dream about all those lucky people working on big boy systems. But then again Les "over paid, under worked and happy" Hewkin -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: 30 March 2004 16:34 To: U2 Users Discussion List Subject: RE: Modern Universe - was: The lists are closing Damn it... Don't you anything something better to do! Moderator Stopped this Thread! > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Dennis Bartlett > Sent: Tuesday, March 30, 2004 8:45 AM > To: 'U2 Users Discussion List' > Subject: RE: Modern Universe - was: The lists are closing > > Joe, GET A LIFE. > > We're pickies, we don't need to understand XML, or whatever, > so long as > we can do what's required of us. Yeah, we could learn XML, > if required. > I guarantee I could write a proggie to do just about > anything, interface > with anything, natively "bond" with any database... With > Pick-style > products. > > Yes, Oracle can do things fast - only it takes yonks to > develop, has to > live within limitations, costs a bomb, requires big process > power. > > Hell, even AS400 can do things, that's why they were built. > > It's just that mine can do ANY thing, no limitations, very > little > processing power (R83 on a single 286), costs? What costs? > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On Behalf Of Joe Eugene > Sent: 29 March 2004 06:27 > To: U2 Users Discussion List > Subject: RE: Modern Universe - was: The lists are closing > > > > We have UV doing everything on the BackEnd, we also have > MSSQL Server to > Support Data Warehousing... Why 2 Databases Systems? > Cause UV Cant support Data Warehousing? > Doesn't this eventually introduce Disparate Systems? > > > U2, for example, has support for Java connectivity, XML, > and I believe > > > they either have or are working on Web Services support > > Its funny you say the above, UV/PICK Guys in our Team didn't > even > understand the basics of XML.. leave alone XPath, XQuery > etc. These > Technologies are NATIVELY Supported in ORACLE/DB2 Etc. > > e.g. We pull XML Reports from our Vendors Real Time. I have > to parse > through the XML and give UV/PICK Guys a FLAT TEXT File... > cause either > UV Cannot handle the storage and Retrival of XML Data Using > XPath/XQuery > Techniques. > > Yes, we use DataStage to pull data out of UV Into MSSQL > SERVER... For > what? Why cant UV handle of the DB Job? > > As for Performance...UV Does NOT Perform Well in a OLTP > Environment, > SIMPLE: > IF UV did Perform Well...Today's Fortune 500 would depend on > UV and > UV/PICK would have been in the TOP 3 OF DataBases. > > Joe Eugene > > > > > > > -Original Message- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > On > > Behalf Of David T. Meeks > > Sent: Monday, March 29, 2004 9:37 AM > > To: U2 Users Discussion List > > Subject: RE: Modern Universe - was: The lists are closing > > > > While one could make the argument that Pick has not > embraced emerging > > technologies as rapidly as the 'Big Three', it HAS done > so. > > > > U2, for example, has support for Java connectivity, XML, > and I believe > > > they either have or are working on Web Services support (I > know, for > example, > > that > > the DSEngine in DataStage has support for Web Services). > > > > One could argue the need or purpose of supporting certain > technologies, > > and > > the level of support currently within the products, but to > say that > there > > is > > "little/no" support is a bit uninformed. > > > > The U2 products ARE supported in certain "Integration" > software. I > > wouldn't typically consider SAP/PeopleSoft "integration" > software. > > They are Enterprise > > Software Suites, but not geared particularly at > 'integration'. > > > > However, given that SAP and PeopleSoft OEM the DataStage > product sets > > for both of their "integration" products (SAP's BW, > PeopleSoft's EPM, > > JDEdwards stuff as well), and given DataStage works very > well with > both U2 > > products, this point is actually wrong. People who have > SAP or > PeopleSoft > > solutions CAN, very easily, integrate their U2 data > to/from those > > environments. > > > > As to 'efficiency', one can measure that in a variety of > different > > dimensions. From a memory/disk > space/footprint/administrative > > overhead > dimensions, > > the > > U2 database products are VERY efficient. > > > > Finally, as to being "slow", again this depends on the > measurement > > criteria being used. From the perspective of concurrent > user access > > and the performance > > of application style DB usage (largely input/output, > multiple > concurrent > > users, etc..), > > the U2 products stand up very well to the m
RE: Help with UniObjects
Are you connecting each time you access the universe database? Sounds a bit of over kill, why not just reuse the connection? We came across a feature that caused us some headaches, after you use a method you MUST check for errors, if you don't things don't work. Les -Original Message- From: UmFooFoo Murphy [mailto:[EMAIL PROTECTED] Sent: 29 January 2004 04:44 To: [EMAIL PROTECTED] Subject: Help with UniObjects Hello List. I'm hoping that someone out there can help me. I have an application in Visual Basic that uses UniObjects. There is a text box that prompts for a record id. In the lost focus event of the record id's text box, I am opening a file, reading a record, and populating all of the other text boxes on the form. At the end of the SUB, it closes the file, and disconnects from the ObjSession. Sounds easy enough right? Wrong! The first pass through goes fine. I enter an ID and the boxes are populated. However, when I go back to enter a second record id, it appears that the .OPENFILE method in the lost focus event fails. The FileObj is set to NOTHING. However, the .ERROR property of the ObjSession is set to 0 (zero) so it also seems that no error occurred. Either way, I cannot use the File Object as all of the subsequent methods of the File Object fails. I have searched the UVDocs documentation and, according to it, I am using all of the objects and methods correctly. Universe 9.6.1.3 on NT Thanks, in advance, for any help that anyone can offer. _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
