For a list of newly supported and discontinued platforms, see the Recommended Software Environments and Minimum System Requirements guide.
1 System and SQL Performance for DB2 Administrator Guide This section explains how to use the administration functions to customize the BMC System Performance for DB2 and SQL Performance for DB2 suites for your DB2 system. The intent of this paper is not to replicate the Db2 Utilities Reference Guide or the Db2 Installation Guide. 00 AFDPLEX AFD DOMPLEX 6 16:17:02 JKS AFDQANGL AFDQA 10.
Advanced Command Center supports operations of the following system release: CICS/TS/V5. A more detailed description of DB2 12 is available in IBM DB2 12 for z/OS Technical Overview, SG24-8383.
The actual number of code points in a SBCS might be less. Within the TRY block we are finding the result of 252/0 SET = / 10 Īs we all know that the above statement will throw an error so, statement inside the CATCH block will be executed.Db2 v12 administration guide Notes Before using this information and the product it supports, be sure to read the general information under Table 1. In this SQL error line example, we are going to find the result of integer /0. PRINT N'Error Message = ' + CAST(ERROR_MESSAGE() AS nvarchar(100)) ERROR LINE example 2 We used the ERROR_MESSAGE function to display the error description PRINT N'Error Line = ' + CAST(ERROR_LINE() AS nvarchar(100)) So, it will exit from the TRY block, and execute the statements inside our CATCH block. SET = 252 = + 10 Īs we all know, that tinyint holds numbers from 0 to 255 means Overflow. Next we assigned 252 to variable, and then we added 10 to that variable which will become 262 (Result). PRINT N'Error Message = ' + CAST(ERROR_MESSAGE() AS nvarchar(100)) įirst, we declared two SQL Server tinyint variables DECLARE tinyint PRINT N'Error Line = ' + CAST(ERROR_LINE() AS nvarchar(100)) In this example, we are going to show you how to use the Error_Line function to return the line number at which the error has occurred. The basic syntax of the Error_Line in SQL Server is ERROR_LINE() SQL ERROR LINE example If the server finds an error, then SQL ERROR_LINE() inside the CATCH block will execute and returns the corresponding line number at which error occurred. This ERROR LINE function works within the scope of a TRY CATCH block.įor example, we write a series of statements inside the TRY block. SQL ERROR LINE is one of the SQL System Function which will return the line number at which the error has occurred.