|
View previous topic :: View next topic
|
| Author |
Message |
NAARAAYANAN
New User
Joined: 13 Aug 2012
Posts: 3
Location: INDIA
|
|
|
|
Hello,
could someone suggest me how to find the primary key in a table?
Thanks, |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Do you really mean a "database table" or do you mean a vsam file or something else?
As we repeat over and over - terminology is critical to effective q & a . . . |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| why not simply look at the application documentation/specifications ??? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
my fault for providing a db2 solution to a 'potential' db2 inquiry
in the vsam forum.
as anyone with more than 2 days experience knows,
if we are talking about vsam and primary key,
then IDCAMS LISTCAT will provide the location of the primary key,
and from that,
one only needs to go to the vsam record stucture definition,
to determine what fields comprise the key. |
|
| Back to top |
|
|
|
|
