11.2.2 Operands related to foreign server error information
- 3) pd_hb_e_mode = ALL | NONE
- Specifies whether to output foreign server error information. For details on foreign server error information, see the HiRDB External Data Access Version 7 Description and User's Guide.
- ALL: Outputs foreign server error information.
- NONE: Does not output foreign server error information.
- 4) pd_hb_e_code = SQLCODE[,SQLCODE]...
<signed integer>((-214748364 to -1))- For this operand, specify the foreign server's SQLCODE (value returned to SQLCODE of the SQL Communications Area SQLCA). The error message corresponding to the SQLCODE specified here is not output to the foreign server error information.
- If this operand is omitted, all error messages corresponding to all SQLCODEs are output to the foreign server error information file. For details on SQLCODEs, see the documentation for each DBMS.
- Operand rules
- When specifying multiple SQLCODEs, delimit them using commas.
- The maximum number of SQLCODEs that can be specified is 10.
- 5) pd_hb_e_size = foreign-server-error-information-file-size
<unsigned integer>((0, 4-4096))<<32>> (KB)- Specifies the size of the foreign server error information file (units: KB). To not limit the size, specify 0.