469,936 Members | 2,343 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,936 developers. It's quick & easy.

SQLWARN output

When I run the following SQL statement via SPUFI on z/OS, I recieve a
"W" in SQLWARN6 which says "Contains W if the result of a date
calculation was adjusted to avoid an impossible date".

SELECT DATE('2008-02-29') - 1 YEAR FROM SYSIBM.SYSDUMMY1;

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
But when I run the same sql via the DB2 command window pointing to
z/OS, the SQLCA indicates no warning.

C:\Program Files\SQLLIB\BIN>db2 select date('2008-02-29') - 1 year
from sysibm.sysdummy
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -204 sqlerrml: 15
sqlerrmc: SYSIBM.SYSDUMMY
sqlerrp : SQLNQ1FB
sqlerrd : (1) -2145779603 (2) 0 (3) 0
(4) 0 (5) -10 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 42704

The same output is in the SQLCA if I run against a local database on
LUW.

Should the command window be populating the SQLCA the same as on z/OS?

Oct 25 '06 #1
0 2343

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mark Wilson CPU | last post: by
3 posts views Thread by edgekaos | last post: by
4 posts views Thread by Kevin Mansel via .NET 247 | last post: by
24 posts views Thread by kalamantina | last post: by
reply views Thread by newbie | last post: by
3 posts views Thread by MatsL | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.