MATCH FILE IBPRFNEW
DISPLAY_ID_PARTB AS 'DISPLAYIDPARTB'
BILLREPNM AS 'BILLREPNAME'
OPER_UNIT_NAME AS 'OPUNITNAME'
CUST_ACCT_NAME AS 'NAME'
BY PARTY_KEY AS 'PARTYKEY'
BY PROFILE_KEY AS 'PROFILEKEY'
WHERE BILL_UNIT_ORG_NULL NE '?'
AFTER MATCH HOLD AS HOLD2 OLD
FOC198) FATAL ERROR IN DATABASE I/O. FOCUS TERMINATING ERROR WRITING FOCSORT
PAGE 262144, CODE 0x0000cccc
Joined: 22 Aug 2005 Posts: 413 Location: Colarado, US
FOC198 error means that "A severe error was encountered in reading from or writing to a FOCUS database. FOCUS was unable to recover from this error, and will return to the host environment. "
In your code you have specified the match type as 'OLD'.
As far as my knowledge is concern the following are the match types available
List of MATCH TYPE
OLD-OR-NEW include all records from both files
OLD-AND-NEW include only records matched from both files
OLD-NOT-NEW include all records from the old file except those matched in the new file
NEW-NOT-OLD include all records from the new file except those matched in the old file
OLD-NOR-NEW include all records from the old and new files except those that matched
Try replacing with above one of the type and check the result. It should work well.
I have attached the list of FOCUS error messages document for your reference.
Hi Iknow....Thx for the response....I'll surely be checking this out.....The same code is working with a small I/P file and it has been running in production since long time....Pls inform me the changes after this new information ...