tempfname = "/tmp/SUBSCRIPTION_INITIAL_LOAD-#{DateTime.now.strftime("%Y-%m-%d-%H-%M-%S-%L")}.txt"
#finalfname = "/mnt/rhapdrive/SUBSCRIPTION_INITIAL_LOAD/SUBSCRIPTION_INITIAL_LOAD-#{DateTime.now.strftime("%Y-%m-%d-%H-%M-%S-%L")}.txt";
finalfname = "/mnt/rhapdrive/SUBSCRIPTION_INITIAL_LOAD/";

File.open(tempfname, 'wb') do |file|

  results = DB["select top_secret_sql_query"].each do |r|

  now = DateTime.now.strftime("%Y%m%d%H%M%S")

  file.write("\x1c"\
"MSH|^~\\&|||||#{now}||ADT^A01^ADT_A01|#{r[:UnitNumber]}-#{now}-SANIL|P|2.6\r"\
"EVN|A04|#{now}\r"\
"PID|||#{r[:UnitNumer]}^^^ECMC||#{r[:Name]}||#{r[:BirthDateTime]}|#{r[:Sex]}|||#{r[:Address1]}^#{r[:Address2]}^#{r[:City]}^#{r[:State]}^#{r[:PostalCode].to_s[0..4]}||#{r[:Telephone]}||||||#{r[:UniquePublicIdentifier].to_s.gsub(/\D/,"")}\r"\
"PD1||||||||||||U\r"\
"PV1|||#{r[:zLocation]}|1|||#{r[:zLocation2]}\r")

  end
end

FileUtils.mv(tempfname, finalfname)