Help Needed in formatting output data !!

[fibreclaw]

Can anyone of you let me knw how to obtain the output flat file in the below format ?

"ID"|"NAME"|"PARENT_ID"
"NQ TEL"|"14"|"Macetown"

But I am gettin the output.. as below.

VENDOR_NAME||'|'||VENDOR_ID||'|'||CITY
----------------------------------------------------------------------------------------------------
NQ TEL|14|Macetown
NA TEL|14|Molokai


I am using the followin script :
set heading on
set echo off
set feedback off
spool Y:\Spool\output1.txt

select Vendor_Name || '|' || Vendor_ID || '|' || City from vendor where city like 'Mo%';

spool off;
set feedback on
set echo on
set heading on



Can anyone help me on this.? In Addition to this, I also need to remove the line separating Header and the Data .
Thanks a ton. :)

[amitpatel66]

Can anyone of you let me knw how to obtain the output flat file in the below format ?

"ID"|"NAME"|"PARENT_ID"
"NQ TEL"|"14"|"Macetown"

But I am gettin the output.. as below.

VENDOR_NAME||'|'||VENDOR_ID||'|'||CITY
----------------------------------------------------------------------------------------------------
NQ TEL|14|Macetown
NA TEL|14|Molokai


I am using the followin script :
set heading on
set echo off
set feedback off
spool Y:\Spool\output1.txt

select Vendor_Name || '|' || Vendor_ID || '|' || City from vendor where city like 'Mo%';

spool off;
set feedback on
set echo on
set heading on



Can anyone help me on this.? In Addition to this, I also need to remove the line separating Header and the Data .
Thanks a ton. :)

Place the below code in a sql file and execute:

 
SET ECHO OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET VERIFY OFF
SET HEADING OFF
 
SPOOL c:\a.txt
 
ttitle '"ID"|"NAME"|"PARENT_ID"' LEFT
select  CHR(34)||Vendor_Name||CHR(34)|| '|' ||CHR(34)||Vendor_ID||CHR(34)|| '|' ||CHR(34)||City||CHR(34) from  vendor where city like 'Mo%';
 
SPOOL OFF