1、Using the CLP with the "-a" option to display the SQLCA information.
2、The SQLCA can be used to format and build localized messages.
3、GET DIAGNOSTICS statement supports retrieval of almost any fields of SQLCA area, populated by the database for each SQL statement.
4、This allows for SQLCA information to be returned from the administration API to the SQL interface that is calling the administration command.
5、这就允许将SQLCA信息从管理API返回给调用该管理命令的SQL接口。
6、Error handling: the new stored procedure now returns SQLCA with proper SQLCODE and SQLSTATE that is more inline with the error handling framework when using SQL.
7、When you use the "-a" option of the CLP to display the SQLCA information, the code pages of the source application (in this case the CLP), and the target database are shown.
8、In the DB2 procedure example in Table 6, the SIGNAL statement is used to generate a user-defined SQLSTATE and a message that is returned to the caller through the SQLCA.
9、每个查询的信息包括输入和输出SQLDA、语句文本、SQLCA、包名、创建者、区号和一致*符号。
10、The information for each query consists of the input and output SQLDA, the statement text, the SQLCA, the package name, the creator, the section number, and the consistency token.
11、在表6的DB 2过程示例中，signal语句用于生成用户定义的SQLSTATE和一条消息，该消息通过SQLCA返回给调用方。
