Thanks you for the helpful information. You may be correct with the WinSQL providing the formatting. I couldn't find an option to suppress it but ended up inserting a powershell script immediately following to trim the header and footer from the raw data as a workaround.
The version of OpenEdge is 11.7. I'm using WinSQL within an automated script which calls this simple SQL query:
SELECT pub.ser_mstr.ser_serial_id + ',' + pub.ser_mstr.ser_part + ',' + ltrim(rtrim(pub.ser_mstr.ser_lotser))
FROM pub.ser_mstr
JOIN pub.pt_mstr ON pub.pt_mstr.pt_part =...
I'm trying to write a SQL-92 query from a script that writes to a text file but it's writing a header line and record count. In Transact-SQL you use the line "SET NOCOUNT ON" but this doesn't seem to work in SQL-92. Is there an equivalent statement to prevent the header from being written?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.