Using FOCUS we are generating a report. Here, we are first creating a Flat File using COBOL program and then using this flat file generating the report.
In Focus, we are creating a HOLD File in DB2 Format. Next we using this file we create another HOLD file when we get the following error
(FOC1400) SQLCODE IS -204 (HEX: FFFFFF34) XOPEN: 42S02
(FOC1409) SQL TABLE NOT FOUND. (FOR TABLE: CHECK SEGNAME AND TABLE)
(FOC1414) EXECUTE IMMEDIATE ERROR.
We have faced similar kind of problem last year; wherein we had reloaded the tables and recreated the indexes. This time even after doing this we are getting the same error.
Kindly let me know if anyone has ever faced this error and what more can be done to solve the same.