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
James
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.
