Each of the constants is interpreted as a single column containing the single value. The column V1 will contain the single value 8.
|
|
The constant 2 is interpreted as a column containing the same number of rows as the column V1, with each row containing the constant 2. The column V2 will contain each value of V1 multiplied by 2.
|
|
The constant "ing" is interpreted as a column containing the same number of rows as the column V1, with each row containing the constant "ing". The column V2 will contain each of the text strings in V1 concatenated with "ing".
|
|
The expression AVG(V1:V3) evaluates to a constant value, say x. The constant xis interpreted as three columns containing as many rows as the shortest column of V1, V2, or V3. Each cell contains the constant x. The output columns, V4-V6, will contain the values from columns V1-V3 divided by x.
|
|
Copyright IBM Corporation 2012. All Rights Reserved.
|