[jira] [Commented] (TRAFODION-3094) Add Syntax and Examples for *DELETE Statement* in *Trafodion Reference Manual*

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-3094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16530598#comment-16530598 ] 

ASF GitHub Bot commented on TRAFODION-3094:
-------------------------------------------

Github user DaveBirdsall commented on a diff in the pull request:

    https://github.com/apache/trafodion/pull/1587#discussion_r199651804
  
    --- 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 --
    
    Keeping it is fine.


> Add Syntax and Examples for *DELETE Statement* in *Trafodion Reference Manual*
> ------------------------------------------------------------------------------
>
>                 Key: TRAFODION-3094
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3094
>             Project: Apache Trafodion
>          Issue Type: Documentation
>            Reporter: Liu Yu
>            Assignee: Liu Yu
>            Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)