Create View error - UDFCALLNAME

Database
vmg
Fan

Create View error - UDFCALLNAME

Hi,

I am creating a new view in Teradata using SQL Assistant 14.10 and my syntax is -


CREATE VIEW 3M_APP.FT_CLAIMS AS LOCKING ROW FOR ACCESS 

(SELECT * FROM ETL_PROD. FT_CLAIMS WITH CHECK OPTION);

I am getting error message - Create view failed. 3707 syntax error, expected something like a name or a unique delimited identifier or an 'UDFCALLNAME' keyword between the 'VIEW' keyword and the integer '3'.

Please let me know how I need to modify it.

Thanks for all the help. 

Tags (2)
2 REPLIES
vmg
Fan

Re: Create View error - UDFCALLNAME

I was able to fix the issue after adding dobule quotes (") around the database and table names as - "3M_APP"."FT_CLAIMS"

Thanks.

Enthusiast

Re: Create View error - UDFCALLNAME

Teradata doesn't allow you to use initial numerics to name an object.  The band-aid you've applied by adding the quote marks (") around the object name allow the view to be created, but every user, tool or application will have to apply the quote marks in every reference to this this view.

A better fix would be to rename the view, eliminating the leading numeric.