470,631 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,631 developers. It's quick & easy.

Use ODBC API to retrieve indexes and keys on AS/400

i need to retrieve all indexes and keys from tables and files.
right now i'm using SQLStatistics, but it retrieve only the indexes on
tables (indexes that appear on the catalog sysindexes).
i need to retrieve also the key fields in physical file.

1. how can i retrieve the key field in physical file through ODBC?
2. Is there another AUTOMATIC way retrieving the key field? for example
a way to AUTOMATICLY transofrm the key field into index (so that
SQLStatistics will retrieve it)?

Nov 2 '06 #1
0 1368

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Nico den Boer | last post: by
7 posts views Thread by robertbrown1971 | last post: by
5 posts views Thread by Alec | last post: by
4 posts views Thread by Eric E | last post: by
1 post views Thread by Markus Neifer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.