At 03:55 PM 2/9/2011, Coxen, Dayle wrote:
Hello all -
I am having an issue LOADING a table in eXtreme 9.1.
I am unloading 21 tables in 6.5++ and LOADing them into a 9.1 database.
All of the 21 tables load OK. But one of the loads gives me an error.
During the load process for the workneed table I get the error message:
"Constraint Error" "Invalid Estimated Time"
I am unloading the table as follows:
OUTPUT c:\mms76dat\workneed.dat
UNLOAD DATA FROM workneed
OUTPUT SCREEN
A trace shows the error is thrown on the "LOAD filename" line.
The workneed.dat file that contains the commands to load the table is large.
In the R:Base editor, it contains 12,633 lines including the set commands
and the comma delimited data. There are 3673 rows in the loaded table.
My goal is to automate the unload and load functions so the user will not
see any error.
I tried:
SET ERROR MESSAGES OFF
RUN workneed.dat
RETURN
Same result.
Suggestions? Thanks in advance.
Dayle,
01.
Without knowing all details, it seems that you are UNLOADing the data in
a different folder. Make sure that the exact folder does exist in path.
02.
In your specific situation, when loading that file, you must specify the
exact path and folder, when RUNning the file, with default database folder
being a different one.
Hope that provides you with some blue's clues ...
Very Best R:egards,
Razzak.
