Re: [Q} Temp tables in 4GL. Any restrictions?

>From: snowak@co.alameda.ca.us >Date: Wed, 19 Apr 95 15:56:39 PDT >X-Informix-List-Id: <news.13186> > >Need some help. CREATE statement in code fragment below is source of -4373 >error during 4GL complilation. But it compiles (and executes) just fine when >'Primary Key' constraint is taken off. Any suggestions. Thanks. Stanley Nowak. > >FUNCTION tarfu_1 > > CREATE TEMP TABLE temp01 ( > t_1 CHAR(08) PRIMARY KEY, > t_2 DATE, > t_3 INTEGER, > t_4 CHAR(30))> >END FUNCTION There is one relevant restriction and one semi-relevant restriction: (1) The 4GL compilers (p-code and c-code) do not understand any SQL syntax not supported by 4.1x ESQL/C. That applies to 5.0x and 6.0x (and 7.0x) SQL syntax. Specifically, it does not understand PRIMARY KEY -- that is a 5.0x feature. This is bug B32601 -- not fixed and not yet scheduled to be fixed. (2) You cannot declare PRIMARY KEY constraints with names on temporary tables (error -576). You also cannot declare triggers or referential constraints (error -548). This is only semi-relevant since you do not name your primary key constraint. Even if you got past the 4GL compiler, the Engine would rebuke you if the statement tried to name the primary key. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>