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.


"Davy C" <(E-Mail Removed)> wrote in message
newsFDD8EC7-57EA-46B9-B917-(E-Mail Removed)...
> 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!