Hi Phil, Have you tried a report.
I have dumped large data in fixed positions before using an expression in a report. expressions -------- vt = char(9) vrecord = (field1 + .vt + field2 + .vt + field3) place just the "vrecord" variable in the top left corner of the report save report then... out filename.txt print filedump out scr Reports then to have less problems working with larger data sets. Ben Johansen ----- Original Message ----- From: "Phil Nolette (NCS Group, Inc.)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 3:07 PM Subject: RE: Export Algorithm > Ian, > Thanks for the reply. I have no problem with exporting the data 1 row = > (390 characters/text). I am using Gateway Export ASCII TAB. The problem I > am having is that I have 150,000 rows of data in that table and have to > break down the export into 5,000 rows of export data for it to finish > writing the file. > > Since I posted this message, I have gone into Control Panel - Performance - > Advanced and changed the Virtual Memory to the max which is in the Gig > territory. I will see if this influences the need to break the export into > 5,000 rows. > > Phil > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Ian Stone > Sent: Thursday, January 31, 2002 3:49 PM > To: [EMAIL PROTECTED] > Subject: Re: Export Algorithm > > > Phil > > Now you can set width to more than 256 it is possible to use select to > export data: > > SET VAR vht TEXT = (CHAR(9)) > SET EOFCHAR OFF > SET HEADINGS OFF > SET LINES 0 > SET WIDTH 1000 > SET SELMARGIN 1 > OUTPUT filename > SELECT (t1.Account_number+','+(CTXT(t2.Company_Cont_key))+.vht+ (CTXT + > (t3.catalognr))+.vht+'1')=1000 + > FROM .................... > OUTPUT SCREEN > > > At 21:36 30/01/2002 -0500, you wrote: > >Does anyone know what the algorithm is for Gateway Export ASCII Tab > >delimeted files? > > > >The reason: > >I have 150,000 rows of data (length) which consists of 390 character/txt. > >The primary key (ID) starts with 1 and is incremented by 1 for every > insert. > >So, 150,000*390 = 58.5Mb. This is what I wanted to export. > > > >When I wrote an export.rmd, I had to break the files into 5,000 > records/file > >to be able to have data in the file. > > > >What is the standard number of bytes that file will hold? Is there a > >standard? > > > >Phil > > > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
