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

FAQ

Profile

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

Database Help (Home) -> Visual Basic -> ODBC

Related Topics:

The whole ODBC idea - To date my database stuff is with access and I have no real with using ODBC. My VB6 code to be run on a Win2000 machine that needs to certain records in a Foxpro database. However the ..

LDAP query from ODBC? - I'm trying to build a query to pull some from my LDAP based on a user ID. Dim conLDAP As Dim strSQL As String Dim As String Dim rsUser As Set conLDAP = New ..

ODBC Access reference material - Hi there, I was wondering if there was some kind of online reference as the the syntax used for a Microsoft ODBC Access driver's SQL I'm a web site over to another server and I'm having syntax issues as I've just

ODBC CONNECTION FROM COMMAND LINE - I am trying to get an ODBC created from a I have created the ODBC exported the registry key, and have tried doing regedit /s problem is after I do that it never shows us in the ODBC manager, it shows up in..

Automate ODBC DSN Setup - I have been thinking of using VBscript to automate the set up of the ODBC DSN entries. There are some on the Internet that I can find. none of them gives me any hints on how I can store the username (such as sa) and

Next: do I need client?

Author

Message

D.R.

External

Since: Nov 02, 2006
Posts: 1

(Msg. 1) Posted: Thu Nov 02, 2006 2:10 am Post subject: Use ODBC API to retrieve indexes and keys on AS/400 Archived from groups: microsoft>public>vb>database>odbc (more info?)

hi, 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)? Thanks, Dror >> Stay informed about: Use ODBC API to retrieve indexes and keys on AS/400

Display posts from previous:

	Database Help (Home) -> Visual Basic -> ODBC	All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum