How to use the PDTBATCH SRCSQL% parameter & how will the output look?

Document ID : KB000029450
Last Modified Date : 14/02/2018
Show Technical Document Details

1) Regarding the Input into the PDTBATCH job, the SRCSQL parameter can be entered like so:

   //SYSIN    DD  *        

   . ..

   NORMALIZE=Y 

   EXPLAIN=Y 

   SRCSQL=N  

2) Regarding the Explain file output, when the SRCSQL parameter is omitted it appears as so for this SQL statement:

    SRCSQL   = (     

    SELECT  ? , USERID  

    FROM TEAM        

    WHERE NAME = ?    

    ORDER BY ?        

              )     

   With the SRCSQL parameter set to 'N', the Explain file output for the SQL statement appears like so:

   SELECT  ? , USERID

      FROM TEAM      

     WHERE NAME = ?  

     ORDER BY ?      

              ;