In fact, that's a great way to make bulk updates (very sharp knife...). I use the SQL interface to do quick edits because I never learned the proper way to do those with the native tools (aside from writing a program).
Performance aside, I think you'll find there are a lot of surprises within UniVerse (UniData too I'm sure, no experience there for me though). It does support ODBC, OLEdb, XML, http and a few other interaces I know nothing about. It also does not care if you use one of the many "flavours" of native interface or the more standard SQL interface. If your going to compare UniVerse to other database systems, you should take into account that UniVerse is capable of taking the nastiest oldest Pick stuff from it's native hardware environment, and running on a spiffy new Unix (or "cough", Windoze) box. In order to do this, you smiply have to move the data, maybe do a recompile (not always) and probably do a resize of the data files. This is a big deal for a business that sells "widgets" and does not want to deal with too much technology stuff. It's not uncommon to see UniVerse and UniData sites that have running production code and data with a multi decade history behind it. Don Kibbey Financial Systems Manager Finnegan, Henderson, Farabow, Garrett & Dunner LLP >>> [EMAIL PROTECTED] 03/31/04 03:40PM >>> Joe, You can use an SQL query against normal UV files in the same manner you would agains tables. Cheers, Stewart -----Original Message----- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 April 2004 6:03 To: U2 Users Discussion List Subject: RE: Modern Universe (TESTING) Tim, My apologies... Yes, i know UV has a SQL Interface but i didnt think many UV Programmers used this Interface... As a matter of Fact, i like the UV SQL Interface. I have a PE Edition of UV on all my machines and i have only used the SQL Interface within UV. In our UV Shop, UV Guys are NOT supposed to use this SQL Interface as they claim its very slow than using the Native "SELECT WITH ....." I have read the UV Manual that reflects RDBMS, this manual explains you can setup Tables Exactly like any RDBMS using Data Types (Varchar, char, Int etc) All the the testing i have done does NOT involve using the SQL Interface in UV, Our UV Shop uses FILE Types, NOT RDBMS Tables and we use PICK/BASIC/REDBACK to Interfact with these FILES. Perhaps the problem might be our UV Shop using PICK/BASIC... Maybe the SQL Interface on UV is much faster. I dont know. Thanks, Joe Eugene ________________________________ From: [EMAIL PROTECTED] on behalf of Timothy Snyder Sent: Wed 3/31/2004 3:12 PM To: U2 Users Discussion List Subject: RE: Modern Universe (TESTING) Joe Eugene wrote on 03/31/2004 02:59:29 PM: > Please post your PICK/BASIC and SQL Query.. so we i can learn > the magic you did on the PICK Side. Joe, Unless I'm missing something, Sara used the SQL statement against the UniVerse database. Perhaps you weren't aware that UniVerse supports SQL statements to query the database. I don't think she used any "magic". Therefore, in her original post, she provided all the information you need to do a comparison. Also, you keep referencing PICK/BASIC. BASIC is the programming language, not the query language. There is also a native query language, but that's only one of many ways to access the database. I hope this helps to clarify your expectations. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services Office (717) 545-6403 (rolls to cell phone) [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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
