Phil, Until David Blocker's reply I hadn't realized you posted your code [didn't look past your "signature" in my eMail window :( ]
In addition to David's comments, you might consider using the ljs() and rjs() functions to left or right justify your variable values within the defined text length. 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 >
