Specifying error handling

The four SPAREA fields used to communicate status and messages between the CSA and Open ClientConnect are described in the following table and in the sections following the table.

NoteFor the size of the datatype fields, see the “SPAREAC COBOL II definition”.

Table 2-2: SPAREA error handling fields

SPAREA field

Use

SPRC

Stored Procedure (SP) return code. Open ClientConnect indicates the success or failure of a CSA command in this field. Possible values are:

  • '000' indicates successful completion

  • 'xxx' indicates an Open ClientConnect error message

  • 'EOF' indicates End of File on input data

  • 'ACE' indicates APPC Communication Error (when the Open ClientConnect configuration property, Temporary Storage Type, is set to None)

SPSTATUS

SP status. Open ClientConnect indicates the success or failure of processing in the remote database in this field. Possible values are:

  • 'OK' indicates success

  • 'E' indicates error

  • 'W' indicates warning

  • 'R' results are available

  • Blank indicates no results available

SPIND

SP indicator. Open ClientConnect indicates the availability of an additional message. Possible values are:

  • 'M' indicates messages are available

  • [Blank] indicates messages are not available

SPMSG

SP message. Open ClientConnect communicates message text to the CSA using this field.

SPCODE

SP code. No longer used.

Open ClientConnect error messages related to CSAs are listed in Mainframe Connect Client Option and Server Option Messages and Codes.