Indeed. One of the great things about UniVerse and UniData is that you can use SQL against your files. SQL is a great way to do quick updates too (carefull, it is a very sharp knife).
If you don't have a good SQL book, get one. I have the advantage of being required to support a couple of Micro$oft SQL servers along with the UniVerse machines. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Saturday, May 01, 2004 3:15 AM To: 'U2 Users Discussion List' Subject: RE: [UD] Union Query Gordon J. Glorfield wrote: > In that case, I'm sorry to say, there is no way to logically do what > you're asking with UD. Gordon, you should now better! ;^) sql> SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT sql> NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no "." dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken >> -----Original Message----- >> From: Burwell, Edward [mailto:[EMAIL PROTECTED] >> LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP >> >> or >> >> LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP >> >> How would a virtual dictionary know which file to get the NAME >> ADDRESS CITY and STATE from? -- 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