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