developers who have written c-udf or c stored procedures in db2 have learned to check the sqlca after each exec sql statement in their code 在db2中编写c-udf或c存储过程的开发人员已经学会在其代码的每条execsql语句之后检查sqlca。
at precompile and bind time, the code page derived at the database connection is used for precompiled statements, and any character data returned in the sqlca 在预编译和绑定时,代码页派生于用于预编译语句和sqlca中返回的所有字符数据的数据库连接。
all data, including dynamic sql statements, user input data, user output data, and character fields in the sqlca, is interpreted based on this code page 所有数据,包括动态sql语句、用户输入数据、用户输出数据以及sqlca中的字符字段,都是基于该代码页进行解释的。
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 当您使用clp的“-a”选项来显示sqlca信息时,将展示源应用程序(本例中,clp)和目标数据库的代码页。