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);
}
