Phil Let me know how it works. I thought what you wanted was to specify column positions, which might not start at column 1. If you just want an output aligning a line of data into columns, then the SELECT (.var1)=10,(.var2)=20 method is the best.
David Blocker ----- Original Message ----- From: "Phil Nolette (NCS Group, Inc.)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 15, 2001 7:12 PM Subject: RE: Writing to a file > 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 > > > >
