0 - 3 of 3 tags for 6926

Hi,
I've been struggling to get the following piece of code to work - is there no way to get the working select statement below (See comment ** Working **) to work within a view?

Hi everyone,

I am trying to create a recursive view and get the ERROR

REPLACE VIEW Failed. 6926:  definitions, views, triggers or stored procedures. 

Added the code, has anybody any suggestions?

Thank you in advance.

I have a recursive query that begins with the text "WITH RECURSIVE".

The query works fine. When I try to use the exact query within a view, while creating the view I receive an error that says "REPLACE VIEW Failed 6926: definitions, views, triggers or stored procedures". I simply prefix the query with this text: REPLACE VIEW DB.VIEW_NAME AS LOCKING ROW FOR ACCESS and I get the error.

I can successfullly get the recursive view created if I use this text instead: REPLACE RECURSIVE VIEW DB.VIEW_NAME, and if I also remove the syntax "WITH RECURSIVE".