Can't retrieve any schema info in UDB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am hitting an AIX UDB 7 Database, and the problem I am having is that I am
not receiving what columns are the primary keys. I was previously hitting a
Mainframe DB2 database and it was working. Any clues.
I am trying to run these commands to retrieve the primary keys.
Dim keys() As DataColumn
keys = MainDataTable.PrimaryKey
For Each k As DataColumn In keys
Debug.WriteLine(k.ToString)
Debug.WriteLine("Unique: " & k.Unique)
Next

Does anybody know if it is a UDB setting that needs to be configured. BTW,
I have tried connecting with both ODBC and OleDB. Thanks!
 
What about using the IBM DB2 Connect .NET dataprovider? I know v8.2
installs with a VS.NET 2003 add-in as well. I know this add-in certainly
will show the remote schemas inside a UI window. I haven't a AIX db yet,
but isn't that what UDB means? ... universal. Just some thoughts, but not a
real answer. Best of luck.
 
Back
Top