var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Extra Newlines In Piped Output
I have a simple command line statement
db2 -x SELECT item FROM table a > file.out
item in this case is a varchar of length exactly 698. For some reason in my output im geting additional newline characters. IE, each row is seperated by a blank line.
I have tried the -n flag which supposedly suppresses newline characters (but i think this means ones that are actually located in the data)
Please help. Im really stuck here and I need this data without the spaces
db2 -x select left(item,20) from table a
If this does not produce blank llines, then the blank lines could be because of the length of data ..
thanks for the quick reply
although, no luck this does not help the situation. I just dont see why the length of teh output would produce an additional newline character.
what editor are you using to look at the file ... Probably the editor is wrapping the lines and your actual content of the column contents is less than 628 ... So, it appears you have multiple lines ...
Visit the new-look
, register to gain access to the excellent content.