MVSFORUMS.com

pai_sunil_bs · Beginner Joined: 19 Sep 2005 Posts: 21 Topics: 11

Hi All,
I have a Online program which has DB2 queries.
I XPED this program.

The query has a DB2 Call.
CALL 'DSNHLI' USING SQL-PLIST4.

I find that the control does not return to the program after the call.

However, I hit F3 and again come back to the same program, I see that the control has come back, the DB2 call is excuted and the control has come to the next statement of the program.

This query runs fine in SPUFI.

All other DB2 queries run in the program runs fine.

Any pointers as how to resolve it.

kolusu · Posted: Mon Sep 19, 2005 8:01 am Post subject:

pai_sunil_bs · Beginner Joined: 19 Sep 2005 Posts: 21 Topics: 11

"Are your sure its PF3?"
YES. and it is not PF9 or PF12

"This query runs fine in SPUFI. "
The DB2 Query is replaced by CALL statements by the Precompiler.
In Xpeditor, We normally see the Query being commented out and is replaced by the CALLs (the one which I mentioned).
Ex:-
SELECT * FROM EMP
will have a corresponding CALL say
CALL 'DSNHLI' USING SQL-PLIST4.

So in my example:-
SELECT * FROM EMP works fine in SPUFI.
While the control never returns to the program after the execution of the CALL(i.e. CALL 'DSNHLI' USING SQL-PLIST4)
Hope I got my question right this time.

Sorry for the confusion.

SureshKumar · Intermediate Joined: 23 Jan 2003 Posts: 211 Topics: 21

pai_sunil_bs,
You say it's an online program, have you made sure that its pointing to the correct load library?(DSNCLI alias DSNHLI) Moreover, the first sql execution goes thru the Call to connect, why not set a breakpoint at the SQLCODE(F9) and check if the control comes back.