Problem solve Get help with specific problems with your technologies, process and projects.

How to substitute Purchase for 'P' and 'Manufacturing' for 'M' .

How to substitute Purchase for 'P' and 'Manufacturing' for 'M' and default 'Administration' for ' '(blank) in SQL/400 SELECT statement.

A CASE statement can be used in a SELECT statement to achieve this. Here is an example:

 SELECT EMPNO, LASTNAME, FIRSTNAME,
       CASE  EMP_DIV
        WHEN 'H' then 'Human_Resource'
        WHEN 'I' then 'Information_tech'
        WHEN 'P' then 'Purchase'
        WHEN 'M' then 'Manufacturing'  
           ELSE 'ADMINISTRATION' 
       END AS DIVISION
FROM EMPLOYEE; 

EMP_DIV can be replaced with SUBSTR expression to include part of String in field EMP_DIV.


Dig Deeper on RPG iSeries programming

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close