Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1587#discussion_r192292864
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -4342,6 +4363,45 @@ DELETE FROM invent.partsupp WHERE suppnum NOT IN
delete from table1 where a in (select a from table1 where b > 200)
```
+* This example executes a non-transactional delete of first 1000 rows that
satisfy the
+WHERE condition.
++
+```
+DELETE WITH NO ROLLBACK [FIRST 1000]
+FROM test
+WHERE id<30;
+```
+
+* This example shows that the option `WITH NO ROLLBACK` is only supported
if there is no
+index on the table.
++
+```
+SQL>DELETE WITH NO ROLLBACK FROM test;
+
+*** ERROR[3232] INSERT, UPDATE, or DELETE of table TRAFODION.SEABASE.TEST
with dependent Index : TRAFODION.SEABASE.INDEX_TEST is not allowed when NO
ROLLBACK transaction setting is in effect. [2018-05-30 05:42:47]
--- End diff --
Should I delete or keep the example?
---
