1. Creating UniSQL compliant dictionary items. Have a look at the command CREATE.SQL which will set up the relevant items in a compliant fashion e.g. dashes become underscores.
2. When we did this, we set up separate VOC pointers to the files of interest with separate dictionaries. The create.sql will populate the dictionary and you can add and remove freely to this dict. 3. Changes to files. To access the sql data remotely via OLEDB/ODBC requires the unirpc service to be enabled. 4. Uniobjects is not required to use unisql from the udt session (Umm.. I'm assuming UNIX not so sure on windows, don't think so) The documentation around the schema API may also be of use to you. Good luck! Nick -----Original Message----- From: Fawaz Ashraff [mailto:[EMAIL PROTECTED] Sent: 21 April 2004 16:11 To: U2 Users Discussion List Subject: How to SQLize the a UniData table! Hi All, We are trying to use UniSQL to retrieve data from a UniData file. Since this is our first attempt, need to know how to create Dictionary items which will work with UniSql statement. I also need to know whether this should be done for all the dictionary items in the file or only the one we are planning to use with UniSQL. Are there any changes to be made to the UniData configfile? Should we have UniObject to use UniSQL? Cheers Fawaz __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users