By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,333 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,333 IT Pros & Developers. It's quick & easy.

compare the tables between TEST and DEV

P: 1
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
Share this Question
Share on Google+
2 Replies


kestrel
Expert 100+
P: 1,071
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 100+
P: 404
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.