Ray, I see you are doing a few things here, am not quite sure i understand.
The only way i have OUR UV Programmers using BASIC/PICK do this is like SELECT [FILENAME] WITH [FIELDNAME] LIKE 'SARA]' (NOTE **]* - Syntax might a bit OFF) Something like the above produces a CASE-INSENSITIVE Search and returns all the below Sara sarra saRraA etc. The UPCASE and LOWCASE only Returns those results right? So in your Experience, would you say SQL Interface is Faster than any other Interface within UV? Thanks, Joe Eugene >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Behalf Of Ray Wurlod >Sent: Wednesday, March 31, 2004 3:57 PM >To: U2 Users Discussion List >Subject: RE: Modern Universe (TESTING) > > >On this basis here are the RetrieVe equivalents for my earlier >post. The main difference is that there's more than one verb (for >different query result formats) and the selection criterion begins >with the keyword WITH rather than WHERE. And the pattern matching >specifiers are different (for example ... rather than % for >multi-character wildcard). > >verb PEOPLE NAME WITH NAME CONV "MCU" LIKE "SARA..." >verb PEOPLE NAME WITH EVAL "UPCASE(NAME)" LIKE "SARA..." >verb PEOPLE NAME WITH EVAL "OCONV(NAME)" LIKE "SARA..." >verb PEOPLE NAME WITH EVAL "UPCASE(LEFT(NAME))" = "SARA" > >where verb can be any of: >LIST SORT columnar report >SELECT SSELECT Select List >LIST.ITEM SORT.ITEM raw format >LIST.LABEL SORT.LABEL mailing labels >REFORMAT SREFORMAT target is second file/table >COUNT >SUM not really relevant for NAME > >HTH >----- Original Message ----- >From: "Joe Eugene" <[EMAIL PROTECTED]> >Date: Wed, 31 Mar 2004 15:33:20 -0500 >To: "U2 Users Discussion List" <[EMAIL PROTECTED]> >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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users