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:
&sys isql -Uuser -Ppassword < sqlfile
You may also type:
&sys sqlplus user/password @sqlfile