Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / October 2008

Tip: Looking for answers? Try searching our database.

IDS 11 problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil Truby - 29 Oct 2008 21:12 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:

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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.