Ben, You're doing it again! What a great idea. Now I have the ability to get pass the 64,000 limit per file and also the ability to print a record layout. Thanks - I will use them both and put them in my tool bag. Phil
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Petersen Sent: Thursday, January 31, 2002 11:32 AM To: [EMAIL PROTECTED] Subject: RE: Export Algorithm Phil, I _think_ Ian trying to skip Gateway. To build on his idea, another approach _might_ be: Set v zDelim = (char(9)) Set delimit = .zDelim output FileName unload data from BigOlTable as ascii output screen Set delimit = ',' Ben Petersen On 31 Jan 2002, at 18:07, 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/ ================================================ 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/
