Archives of the TeradataForum

Message Posted: Tue, 08 Apr 2003 @ 18:56:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Yes, I just tested it in V2R4.1.2... I can create a database called work ...

... but to create a view I must encase the name in double quote marks...

REPLACE VIEW "work"."CLASS"
 ( Class_ID
 , Dept_ID
 , Class_Desc
 , Integrity_Ind
 , Load_Date
 , Update_Date
 ) AS
 LOCKING proddb.CLASS FOR ACCESS
 SELECT
   Class_ID
 , Dept_ID
 , Class_Desc
 , Integrity_Ind
 , Load_Date
 , Update_Date
 FROM proddb.CLASS;

To use the view I must do the same...

Select * from "WORK".CLASS;

You get an error if you try it without the quotes

Select * from WORK.CLASS;

3707: Syntax error, expected something like a name between the 'VIEW' keyword and the 'work' keyword.

	<Prev	Next>		<<First	<Prev	Next>	Last>>