Re: CREATE PRIVATE SYNONYM

>From: jean@aim1.aztec.co.za (Jean Ramsay) >Subject: CREATE PRIVATE SYNONYM >Date: Mon, 25 Oct 1993 18:15:57 GMT >X-Informix-List-Id: <news.4708> >According to the release notes ENGREL_5.0 it is now possible to create a >private synonym. >I can get it to work with ISQL version 4.1, but not from r4gl or i4gl 4.1 - >it just gives a syntax error at compile time. Has anyone managed to get >it to work from either 4gl? I really need to use the statement to upgrade >a system written on version 2.1 which uses synonyms extensively. >Any help will be appreciated. >Thank you >Jean Ramsay jean%aim1.aztec.co.za@uct735.uct.ac.za >Aztec Information Management, Cape Town, South Africa The 4.1x coders were not prescient and did not build into the 4.1x I4GL products the syntax for the 5.0 tools. Further, 4.12 I4GL is most unlikely to recognize such 5.00 syntax. And, in fact, neither is 6.00 I4GL, though that's because it is boot-strapped off 4.12 source and has the minimum necessary changes to support the 6.00 engines without having to go via a relay module -- this should change with a maintenance release of 6.00 I4GL. To get 5.00 (or later) functionality out of 4.1x I4GL, you must use PREPARE and either EXECUTE (as in this case) or DECLARE/OPEN/FETCH/CLOSE (eg for a cursory stored procedure). Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>