static long Orginal_IBM_Provider() { Stopwatch watch = Stopwatch.StartNew(); DB2Connection connection = new DB2Connection(_cliDSN); connection.Open(); DB2Command cmd = new DB2Command(); cmd.Connection = connection; //cmd.CommandText = "select * from syscat.columns"; var parameter = cmd.CreateParameter(); parameter.ParameterName = "@TABSCHEMA"; parameter.Value = "SYSTOOLS"; //cmd.Parameters.Add(parameter); //DB2DataAdapter da = new DB2DataAdapter(cmd); cmd.CommandText = "select XML1 from DB2INST1.STRINGTYPES1"; //cmd.CommandText = "SELECT a.PKID, a.TblType, a.Code, a.Description, a.AmountValue, a.LegacyCode, a.IsSysTable, a.GroupCode, a.UpdUserID, a.UpdDatetime, a.UpdNumber, a.Code || ' - ' || a.Description as CodeAndDescription, (CASE WHEN b.Description IS NULL THEN '' ELSE b.Description END) as TblTypeDesc FROM AP.Lookup a LEFT OUTER JOIN AP.Lookup b ON(b.TblType = 'TBL_TYPE' and b.Code = a.TblType) WHERE a.IsActive = 'Y' ORDER BY a.Description"; //DataTable dt = new DataTable(); //da.Fill(dt); var reader = cmd.ExecuteReader(); var schema = reader.GetSchemaTable(); while (reader.Read()) { var r = reader.GetName(0); var xml = reader.GetString(0); } //DB2DataAdapter da = new DB2DataAdapter(cmd); //DataSet ds = new DataSet(); //da.Fill(ds); //watch.Stop(); return(watch.ElapsedMilliseconds); }