P
Paul Stearns
Guest
I am accessing an 11.7 OE Enterprise RDBMS. I have two simple queries, one which works another which doesn't. In the queries below the LAB_VALUE field is a varchar data type. The first query returns 106 rows with no issues. The second query dies immediately.
Query 1;
Query2;
The error received is;
I am at a loss. There is an KB atricle;
Progress KB - Invalid number string (7498) returned by SQL query on OE 10.2B
But it seems to refer to older versions of OpenEdge and specifically states 11.7 should correct the issue.
I am not a Progress DB person, and I only have access to query views in the DB as a specific R/O user.
Where do I go from here in troubleshooting?
Continue reading...
Query 1;
Code:
SELECT to_number(LAB_VALUE) LAB_VALUE
FROM labrec_view
WHERE lab_yr_mon = 202006 AND
FACILITY_CODE = 'BUF' AND
LAB_RESULT_CODE = 'ALBUMIN'
Query2;
Code:
SELECT to_number(LAB_VALUE) LAB_VALUE
FROM labrec_view
WHERE lab_yr_mon = 202006 AND
FACILITY_CODE = 'BUF' AND
LAB_RESULT_CODE = 'ALBUMIN' and
to_number(LAB_VALUE) > 4
The error received is;
Code:
SQLState=HY000
ErrorCode=-20232
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Invalid number string (7498)
I am at a loss. There is an KB atricle;
Progress KB - Invalid number string (7498) returned by SQL query on OE 10.2B
But it seems to refer to older versions of OpenEdge and specifically states 11.7 should correct the issue.
I am not a Progress DB person, and I only have access to query views in the DB as a specific R/O user.
Where do I go from here in troubleshooting?
Continue reading...