Writing to a file

[Phil Nolette \(NCS Group, Inc.\)]

When I am writing to an output file and during a declared cursor, is there a
way to specify the column and not the row?
It would make the report (file) well laid out because of a couple of
variables not maintaining the full size of the declared text size.

Thanks,
Phil

I know about how to declare the the newpage and the line counts but I am
just outputting straight out to a file.
For instance:
================================
DECLARE c1 SCROLL CURSOR FOR +
SELECT resource_id,nm_comp_id+cost_ctr_cd, (last_nm+', '+first_nm), +
(voice_area_cd_nbr+voice_prefix_nbr+voice_suffix_nbr),emp_cd,(VOICE_INT_PREF
IX+voice_suffix_nbr)  FROM cd_pn +
WHERE nm_comp_id in (select nm_comp_id from nm_conv where READY = 'Y') +
AND (voice_area_cd_nbr+voice_prefix_nbr+voice_suffix_nbr) IS NOT NULL AND
NCA_USER_ID = 0+
order by nm_comp_id

OPEN c1

-- Scroll through Corporate Data

FETCH NEXT FROM c1 INTO vp1, vp2,vp3,vp4,vp5,vint
WHILE SQLCODE <> 100 THEN


  WRITE ' '
  WRITE 'Corporate Detail Record being Analyzed for Matching NCA - Direct
Dial Number'
  WRITE 'CD => ','ID: ','   ',.vp1, 'COMP/CC=> ',.vp2,'DIR-DIAL
=>',.vp4,'NAME = > ',.vp3,'FLAG = >',.vp5, 'Internal = > ',.vint

winmail.dat
Description: application/ms-tnef