Archives of the TeradataForum

Message Posted: Mon, 23 Jan 2006 @ 23:03:37 GMT

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

I am using SQL Assistant 7.0 and when try to create a view, the comment lines inside of the view disappear!

It works on the earlier verison but not on 7.0.

Is there a setting I need to turn on for this version to show/accept comment lines, or is this a bug with this version of SQL Assistant?

ex:

     REPLACE VIEW  database.viewname
     -- CREATED FOR .............
     -- CONTAINS ONLY ................
     -- ELIMINATED .....................
     --  1/13/06
     AS LOCKING ROW FOR ACCESS
     SELECT
      ...
     ...
     ...
     FROM
     .......
     WHERE
      .............;

When run this, I get:

     REPLACE VIEW  database.viewname
     AS LOCKING ROW FOR ACCESS
     SELECT
     ...
     ...
     ...
     FROM
     .......
     WHERE
     .............;

Thanks,

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