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
MSCEWI5003: PERIOD DEFINITION IS NOT APPLICABLE IN SNOWFLAKE.
Last updated
Was this helpful?