MATCH FILE IBPRFNEW
SUM
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
RUN
FOC198) FATAL ERROR IN DATABASE I/O. FOCUS TERMINATING ERROR WRITING FOCSORT
PAGE 262144, CODE 0x0000cccc
Joined: 22 Aug 2005 Posts: 582 Location: Colarado, US
Hi,
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.
NOTE
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 ...
Thanks,
Nikyojin
Hi Iknow
The same code was previously running and there are lots of OLD keywords mentioned...still its functioning fine...Pls suggest an alternative if possible......
