var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Formatting the output to single line
Today I searched all over internet and also several forums including this, but couldn't find my answer! Can you please help me out?
How can I modify the output of my query in informix into one row only.
Here's the example:
select NAME from EMPLOYEE
I want to make the output to:
James Peter John Stephen Gary
Is it at all possible in informix? If yes - how? If not I will go for unload and manipulation with script.
Your help would be greatly appreciated.
If you are using Linux and the distribution has de paste command do:
unload to "name_file.out" select NAME from EMPLOYEE;
paste -s -d ' ' name_file.out > new_paste_file.out