Multiple choice technology

what would be the result of the below expression? If Num(Arg1) Then 'Y' Else 'N' where Arg1 = '' [Empty]

  1. Y

  2. N

  3. Will cause run time error

  4. Returns Empty
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Num() function converts an empty string to 0, which evaluates as truthy in the conditional check. In DataStage BASIC, the expression If Num(Arg1) Then 'Y' Else 'N' returns 'Y' because Num('') = 0, and 0 is treated as a valid numeric value that passes the conditional test.

Keep practicing — related questions