• No replies
1 Post

Pinned topic invoke CLP command from stored procedure

‏2013-04-30T09:07:15Z |


Hi All,

I'm very new to DB2. 

I need to write a c# program to query and list all the database name inside a db2 server. I would like to know what is the best way to do it?

From what i had survey, the only way is using CLP command to call "LIST DB Directory".

My question is what is the right way to call "LIST DB DIRECTORY" from stored procedure. Hence, i would call the stored procedure which indirectly invoke the CLP command.

Hope anyone can help.

Thanks a lot.