Gateway has some limits. It really depends on what kind of file you want. You should use the unload command, and use whatever options you need. Try this:
R>out mufile.txt R>unload data for mybigtable as ascii R>out screen This will give you a nice comma delimited ascii file with the columns in the same order that they are in the table. Troy ===== Original Message from [EMAIL PROTECTED] at 3/25/02 9:51 am >Hello everyone: > >I have a table that is about 307 columns. When I attempt to export all = >6,500 reocrds via the gateway or a command file using the gateway command, = >the entire file is blank. No records are exported. If I export A-G, Then = >H-S, etc it will work. This requires me to create 3 separate files to = >export all the records. It appears that arount 2,500 records the gateway = >bombs out. I would like to be able to do it in one file. Anyone else = >every run into this? Thanks. ================================================ 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/
