David, I know how to do the page techniques which I have done successfully. I need a contiguous file for processing on the mainframe without any page segmentation. I simply just wanted to make it classier. Ben provided the sel YY = 40 to make sure that I get the 40 even if it only has 16. I presume that when I pass it to a variable in Fetch command that it will retain all 40 and not 16. I will be trying that. Thanks for the reply. (Ben and David)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of david blocker Sent: Thursday, November 15, 2001 9:49 AM To: [EMAIL PROTECTED] Subject: Re: Writing to a file Phil Yes, if you create a PAGEMODE report with SET PAGEMODE ON. See the RSyntax page on this command. David Blocker ----- Original Message ----- From: "Phil Nolette (NCS Group, Inc.)" <[EMAIL PROTECTED]> To: "Rbase-L" <[EMAIL PROTECTED]> Sent: Tuesday, November 13, 2001 11:53 PM Subject: Writing to a file > 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 >
