The syntax below is fine in 7 and 10, but fails in 11.10 (or 11.5). Any
ideas? PMR 56544 019 866 refers:
Database selected.
Routine created.
Table created.
217: Column (date_last_updated) not found in any table in the query (or
SLV is undefined).
Error in line 5
Near character position 31
Database closed.
**********************************************************************************
create procedure "informix".last_upd() returning datetime year to minute,
char( 8);
define date_last_updated datetime year to minute;
define last_update_user char(8);
let date_last_updated = current;
let last_update_user = user;
return date_last_updated, last_update_user;
end procedure;
{ TABLE "root".list row size = 35 number of columns = 4 index size = 25 }
create table "root".list
(
name char(10) not null ,
item char(10) not null ,
date_last_updated datetime year to minute
default current year to minute not null ,
last_update_user char(8)
default user not null ,
primary key (name,item)
) lock mode row;
--revoke all on "root".list from "public" as "root";
create trigger "informix".list_upd update of name,item on "root".list
for each row
(
execute procedure "informix".last_upd() into
"root".list.date_last_updated,
"root".list.last_update_user);
Fernando Nunes - 29 Oct 2008 23:47 GMT
> The syntax below is fine in 7 and 10, but fails in 11.10 (or 11.5). Any
> ideas? PMR 56544 019 866 refers:
[quoted text clipped - 45 lines]
> "root".list.date_last_updated,
> "root".list.last_update_user);
"LIST" is a reserved word. It's causing ambiguity in the parser.
It should also be reserved in v10, but as you know there were code changes in
the way triggers are managed...
You may get IBM to open a BUG, but if you could change the table name you'd
solve it and avoid future issues. I have my doubts that this can be considered
a BUG, but it looks as it break previous behavior...
Regards.

Signature
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
Neil Truby - 30 Oct 2008 01:36 GMT