I have a DELETE spufi in my job. usually for SQL 100 or SQL 0, It will CC0
However, I see today it returned CC4 for SQL100 and I could not find any difference in SYSPRINT
Only this below warnings are new .. Any pointers why it returned CC4.
P.S : no changes in table or job
SQLWARNING ON DELETE COMMAND, PREPARE FUNCTION
SQLWARNING ON DELETE COMMAND, EXECUTE FUNCTION
I have a DELETE spufi in my job. usually for SQL 100 or SQL 0, It will CC0
However, I see today it returned CC4 for SQL100 and I could not find any difference in SYSPRINT
Only this below warnings are new .. Any pointers why it returned CC4.
P.S : no changes in table or job
SQLWARNING ON DELETE COMMAND, PREPARE FUNCTION
SQLWARNING ON DELETE COMMAND, EXECUTE FUNCTION
---------+---------+---------+---------+---------+---------+
SELECT DATE ('2024-02-28') - 6 YEAR FROM SYSIBM.SYSDUMMY1 ;
---------+---------+---------+---------+---------+---------+
---------+---------+---------+---------+---------+---------+
28.02.2018
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+
---------+---------+---------+---------+---------+---------+
DSNE614I AUTOCOMMIT IS NO; NO CHANGES COMMITTED
SELECT today’s date, it gives warning messages.
SELECT CURRENT DATE - 6 YEAR FROM SYSIBM.SYSDUMMY1 ;
---------+---------+---------+---------+---------+---------+---------+--
---------+---------+---------+---------+---------+---------+---
SELECT CURRENT DATE - 4 YEAR FROM SYSIBM.SYSDUMMY1 ;
---------+---------+---------+---------+---------+---------+---
---------+---------+---------+---------+---------+---------+---
29.02.2020
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---
