Phil, Could you post a snip of what you're trying to do? At first glance it sounds like you could just:
set headings off output filename sel colname from tableName whe yada yada output screen set headings on Ben Petersen On 13 Nov 2001, at 23:53, Phil Nolette (NCS Group, Inc.) wrote: > 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 >
