Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers