0 - 4 of 4 tags for recursive view

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 guys,
 I have issues regarding recursive queries...
1)  can we create a view over a recursive view in teradata.
2) and I have to implement a view which has two recursive queries which are dependent on derived tables.,
please suggest solution asap

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".