Can you use the output of the SQL SELECT in UV/UD?
Thanks.
Steve
At 05:14 PM 5/1/04 +1000, you wrote:
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 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
------ Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America
-- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users