Using db2expln first time for packages.
It works fine when there are tables however it fails whenever it has reference to GTT....
How are access plans created in case of GTT's ......
Didn't get what Incremental Bind is ?

-------------------- SECTION ---------------------------------------

Section = 15





Statement:

VALUES(

(Select Count(*)

from SESSION.TEMP_PUPILDETAILS))INTO :HV00025 :HI00025

Incremental Bind Section
Error revalidating section:
SQL0727N An error occurred during implicit system action type "5".


Information returned for the error includes SQLCODE "-204", SQLSTATE


"42704" and message tokens "SESSION.TEMP_PUPILDETAILS". SQLSTATE=00000




-------------------- SECTION ---------------------------------------

SQLCODE -204 is for an undefined name. The system does not know what the GTT is. Try defining it first.

Andy

The problem is that db2batch establishes a new connection to DB2. Thus, it cannot know anything about the GTT you may have defined in another connection.