Create view problem...
INFORMIX-4GL - Application.
INFORMIX-OnLine - Server.
Text of program:
...
CREATE VIEW s_phone AS
SELECT phone.*
FROM phone
WHERE phone.owner = USER...
Runtime error:
SQL statement error number -217.
Column (user) not found in any table in the query.
But USER is built-in function! Next SQL-statement should not produce error:
SELECT phone.*
FROM phone
WHERE phone.owner = USER
I have no problem using such program with INFORMIX-SE.
Who can help me to understand this?