I would like to create a bteq script which will read data from a table and attach it as a .Xml or Flat file to am email and that email will be sent to specified users.
Is this possible?
Could yoiu please guide me on this.
One way using bteq is export the data to file in a specified directory. In the same script, use mailx -s "......." your file. If you want to convert a file to xml, then you have to have a software.