如果列被定义为支持空值,那么您必须相应更新空指示符映射。
If the column is defined as null capable, then you must update the null indicator map accordingly.
SIF记录格式还包含特定于delta的列,以协助将现有数据库记录的指示符值设置为NULL。
The SIF record format also contains delta specific columns to assist in setting the indicator values of existing database records to NULL.
对于每个不同的值,该列的指示符变量被设置为0。
The indicator variable for the column is set to zero for each value that is different.
Ind_Ary列包含SQL扩展指示符设置。
The Ind_Ary column contains the SQL extended indicator settings.
RPG使用一个1字符字段(比如一个指示符)来确定列是否包含空值。
RPG uses a 1 character field (like an indicator) to determine if a column contains nulls.
如果新旧值相同,那么指示符变量仍然是- 7,该列被忽略。
If the old and new values are the same, then the indicator variable remains as -7 and the column is ignored.
如果是后一种情况,那么该列的指示符变量被设置为- 5,这将把该列的值设置为默认值。
If the latter is true, then the indicator variable for that column is set to -5 which will set the column to the default value for that column.
如果是前一种情况,那么该列的指示符变量被设置为- 1,这导致该列被更新为空值。
If the former is true, then the indicator variable for that column is set to -1 which results in the column being updated with the null value.
在DB 2fori 6.1发布之前,SQLUpdate和insert语句能够使用一个值为- 1的指示符变量,将支持空值的列设置为空值。
Prior to the DB2 for I 6.1 release, SQL Update and Insert statements could use an indicator variable with a value of -1 to set a null capable column to the null value.
在嵌入式SQL中,对于导致错误的列,指示符变量设置为- 2。
In embedded SQL, an indicator variable is set to -2 for the column or columns that cause the error.
在嵌入式SQL中,对于导致错误的列,指示符变量设置为- 2。
In embedded SQL, an indicator variable is set to -2 for the column or columns that cause the error.
应用推荐