public static IEnumerable <string> GetSrcmbrLines(
string SrcfName, string SrcfLib, string SrcmbrName)
{
var userDsn = ClientSettings.GetCachedOdbcDsn();
var userName = "******";
var password = "******";
var lines = new List <string>();
using (var conn = OpenConnection(userDsn, userName, password))
{
var aliasCmd = conn.CreateCommand();
aliasCmd.CommandText = "create or replace alias qtemp.demo3r for " + SrcfLib +
"." + SrcfName + "(" + SrcmbrName + ")";
aliasCmd.ExecuteNonQuery();
var cmd = conn.CreateCommand();
cmd.CommandText = "select srcseq, srcdat, srcdta " +
"from qtemp.demo3r " +
" order by srcseq ";
using (OdbcDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string srcseq = reader.GetString(0);
string srcdat = reader.GetString(1);
string srcdta = reader.GetString(2);
lines.Add(srcdta);
}
}
}
return(lines);
}
