Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

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

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
The whole ODBC idea - To date my database stuff is with access databases, and I have no real appreciation with using ODBC. My VB6 application: Developing code to be run on a Win2000 machine that needs to read/write certain records in a Foxpro database. However the ..

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

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 statements. I'm converting a web site over to another server and I'm having syntax issues as I've just switched....

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

Automate ODBC DSN Setup - I have been thinking of using VBscript to automate the set up of the ODBC DSN entries. There are some discussions on the Internet that I can find. Unfortunately, none of them gives me any hints on how I can store the username (such as sa) and passwor...
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada)
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



[ Contact us | Terms of Service/Privacy Policy ]