datastage Transformation 函數之 UpCase和DownCase

Downcase(column):

                  此函數将輸入的字元串轉換為小寫

input = 'This is me'
input1 = 'this is me'
input2 = 'THIS IS ME'
           

DownCase(input)    =  'this is me'
DownCase(input1)   =  'this is me'
DownCase(input2)   =                  'this is me'      

Upcase(column): 

                   此函數将輸入的字元串轉換為大寫

input = 'This is upper case function'
input1 = 'this is me'
input2 = 'THIS IS ME'
           

UpCase(input)    =  'THIS IS UPPER CASE FUNCTION'
UpCase(input1)   =  'THIS IS ME'
UpCase(input2)   =                  'THIS IS ME'