SQLWARN output

[johnl]

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?