Values Clause

Description

Derives a result table by specifying the actual values, using expressions or row expressions, for each column of a row in the result table. hin

The Values clause is not supported in Snowflake, for this reason, the Values Clause will be translated to a select as shown in the examples below.

Grammar Syntax

Sample Source Patterns

The Values clause is not supported in Snowflake. For this reason, the values clause is translated to a select query.

IBM DB2

SIngle Rows

VALUES

1, 2, 3

Result

1

2

3

Snowflake

Single Row

SELECT

1, 2, 3

Result

1

2

3

For the values with multiples rows an Union is used:

IBM DB2

Multiple Rows

VALUES

(1, 1, 1),

(2, 2, 2),

(3, 3, 3)

Result

1	1	1
2	2	2
3	3	3

Snowflake

Multiple Row

SELECT

1, 1, 1

UNION

SELECT

2, 2, 2

UNION

SELECT

3, 3, 3

Result

1	1	1
2	2	2
3	3	3