MVSFORUMS.com

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Hi All,

How can I know the PDS load module name where stored procedures are resided.

kolusu · Posted: Tue Apr 26, 2011 9:13 pm Post subject:

yadav2005,

Untested Sql

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Kolusu,

I did try to run your query but I do not get any PDS name , am I missing anything here.I did check for the column EXTERNAL_NAME but could not make out.Can you help me where I am wrong in my understanding.

kolusu · Posted: Wed Apr 27, 2011 10:31 am Post subject:

yadav2005,

The question is what did you get from the external_name ? if the catalog table is not updated, compile an existing SP and look at the JESMSGLG and find out the PDS name

Kolusu

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Thanks Kolusu your solution helped me and I was able to get the required information.

kolusu · Posted: Thu Apr 28, 2011 10:35 am Post subject:

yadav2005,

Can you share as to how you got the required information?

Kolusu

yadav2005 · Intermediate Joined: 10 Jan 2005 Posts: 348 Topics: 144

Kolusu,

Can you please help me know with the name of the dataset which I can use.My understanding is that ,there is a dataset that comes with DB2 when it is installed that contains sample programs and sample compile JCL. I would like to know the sample JCL in that dataset to compile user defined functions.

dbzTHEdinosauer · Posted: Fri Apr 29, 2011 3:59 pm Post subject:

usually it is some form of DSN910.SDSNSAMP - where the 910 refers to the db2 version that you are running.

obviously, these can/are/could be renamed by your dba when installed.

ask your dba's.
_________________
Dick Brenholtz
American living in Varel, Germany