MAINFRAME - TIP OF THE DAY :
Q. If there is a situation, where we need to code more than 255 steps in a JOB?
A. We need to split jcl into two jcls , at the end of the first jcl check the condition code and initiate the second jcl.
Programmers Voted for below topics. Please Vote for good Posts.
Thank You! for your feedback. Connecting to the server. Please Wait...
Theres a way to know the referential integrity constarints specified for the tables created by DBA's using the DB2Administration tool. Just type DB2A in teh command line and go browse the table. Give ddl against the table and it will list down teh sql query for the same. There you can find it out.
But if you dont use this tool Sorry will think of other alternative
With DB2-FileAID also we can find the PRIMARY & FOREIGN keys...
--> Mention Object Name & Object Type and select TABLE
--> I command against table (I --> Information)
-->Index Key Information(In this select Unique Key for Primary Key)
--> Related Table Information to get Foreign Key Information
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum