Recent content by jeremy.hogan

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?