The constant 100 is interpreted as a column containing the same number of rows as the column CURR_BAL, with each row containing the constant 100. The derived field PERCENT_UTILIZ will contain each value of CURR_BAL multiplied by 100 and divided by each value of CREDIT_LIM.
|
|
The constant "Mr." is interpreted as a column containing the same number of rows as the column LAST_NAME, with each row containing the constant "Mr.". The derived field NAME will contain each of the text strings in LAST_NAME prefaced by "Mr.".
|
Copyright IBM Corporation 2015. All Rights Reserved.
|