Re: .NET Provider Meta Data GetSchema()

-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-
bounces@xxxxxxxxxxxx] On Behalf Of Craig Pelkie

http://msdn.microsoft.com/en-us/library/y53he2tz.aspx

Thanks, but that doesn't tell me anything about what the list of qualifiers
is for the restrictions as implemented by the iDB2 provider. For example,
the following couple were easy to figure out via educated guesses:

DataTable tbls
String[] tblsFilter = new string[] {"LIBNAME"}

DataTable cols;
String[] colsFilter = new string[] {"LIBNAME", "TABLENAME"}

Using (iDB2Connection cn = new iDB2Connection("MyConnString"))
{
cn.Open();
tbls = cn.GetSchema(iDB2MetaDataCollectionNames.Tables, tblsFilter);
cols = cn.GetSchema(iDB2MetaDataCollectionNames.Columns, colsFilter);
cn.Close();
}

So there are some obvious choices, but I'd like to know what filtering
options I might be missing. The .NET driver for DB2 v9.x on Win/Nix provides
a specific collection (iDB2MetaDataCollectionNames.Restrictions) that can be
examined for the list of qualifiers, but the iDB2 driver does not implement
that collection.