|
View previous topic :: View next topic
|
| Author |
Message |
germanyrajesh
New User
Joined: 09 May 2023
Posts: 17
Location: Norway
|
|
|
|
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
DSNT417I SQLWARN0-5 = W,,,,, SQL WARNINGS
DSNT417I SQLWARN6-A = W,,,, SQL WARNINGS |
|
| Back to top |
|
 |
germanyrajesh
New User
Joined: 09 May 2023
Posts: 17
Location: Norway
|
|
|
|
| germanyrajesh wrote: |
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
DSNT417I SQLWARN0-5 = W,,,,, SQL WARNINGS
DSNT417I SQLWARN6-A = W,,,, SQL WARNINGS |
Found the possible reason 
SELECT yesterday date, No warning messages.
---------+---------+---------+---------+---------+---------+
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 ;
---------+---------+---------+---------+---------+---------+---------+--
---------+---------+---------+---------+---------+---------+---------+--
28.02.2018
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT418I SQLSTATE = 01506 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSN SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
DSNT417I SQLWARN0-5 = W,,,,, SQL WARNINGS
DSNT417I SQLWARN6-A = W,,,, SQL WARNINGS
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
Today’s date – 4 gives no warning messages.
---------+---------+---------+---------+---------+---------+---
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
---------+---------+---------+---------+---------+---------+--- |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
