Error: DBMSEXECUTE returns 'sql statement failed to parse'
Solution or Workaround
DBMSEXECUTE fails with the following message:
sql statement failed to parse
The DBMS-specific statement is not understood by the ARC/SQL lexicon. ArcInfo tries to parse the SQL statement with DBMSEXECUTE commands. If it is a non-SQL statement (it is DBMS specific), ArcInfo is not able to parse the statement.
Create a simple text file (example: sqlfile) with the DBMS SQL statement using the AML [WRITE] function. To run the statement from Arc type: