467,185 Members | 1,276 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,185 developers. It's quick & easy.

compare the tables between TEST and DEV

How do we compare the output's between tables between 2 environments, TEST & DEV in db2 mainframe using spufi...can we use

SELECT * FROM SYSIBM.SYSTABLES WHERE NAME LIKE ....

(You could join this to SYSCOLUMNS to look at the fields....)...can anyone give me an idea please
Aug 15 '07 #1
  • viewed: 1138
Share:
2 Replies
kestrel
Expert 1GB
How do we compare the output's between tables between 2 environments, TEST & DEV in db2 mainframe using spufi...can we use

SELECT * FROM SYSIBM.SYSTABLES WHERE NAME LIKE ....

(You could join this to SYSCOLUMNS to look at the fields....)...can anyone give me an idea please
Hey Rekha, Welcome to The Scripts. Im going to move this to the DB2 forum. Have a nice day!
Aug 15 '07 #2
Purple
Expert 256MB
Hi rekha555 and welcome to TSDN DB2 Forum

What are you trying to confirm by the comparison ? Database layout, data is identical ?

Regards Purple
Aug 15 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by xixi | last post: by
1 post views Thread by Prakash RudraRaju | last post: by
8 posts views Thread by Vincent | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.