MVSFORUMS.com

[cappertan]

Hi:

1. I am trying to run this query:
WHERE A.PAT_ID > ' '
AND A.PAT_ID = B.PAT_ID
AND BP_SYSTOLIC > 0

I get a systax error of :
DSNE610I NUMBER OF ROWS DISPLAYED IS 0
DSNT408I SQLCODE = -413, SQLSTATE = 22003, DATA EXCEPTION FROM OS/2.

2. Then I tried:
WHERE A.PAT_ID > ' '
AND A.PAT_ID = B.PAT_ID
AND DECIMAL(BP_SYSTOLIC) > 0

I get same. systax error of :
DSNE610I NUMBER OF ROWS DISPLAYED IS 0
DSNT408I SQLCODE = -413, SQLSTATE = 22003, DATA EXCEPTION FROM OS/2.

BP_SYSTOLIC is defined as a float. The database is UDB and I am
using DB2 Spufi to do the query.

What am I doing wrong
_________________
Capp

[kolusu]

Cappertan,

Are you performing any calculations with the BP_SYSTOLIC field? You are getting that error because an overflow occured due to numeric data conversion.

check this link for a detailed explanation of sql code -413

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.142?SHELF=&DT=20010718150520&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[cappertan]

Kolusu:

No calculations. Just trying to find rows where this is greater than 0.
I tried NOT Null but got the same error. Will check the IBM site.
_________________
Capp

[kolusu]

cappertan,

Post your complete SQL. Also post the defintion of the column

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[cappertan]

Column Definition:
COLNO COLTYPE LENGTH
------+---------+------
12 DOUBLE 8


Entire query:

***************************** Top of Data **
SELECT A.PAT_ID,
DECIMAL(BP_SYSTOLIC,3) AS BP_SYS
FROM HCCLCO.PAT_ENC A, HCCLCO.IDENTITY_ID B
WHERE A.PAT_ID > ' '
AND A.PAT_ID = B.PAT_ID
AND DECIMAL(BP_SYSTOLIC) > 0
ORDER BY UPDATE_DATE DESC
_________________
Capp

[kolusu]

cappertan,

Your decimal function is having a precision of only 3 digits. Increase it to a bigger value so that it will accomadate the value of BP_SYSTOLIC.