The only problem is that a select is required. I think the good Dr's Sput suggestion is probably most direct in building the write string, using rjs() ljs() to allign "columns" within the string
i.e... Set var StringToWrite Text = 'Start here End Here' SET VAR StringToWrite = (SPUT(.StringToWrite,(rjs(.YourVar,37)),12)) Ben Petersen On 16 Nov 2001, at 11:06, david blocker wrote: > 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 > > > > > > > > >
