Phil As far as I know the only practical limit on how much data you can send to a file using SELECT is down to the operating system.
I regularly send in excess of 300,000 rows to a Sybase database using SELECT with no problem. Maybe Gateway is your problem which I can't comment on as I do not use it. Ian At 18:07 31/01/2002 -0500, Phil Nolette \(NCS Group, Inc.\) wrote: >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/
