DB2 UDB for z/OS SQL Compatibility

4.6 DB2 UDB for z/OS SQL Compatibility

This table describes DB2 UDB for z/OS compatibility.

Table 4-1 describes how Oracle database and the gateway handle SQL functions for a DB2 UDB for z/OS.

Table 4-1 SQL Compatibility, by Oracle SQL function

Oracle SQL Function	Compatible	Translated	Compensated	Native Semantics Candidate
`ABS`	-	-	Yes	Yes
`ACOS`	-	-	Yes	Yes
`ADD_MONTHS`	-	-	Yes	-
`ASCII`	-	-	Yes	Yes
`ASIN`	-	-	Yes	Yes
`ATAN`	-	-	Yes	Yes
`ATAN2`	-	-	Yes	Yes
`AVG`	Yes	-	-	-
`BITAND`	-	-	Yes	Yes
`CAST`	-	-	Yes	Yes
`CEIL`	-	`CEILING`	-	Yes
`CHARTOROWID`	-	-	Yes	-
`CHR`	-	-	Yes	Yes
`CONCAT`	Yes	-	-	-
`CONVERT`	-	-	Yes	Yes
`COS`	-	-	Yes	Yes
`COSH`	-	-	Yes	Yes
`COUNT(*)`	Yes	-	-	-
`COUNT (DISTINCT colname)`	Yes	-	-	-
`COUNT (ALL colname)`	Yes	-	-	`COUNTCOL`
`COUNT (column)`	Yes	-	-	`COUNTCOL`
`DECODE`	-	-	Yes	Yes
`DUMP`	-	-	Yes	Yes
`EXP`	-	-	Yes	Yes
`FLOOR`	Yes	-	-	Yes
`GREATEST`	-	-	Yes	Yes
`HEXTORAW`	-	-	Yes	Yes
`INITCAP`	-	-	Yes	Yes
`INSTR`	-	-	Yes	Yes
`INSTRB`	-	-	Yes	Yes
`LAST_DAY`	-	-	Yes	-
`LEAST`	-	-	Yes	Yes
`LENGTH`	-	-	Yes	Yes
`LENGTHB`	-	-	Yes	Yes
`LN`	-	-	Yes	Yes
`LOG`	-	-	Yes	Yes
`LOWER`	Yes	-	-	`LCASE`
`LPAD`	-	-	Yes	Yes
`LTRIM`	-	-	Yes	Yes
`MAX`	Yes	-	-	-
`MIN`	Yes	-	-	-
`MOD`	-	-	Yes	Yes
`MONTHS_BETWEEN`	-	-	Yes	-
`NEW_TIME`	-	-	Yes	-
`NEXT_DAY`	-	-	Yes	-
`NLS_INITCAP`	-	-	Yes	Yes
`NLS_LOWER`	-	-	Yes	Yes
`NLS_UPPER`	-	-	Yes	Yes
`NLSSORT`	-	-	Yes	Yes
`NVL`		`VALUE`
`NVL2`	-	-	Yes	Yes
`POWER`	-	-	Yes	Yes
`RAWTOHEX`	-	-	Yes	Yes
`REPLACE`	-	-	Yes	Yes
`REVERSE`	-	-	Yes	Yes
`ROUND`	-	-	Yes	Yes
`ROWIDTOCHAR`	-	-	Yes	-
`RPAD`	-	-	Yes	Yes
`RTRIM`	-	-	Yes	Yes
`SIGN`	-	-	Yes	Yes
`SIN`	-	-	Yes	Yes
`SINH`	-	-	Yes	Yes
`SOUNDEX`	-	-	Yes	-
`SQRT`	-	-	Yes	Yes
`STDDEV`	-	-	Yes	Yes
`SUBSTR`	-	-	Yes	Yes
`SUBSTRB`	-	-	Yes	Yes
`SUM`	Yes	-	-	-
`SYSDATE`	-	-	Yes
`TAN`	-	-	Yes	Yes
`TANH`	-	-	Yes	Yes
`TO_CHAR`	-	-	Yes	-
`TO_DATE`	-	-	Yes	-
`TO_MULTI_BYTE`	-	-	Yes	-
`TO_NUMBER`	-	`DECIMAL`	-	Yes
`TO_SINGLE_BYTE`	-	-	Yes	-
`TRANSLATE`	-	-	Yes	Yes
`TRIM`	-	`STRIP`	Yes	Yes
`TRUNC`	-	-	Yes	Yes
`UID`	-	-	Yes	-
`UPPER`	Yes	-	-	`UCASE`
`USER`	-	-	Yes	-
`USERENV`	-	-	Yes	-
`VARIANCE`	-	-	Yes	Yes
`VSIZE`	-	-	Yes	Yes

Parent topic: Developing Applications