CASE tatement

[scorpion]

hi all,

how can i implement CASE Logic in datastage..

for ex: CASE when 'tan' then 'tango' when 'asc' then 'ascential'...like that

i hope it will wrks using 'if then else',but thinking to use CASE..


thanks in advance

[DSguru2B]

You can use case statements in basic routines. No case statements in the transformer, but you can achieve the same using if then else.

[ArndW]

The CASE statement is used in multi-line programs while the IF-THEN-ELSE can be done on a single line (i.e. in a stage variable or derivation).

The CASE in a BASIC program looks like

Code: Select all

   BEGIN CASE
      CASE I=AmTired 
         Ans = 'Goto Sleep'
      CASE Today='Tuesday'
         Ans = 'Only 3 days left to the weekend'
      CASE 1
         Ans = 'This is the catchall'
   END CASE

[ray.wurlod]

Most databases allow CASE constructs in SELECT statements. You can put the entire construct in the Derivation field in the Columns grid (rather than use user-defined SQL).

Code: Select all

CASE WHEN PROD_CODE = 'tan' THEN 'tango' WHEN PROD_CODE = 'asc' THEN 'Ascential' ELSE 'unknown' END AS PRODUCT