Period Clause

Description

Specifies that a period clause applies to the target of the delete operation

Click here to navigate to the IBM DB2 docs page for this syntax.

Snowflake does not support period clause. The output Query can be malformed.

Grammar Syntax

FOR PORTION OF BUSINESS_TIME: Specifies that the delete only applies to row values for the portion of the period in the row that is specified by the period clause

Sample Source Patterns

IBM DB2

DELETE FROM
table1
FOR PORTION OF BUSINESS_TIME FROM '2022-05-09-16.20.17.0' to '2022-05-09-16.20.17.0'

Snowflake

DELETE FROM
PUBLIC.table1
-- ** MSC-ERROR - MSCEWI5003 - PERIOD SPECIFICATION IS NOT SUPPORTED IN SNOWFLAKE. **
--              FOR PORTION OF BUSINESS_TIME FROM '2022-05-09-16.20.17.0' to '2022-05-09-16.20.17.0'

Related EWIs

PreviousCommon Table ExpresionNextCorrelation Clause

Last updated