Re: SE synonym to another SE database table

>>>>> On 3 Aug 1993 00:48:22 -0400, obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler) said: >>Is it possible to create a synonym from one SE database system to: >> 1 another SE database on the same machine. > No, but you could use a link (symbolic or hard) between the C-ISAM > files in database1.dbs and database2.dbs to achieve the same effect. Maybe you missed the entries in the system catalog? Files in a database directory (linked or not) are ignored by SE if they are not registered in the catalog tables. The only names recognised directly are the system catalog files themselves (sys*.dat and sys*.idx). I guess linking files and manually inserting the corresponding entries in the system catalogs would be dangerous at least. Separate entries (one for each database) would point to the same file. It should crash on the first occasion of ALTER TABLE (SE files are renamed then). Please correct me if I'm wrong here. -- Oliver Okrongli infix Software-Systeme GmbH Phone +49 531 238090 Rebenring 33 Fax +49 531 2380935 oliver@infix.de 38106 Braunschweig F.R. Germany