Email from Bteq

Database
Enthusiast

Email from Bteq

Hi,

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.

1 REPLY
Enthusiast

Re: Email from Bteq

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.