473,405 Members | 2,349 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

db2 catalog question

I couldn't find the forum for db2 so I am posting my question here. I am trying to query the catalog tables in db2 for Z/OS version 7 and I was going through the documentation for sysibm.systabconst table. the possible values for the 'type' column in this table are P Primary key, U Unique key and the documentation for unix/windows also gives F = Foreign key
I = Functional dependency
K = Check
P = Primary key
U = Unique. Is there no value for foreign key in the Z/OS version? I cannot check it directly because I don't have access to a Z/OS system. anyone who has worked on this earlier, please comment
Oct 2 '06 #1
0 1098

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

Similar topics

2
by: Jefferis NoSpamme | last post by:
I am looking at an old query and I cannot remember or figure out what this part of the query means: `Catalog`.item like '%A\-%' It is the like '%A\-%' I cannot figure out. Then entire...
2
by: Simon Strandgaard | last post by:
I am trying to understand how to create a 'catalog.xml' file for my docbook-xml documents. If I understand correct a local catalog.xml file can both avoid hardcoding in makefiles (portability),...
6
by: Vincent Lefevre | last post by:
I would like to know if the base URI considered to resolve an unparsed entity defined by a relative URI should be the URI before or after its rewriting due to a possible catalog. Let's take an...
6
by: Chuck | last post by:
What's the difference between using "catalog node" and catalog admin node"? -- Chuck Remove "_nospam" to reply by email
1
by: hype | last post by:
Hi, could anyone explain the relationship between the "Catalog cache heap" in the db2mtrk output and the database config parameter catalogcache_sz. Thanks, Hype.
3
by: mike | last post by:
On DB2 EEE v8.2 on Linux/Windows/Unix, is there any catalog view that I can query with SQL to find tablespace-state? The state is not visible via SYSCAT.TABLESPACES. The state is visible by...
2
by: sandeep.manthena | last post by:
Hi everyone, Can anyone answers my questions. My server is AIX and is 5.2 and the db2 udb of V 8.1 Fixpak 9. What exactly is the tools catalog for? How it is uaseful in performing automatic...
0
by: Laurence | last post by:
Hi folks, I used the following CLP commands to access DB2/400 in AIX 5L/DB2 EE, and it works. CATALOG TCPIP NODE AS400 REMOTE 192.168.10.51 SERVER 446 SYSTEM PROD400 OSTYPE OS400 CATALOG...
11
by: fishmonger1972 | last post by:
Hi! I'm a librarian with a little PHP knowledge.. I'm trying to make a catalog from scratch for my library. I don't like the look of the current catalog so I'm trying to make a custom PHP/MySQL...
1
by: mvsguy | last post by:
DSN810.SDSNSAMP(DSNTIJIC) backs up the DB2 catalog. Is there an example out there of how to restore it? Regards, MVSGuy
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.