how to change the text format from sql query output.

[aSDDSasdas]

Hello everyone ,

The following file is been created when i execute a sql query.. Here the third column (RELEASE_VON)is always given out in the next line ...where i would like it to put all of the values (ST ,SAG_SNR,RELEASE_VON) in the same line.. is it possible?

thank u in advance

ST SAG_SNR
---------- --------------------------------------------------
RELEASE_VON
--------------------------------------------------
75000169 P30862-A1-N836
OTS7.0

840001749 P30862-A1-N831
RC6.0
75000168 P30862-A1-N830
OTS6.0
840001750 SUYSIE-4900-8-16R-A
840001751 P30862-A1-N837
RC7.0
840001752 P30862-A1-N839
840001753 S32010-A1-X
ALL
840001754 SUYSIE-HSI-A
OBR4.5

 

[travs69]

How are you doing the query?

If you aren't use DBI you should look into it. You can then control your output very easily.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those Who Say It Cannot Be Done Are Usually Interrupted by Someone Else Doing It; Give the wrong symptoms, get the wrong solutions;

 

[1DMF]

or Win32::ODBC is my choice , comes as standard with perl so no need to install any modules if not already installed.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!