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/
