Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
from where i can get the list of cataloged datasets for a particular user
Do you mean those datasets that have the userid in the dataset name? What if these are datasets that do not have the userid in the dataset name (i.e. 99% of "my" datasets do not have any id in the dsn)?
Your original post was in the db2 part of the forum. Is your question somehow related to db2?