James,
SET EOFCHAR OFF should only be used when you are UNLOADing
the data from your DOS 3.1 database.
SET EOFCHAR should be set to ON (default) when loading that
data in 7.1
Hope that helps!
Very Best R:egards,
Razzak.
At 09:46 AM 8/18/2005, James Hageman wrote:
What should EOFCHAR be when loading?
I tried loading the files after unloading with your
scrip and it loaded about 2 million NULL rows to the
database before I forced-quit it.
Something like this?
CONNECT 7.1dbaname
SET NULL -0-
SET EOFCHAR OFF
DELETE ROWS FROM audit
LOAD audit FROM 'import\audit.asc' AS ASCII
SET EOFCHAR ON
A. Razzak Memon wrote:
At 04:13 PM 8/17/2005, James Hageman wrote:
Is there a way to get rid of the char during the unload and
avoid this extra step.
James,
That is the result of EOFCHAR settings (default is ON). It
adds the end of file character to the end of output files
Here's how to handle the situation in your case:
CONNECT dbaname
SET NULL -0-
SET EOFCHAR OFF
OUTPUT filename.ext
UNLOAD ....
OUTPUT SCREEN
SET EOFCHAR ON
That's all there is to it!
Very Best R:egards,
Razzak.
