Archives of the TeradataForum

Message Posted: Mon, 26 Oct 2009 @ 20:30:26 GMT

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

Can functions be nested in views that are used to insert? I assume not and a macro would be necessary.

     --example table

     CREATE TABLE
     sehager_example
     (c1 VARCHAR(20) CASESPECIFIC)

     --example view

     CREATE VIEW
     sehager_example_insert
     (c1)
     AS
     SELECT
     UPPER(c1)
     from
     sehager_example
     ;
     --insert fails with 3823:  VIEW 'sehager_example_insert' may not be used for Help
     Index/Constraint/Statistics, Update, Delete or Insert.
     INSERT
     sehager_example_insert
     (c1)
     VALUES
     ('abc')
     ;

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