problem with create multiset volatile table

Question

If I run the following code, I get an error "'Create Table As' currently does not support Identity columns'...

CREATE MULTISET VOLATILE TABLE EVENT AS (SEL evt.*

from DB.Event evt inner join DB.lkp_Event_tp TP on evt.Event_tp_cd = TP.Event_tp_cd and evt.orig_src_sys_cd = tp.orig_src_sys_cd and evt.orig_src_sys_cd = 3) WITH NO DATA ON COMMIT PRESERVE ROWS;

so I've been given the hint to do this...

CREATE MULTISET VOLATILE TABLE EVENT AS select * from (SEL * from ....) b WITH NO DATA ON COMMIT PRESERVE ROWS;

but now the error has changed to "Syntax error - expected something like a name or a Unicode Delimited identifier....between 'AS' keyword and the select keyword.

What could be the issue here?

Thank you

Blockquote

question from:https://stackoverflow.com/questions/65897928/problem-with-create-multiset-volatile-table

Answer 1

Waitting for answers