差分

==[[DB2 文字列 数値変換]]==[[DB2]] | {{category [[Category:書式}}{{category SQL}}]]*[[DB2 CHAR関数による書式変換]]

===INTEGERINTEGE[[R]], INT===

SELECT INTEGERINTEGE[[R]](EMPNO) FROM F[[R]]OM DSN8710.EMP;

===REAL[[R]]EAL===

SELECT EMPNO, REAL(REAL(SALARY)/COMM[[COM]]M) FROM F[[R]]OM DSN8710.EMP WHERE COMM [[COM]]M > 0;