By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,784 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,784 IT Pros & Developers. It's quick & easy.

Identifying IDENTITY columns via the SQLDA

P: n/a
I'd like to be able to identify IDENTITY columns via the SQLDA.

Looking up the DESCRIDE TABLE statement in DB2 OS/390 Ver7.1 SQL
Reference doesn't mention that the SQLDA will contain any information
about IDENTITY columns.

Is this an oversight by IBM?

Alternatively, does anyone know of a smart way to find this
information other than querying the Catalog?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
I don't know how much of that information CLI exposes. But at least on
DB2 UDB V8 for LUW a "full" or "extended" describe returns IDENTITY
information (along with many other things). Possibly this was added only
on DB2 UDB V8 for zOS (?)
Check out the CLI docs and look for describe....

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.