MVSFORUMS.com

venus · Beginner Joined: 02 Jun 2006 Posts: 16 Topics: 11

let us suppose a db2 table has been modifed ( a new coloumn is added or droped) . how can we identify all the programs that will be affected(how can we identfify all the programs that it is using this paticlar modifed table)

kolusu · Posted: Tue Jun 13, 2006 1:35 pm Post subject:

venus,

I already mentioned twice about posting feedback and yet you seem to ignore them. You will no longer receive any answers on this board.

Thanks

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

venus · Beginner Joined: 02 Jun 2006 Posts: 16 Topics: 11

can you explain me what feed back you want

skolliboina · Beginner Joined: 03 Jul 2006 Posts: 1 Topics: 0

The below query should help to find out the impacted programs

SELECT A.NAME , A.CREATOR , A.CLUSTERTYPE
FROM SYSIBM.SYSTABLES A
WHERE A.TYPE IN ( 'T' , 'G' ) AND A.NAME = 'TABLE_NAME'
ORDER BY A.NAME ASC , A.CREATOR ASC