It sounds as if you have to go beyond reload to unload/input. Somewhere
in your database, you have an error that is not removed during the reload.
Note: A reload is better than pack, and also safer because it only reads
the source data, it never modifies it.
What you need to do is this series of commands:
CONNECT dbname -- use the correct db name here
SET NULL -0-
OUTPUT dbname.all -- again use a name that means something to you
UNLOAD ALL
OUTPUT SCREEN
DISCONNECT
RENAME dbname.rb? dbnamebackupname.rb? -- substituting names, of course
RUN dbname.all
Once you have done this, compare the row counts for all the tables to
see if any of your data has been lost.
You might have a table that is truncated during the process. In your
case, the customers might be truncated because of an oddball character
in one of the fields in the customer table.
You should be a able to determine fairly easily where the table was
truncated, and unload the data after that point from the original database.
Good luck!
Steve Breen wrote:
I am having a little bit of a database problem her that has never
occurred before a few months ago.
Since then it has happened 4 times.
Just happens in the customer file.
The only way to fix the problem is to delete the customer from the
data base - run reload - then reenter the customer.
Problem is them gone and has never repeated it self on the same
customer number.
No here is my question what is better a reload or pack?
Right now this is more an irritant but are there are other lying problems?
Any recommendations?
File Example below. As you can see most of the data is not showing.
Edit Go to Exit
????????????????????????????????????????????????????????????????????????????
?>>>>>>>>>>>>>>>>>>>>>>>>>>>> MASTER CUSTOMER FORM <<<<<<<<<<<<<<<<
SCREEN #
? BILLING LOCATION NAME
? BILLING ADDRESS #1
? BILLING ADDRESS #2
? BILLING CITY
? BILLING STATE BILLING ZIP
? BILLING ATTENTION TO TITLE
? SPECIAL INSTRUCTIONS LIST BELOW
??????????????????????????????????????????
?
?
?
?
?
? t ? ? ? ? ? <t???
? ? ??? ?ΒΆ ? ? ? ?
? ADVISEMENT NEEDS
?
?
? ADVISE DAYS EVERY 0 HOURS - ADVISE NIGHTS EVERY 0 HOURS
? ADVISE WEEKENDS EVERY 0 HOURS
????????????????????????????????????????????????????????????????????????????
Form: CUSTOMER Table: CUSTOMER Field: BILLNAME Page:
Stephen Breen
CDI Services, Inc.
Road Support Division
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
