× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Matt,

Thanks for the information. I went into Navigator and looked at the table definition. There it was, "Is Identity" as one of the columns related to the columns in the table. I guess I will need to start using Navigator more.

I also just discovered that the DSPFFD command does show the information as well. We have a home grown LSTFFD command that we always use, so we never use DSPFFD. I guess I need to update our command or use DSPFFD.

Dean Eshleman
Software Development Architect

Everence Financial
1110 North Main Street
PO Box 483
Goshen, IN 46527
Phone: (574) 533-9515 x3528
www.everence.com<http://www.everence.com>


On 10/15/2012 2:25 PM, Matt Olson wrote:
Look at the DDL is the easiest way. Go into navigator, double click on the table and investigate the column in the GUI. Alternatively you can right click the table and generate the SQL Script which will create the DDL script and you can tell from that.

In MS SQL there is a stored procedure called "sp_help" which gives table information, I don't think an equivalent exists in DB2. I believe you are forced to utilize the DB2 catalog views to get the same type of information.






________________________________________
Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.
_______________


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.