Hi,

Could someone please  answer of my 2nd question with respect to SQL query in IBM i ,

" What about the Procedures, Sub procedures and copybooks can we get that information using this utility? or is there any standard IBM i SQL query which can provide this information?" 

I had asked it in this thread "https://community.ibm.com/community/user/power/discussion/regarding-dsppgmref#bma5dac39b-d7a8-403b-a900-018d90d2bcd9"  

If this is not the correct group to ask then could someone please advise in which group to ask this question here or help to repost it in appropriate group here?

Thanks

------------------------------
jerry ven
------------------------------

#SQL

There are IBM and Db2 Services that may deliver what you want.

All IBM and Db2 Services (available on your System can be found) within the SERVICES_INFO table (in the QSYS2 schema). The table also includes for each Service an example.

For detailed documentation, you may check the online library:

1. Db2 Services: https://www.ibm.com/docs/en/i/7.5?topic=optimization-db2-i-services
2. IBM Services: https://www.ibm.com/docs/en/i/7.5?topic=optimization-i-services

------------------------------
Birgitta Hauser
Database and Software Engineer
Selfemployed - Modernization-Education-Consulting on IBM i
Kaufering
+49 170 5269964
------------------------------

Hi,

Please see my reply on your original thread for how to get help on this open source utility...

------------------------------
Christian Jorgensen
IT System Administrator
Network of Music Partners A/S
------------------------------