Hi ! In some cases, I am not noticing comments in the view definition stored in data dictionary (DBC.TABLES.REQUESTTEXT column) or thru SHOW VIEW command after I execute REPLACE view statements containing comments in SQL assistant. The comments are truncated/dropped for some reason. As mentioned this behavior is not consistent though. I am using TD SQL Assistant 13.10.0.02 with Teradata .Net provider version 220.127.116.11 to connect to the database. Did any one experience similar issue ?
In some cases (in ODBC i think it's based on the "Disable Parsing" setting) all comments are removed by the client tool and/or ODBC, etc. before submitting a query.
What usually worked was submiting the individual statements using F9/Execute parallel.