Skip to Content
0

What DDL works for ALTER VIEW or CREATE VIEW in BODS SQL transformation for MSSQL 2016

Nov 01, 2016 at 04:29 PM

130

avatar image

DROP VIEW and both DDL/DML statements for TABLES, CONSTRAINTS and INDEX we have no problems executing.
But ALTER VIEW and CREATE VIEW DDLs fail.
Errors we get are "CREATE VIEW' must be the first statement in a query batch" or Incorrect syntax near the keyword 'SELECT' (the "select 1 ab" statement at the end that is required) or Prepared statement is not a cursor-specification.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers