back porting from DB2 UDB V8 Unix to DB2 v7.2 on zOS

Hi,

We performing backporting of one of our applications from
DB2 UDB V8 Unix to DB2 v7.2 on zOS.

Can somebody say, if the following queries make sense on
DB2 v7.2 on zOS? At least several of syscat views we are
using seems not to be available on DB2 7.2 on zOS.

There is a full list of queries we need:

1) select schemaname from syscat.schemata order by schemaname

2) select tbl.tabname, tbl.tabschema, 'BASE TABLE', tbs.tbspace
from syscat.tables tbl, syscat.tablespaces tbs
where type = 'T' and tbl.tbspaceid = tbs.tbspaceid and tbl.tabschema = :user
order by tbl.tabname"

3) select colno, colname, typename, length
from syscat.columns
where tabname = :table and tabschema = :user
order by colon

4) select constname, tabschema, tabname, definer, refkeyname,
reftabschema, reftabname, deleterule, updaterule, fk_colnames, pk_colnames
from syscat.references where tabname = :table and tabschema = :user

5) ALTER TABLE ownerName.tableName ADD CONSTRAINT Constname
FOREIGN KEY Fk_colnames REFERENCES Reftabschema.Reftabname
(Pk_colnames)
ON DELETE NO ACTION ON UPDATE NO ACTION;

6) ALTER TABLE ownerName.tableName DROP FOREIGN KEY FK_Constname;

Thanks.
David.

davidgorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ghp7000Commented:
i think you have to query the sysibm tables in zOS
0
davidgorAuthor Commented:

It's nice comment :-) but what tables do I need?

In addition, on Unix we have used syscat views which are views for
sysibm tables.
0
ghp7000Commented:
this link explains all the catalog tables in Z os:
http://publibz.boulder.ibm.com/epubs/pdf/dsnsqh11.pdf

in unix windows, the catalog table setup is different, the syscat views are available, but you can still query the sysibm tables

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.