Is there a way to remove the column headings from the result when running a SQL query in Informix? I have an output file that shows the headers in an Excel file and I need to remove the first row from the output which is generated by a 3rd party app. I was told that there was a way to query the database to generate an XML output but I am not sure how to do that.
Thank you,