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.