However, most normal error conditions that are common to both Oracle and DRDA (and DB2) may be mapped.
Thus, Oracle Database Provider for DRDA cannot emulate DB2 behavior precisely. For example, Oracle treats an overflow situation as an error, and does not continue. In Oracle, call execution is either successful or generates an error. Oracle, unlike DRDA (and DB2), has no notion of a warning condition. In DB2 and DRDA, negative SQLCODEs are errors, and positive SQLCODEs are warnings. (EXCEPTION ERROR exceptioncode HAS OCCURRED DURING It will also issue the warning code +802: For example, when an operation generates an integer overflow situation, DB2 continues and returns the rest of the row data with an indicator set for the column value that contains the error. “Error Code Mappings, from Oracle to DRDA” lists some common Oracle error codes and their equivalent SQL codes and SQL states.In DRDA and DB2, certain types of operations may be successful but generate a warning.
In DRDA and DB2, certain types of operations may be successful but generate a warning.
0 kommentar(er)
