在错误中使用短列名称的IBM DB2 for i错误消息 [英] IBM DB2 for i error messages using short column names in errors

问题描述

请注意，此问题特定于"IBM DB2 for i"，这是IBM i操作系统的

Note this question is specific to "IBM DB2 for i", the IBM i operating system's version of DB2.

下面的屏幕快照显示了故意错误的INSERT语句，该语句产生SQL0407的SQL错误.

The below screenshot shows a purposely erroneous INSERT statement that produces an SQL error of SQL0407.

我的问题... 是否有我可以更改的DB2，JDBC或其他设置，以便将长列名与错误的短列名一起使用?注意，我在INSERT语句中使用了长列名称.

My question... Is there a DB2, JDBC, or other setting I can alter so the long column names are used in the error vs. the cryptic short ones? Note I used the long column names in the INSERT statement.

推荐答案

IBM i高级软件工程师 DB2 的Carol Ramler对此回应:

Carol Ramler, DB2 for i Senior Software Engineer at IBM, responded with this:

在这种情况下，低级数据库管理器代码 生成错误，并且未填写到期的长列名称 出于历史和性能原因.

In this situation it is the low level database manager code that is generating the error and it does not fill in the long column name due to historical and performance reasons.

鉴于她的头衔，我相信她是对的:-)

Given her title I trust she is right :-)

这篇关于在错误中使用短列名称的IBM DB2 for i错误消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！