Force BTEQ WIN to truncate SQL

Tools & Utilities
Not applicable

Force BTEQ WIN to truncate SQL


I am using BTEQ for WIN32. My primary use of this is to test scripts prior to promotion to a mainframe system which has a chracter line limit of 80.

I have used .SET WIDTH 80 to force the character limit, but if I submit SQL and a line goes over the 80 chars rather than truncating the line it puts a line return in at the 80th character which is great to stop any errors occuring but... if I want the errors to happen is there anyway to force BTEQWIN to truncate?



Tags (1)