By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select service_level from sysibmadm.env_inst_info;
| SERVICE_LEVEL |
|---|
| DB2 v11.1.4.4 |
SELECT ACOS(-1) AS PI_a,
RADIANS(180) AS PI_b
FROM SYSIBM.SYSDUMMY1;
| PI_A | PI_B |
|---|---|
| 3.141592653589793 | 3.141592653589793 |
CREATE FUNCTION PI()
RETURNS DOUBLE
DETERMINISTIC
NO EXTERNAL ACTION
RETURN 3.141592653589793;
SELECT PI() FROM SYSIBM.SYSDUMMY1;
| 1 |
|---|
| 3.141592653589793 |