This is a View definition I am trying to compile:

CREATE VIEW VU_SOME_VIEW (FIELD1, FIELD2)
AS
SELECT F1, 0 FROM TABLE1
UNION
SELECT F2, 2 FROM TABLE2
UNION
SELECT F3, 1 FROM TABLE3

And I am getting this error:
--------------------
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid command.
Data type unknown.
---------------------

FIELD1 is supposed to be a VARCHAR and FIELD2 is supposed to be
an integer. Naturally, F1, F2 and F3 are all VARCHAR type
fields, with F1 and F3 being 255 and F2 being 2000 in size, and
the value for the second field is an absolute integer value of
0, 1 or 2.
What could be wrong with the above View definition?
-
Anand

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com