Guys,
Don’t do any of the hokey trying to capture output. Just use JQLCOMPILE and JQLEXECUTE. They are in the manual and specifically designed to do this sort of thing. Jim > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of El Yorch > Sent: Thursday, December 30, 2010 9:04 AM > To: jBASE > Subject: Re: SSELECT INTO A FILE > > you can try this: > > on jbase prompt > 1) first prepare the screen > ~--> TERM Y,X (Y are the columns, X are the rows) > > 2) next put the name of the file > ~--> COMO ON filename > > 3) put your LIST command > ~--> LIST FBNK.ACCOUNT CATEGORY (if you want only CATEGORY field) > > 4) the list scroll down in the screen (here is important the size of > TERM, because if the rows are not enough, then you have to press some > key of keyboard) > > 5) finally, lookup your file in the &COMO& directory > > ~/&COMO& --> > > 6) now you can edit the file to eliminate some wrogn characters and > open in excel of something like that to exploit > > > Regards > > > On 28 dic, 14:18, Rick Weiser <[email protected]> wrote: > > You want to use jBasic for this. > > > > OPEN 'FILE1' TO F.FILE1 ELSE STOP 201,'FILE1' > > OPEN 'FILE2' TO F.FILE2 ELSE STOP 201,'FILE2' > > > > SELECT F.FILE1 > > > > DONE = 0 > > LOOP > > READNEXT ID ELSE DONE = 1 > > UNTIL DONE DO > > READ REC FROM F.FILE1,ID THEN > > CUSTID = whatever > > REC1 = '' > > REC1<xx> = REC<accountbalance> > > WRITE REC1 ON F.FILE2,CUSTID > > END > > REPEAT > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] To unsubscribe, send > email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
