create a view using WITH

General
Enthusiast

create a view using WITH

The Teradata 14.0 DDL manual shows that you can do the following, using a common table

create view rdptest

as

(

with test1 (clnt_cd,clnt_id)

as (select clnt_cd,clnt_id from dbatest_core_tb.clnt)

select clnt_cd,clnt_id from test1

)

;

I keep getting a syntax error, *** Failure 3707 Syntax error, expected something like a 'SELECT' keyword o

 r '(' or a 'NONTEMPORAL' keyword or 'AS' keyword or '(' between '(' and the '

 with' keyword.

Tags (2)