[focus-l] Re: Any one here
- From: "Baskararaman, Karthik" <karthik.baskararaman@xxxxxxx>
- To: <focus-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Jun 2005 23:29:10 -0500
Hi Bob,
When working with a FOCUS database or when querying a VSAM file I
used to encounter FOC198 error. FOC198 error comes with a wide range of
flavors. Best way is to identify with return code. Return code of 0000
CCCC means that focus database is spanning across DASD volumes and needs
to be converted into uni volume.
I am sending u a list different flavors of FOC198 errors. May be u can
try it out.
A request to the moderator : Can you please add the IDs of my 2
colleagues Prathap and Savitha to this forum too. Their email ids are in
CC.
>*
>Warm Regards & Have a Great Day...
>B.Karthik
>CBA-HLS,
EDS-IndiaSc
Tidel Park,Chennai
>Ph 2254 9650 Ext.2302(Work)
>
-----Original Message-----
From: focus-l-bounce@xxxxxxxxxxxxx [mailto:focus-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hamilton, Robert L
Sent: Friday, 3 June 2005 3:22 AM
To: focus-l@xxxxxxxxxxxxx
Subject: [focus-l] Re: Any one here
Twas working earlier in the afternoon. . .
bobh=20
-----Original Message-----
From: focus-l-bounce@xxxxxxxxxxxxx [mailto:focus-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sandy Kadish
Sent: Thursday, June 02, 2005 4:49 PM
To: focus-l@xxxxxxxxxxxxx
Subject: [focus-l] Re: Any one here
check with the DBA to confirm that the table is in fact out there and
populated.
"Hamilton, Robert L" <roberth@xxxxxxxxxxxx> wrote:Ok;
GOT THIS
? 198
(FOC198) FATAL ERROR IN DATABASE I/O. FOCUS TERMINATING %1 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.
When FOCUS was doing this:
SQL DB2
SELECT STU_ID AS STU_ID ,
STU_NAME AS STU_NAME
FROM IAPROD.SIS_STU_ATTR_TB
;
TABLE FILE SQLOUT
SUM STU_NAME
BY STU_ID
ON TABLE HOLD AS NAMES FORMAT FOCUS INDEX STU_ID END
---------------------------------------------------------------
FOCUS 7.2.0S1 16.23.32 06/02/2005 RECON LINE 24 18.02
EX SQLOUT
---------------------------------------------------------------
FOCUS 7.2.0S1 16.23.32 06/02/2005 SQLOUT LINE 1 18.02
TABLE FILE SQLOUT
SUM STU_NAME
BY STU_ID
ON TABLE HOLD AS NAMES FORMAT FOCUS INDEX STU_ID END HOLDING FOCUS
FILE...
NUMBER OF RECORDS IN TABLE=3D3D 944290 LINES=3D3D 944290
Maybe,
This had run ok once before. . .
bobh=3D20
Sanford Jay Kadish
9897 Merlin Drive East
Jacksonville, FL 32257=20
Home (904) 730-2271 =20
Cell (601) 918-2320
-- Binary/unsupported file stripped by Ecartis --
-- Type: application/msword
-- File: FOC198_details1.doc
-- Desc: FOC198_details1.doc
Other related posts:
