MVSFORUMS.com

[pai_sunil_bs]

Hi All,
I had posted a query with the title:- "Problem with DB2 Call"
I am posting this, since the issue is still not resolved. Although we got some clues. Hope someone can resolve this.

I have a Query:-
SELECT COUNT(*)
FROM TABLE_NAME
WHERE
<Code>
AND EFF_DT <= '2005-12-01'

The above query runs fine in Xpeditor.

I change the date to '2012-12-01'

The DB2 call never returns to the program.

i.e.
PERFORM SQL-INITIAL UNTIL SQL-INIT-DONE
CALL 'DSNHLI' USING SQL-PLIST4.
Here the control never returns to the program after CALL.

All the other queries in the program runs fine in Xpeditor.
The same query runs fine in SPUFI.

I have kept Breakpoints, But the control never returns to the program.

Is there any possibility of corrupt data causing this problem. In that case How can we find it out?

Any Pointers on this is highly appreciated.

[Bithead]

If the query runs fine in SPUFI then it is not a data problem. Did you try contacting Compuware? Dou you have a DB2 monitor product that you can use to watch the query as it is running?