Hello,
I'm trying to write a function to retrieve the application names and application ids from the output of the db2 command "list applications show detail".
I'm thinking about a table function which returns a table with 2 columns (appName and appId).

Would you suggest a way to do it?

look in schema sysibmadm
there are different views that return this data
Supported administrative SQL routines and views

hi,

function in this link ;
DB2 Universal Database

example;

select * from table(SNAPSHOT_APPL_INFO('',-1)) a

Thanks Kazahel,
that's exactly what I was looking for