Period Clause

Description

Specifies that a period clause applies to the target of the update 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 update 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

UPDATE PUBLIC.TABLE1
	SET Column1 = 1
	WHERE CURRENT OF cursor1
	                        

Snowflake

UPDATE PUBLIC.TABLE1
	SET Column1 = 1
	WHERE
-- ** MSC-ERROR - MSCEWI5009 - POSITIONED CURRENT OF IS NOT SUPPORTED. **
--	      CURRENT OF cursor1
	                        

Related EWIs

1. MSCEWI5003: PERIOD DEFINITION IS NOT APPLICABLE IN SNOWFLAKE.