The application never knows what value is put into the primary key column after running the INSERT statement.
在运行insert语句之后,应用程序将永远都不知道放入了主键列中的是什么值。
DB2 will be responsible for generating a unique value for the column for each INSERT statement.
对于每条insert语句,DB 2将负责为其中的这一列生成一个惟一的值。
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.
在DB 2fori 6.1发布之前,SQLUpdate和insert语句能够使用一个值为- 1的指示符变量,将支持空值的列设置为空值。
A workaround to this is to supply a default value to the not NULL column whose value comes from a BEFORE INSERT TRIGGER, so that the constraint is not violated.
一种解决方法是给从BEFORE INSERT触发器取得值的NOT null列提供默认值,这样就不会违反约束。
In the solidDB example in the right column of Table 3, the status of the INSERT statement is checked using the SQLSUCCESS variable.
在表3右侧列的solidDB示例中,使用SQLSUCCESS变量检查INSERT语句的状态。
Click on the Insert button in the upper right-hand corner and fill in the first column name that you want for the table (COL1, for example), then click on ok.
在右上角单击Insert按钮,并填写表的第一列的列名(例如COL1),然后单击ok。
The INSERT statement does not need to specify the value for the SERIALNUMBER column.
insert语句不需要指定serialnumber列的值。
Since logically the XML column appears the same as a VARCHAR, CLOB, or BLOB column, the INSERT statements are also similar.
因为从逻辑上看XML列与 VARCHAR、CLOB或BLOB 列相似,所以INSERT语句也是相似的。
That is, it copies the character in the same column from the line immediately above the cursor. For example, a CTRL-Y in the following situation would insert an "m" at the cursor.
也就是说,它将从紧挨着游标的上一行中复制同一列中的字符。
Including steel truss, aluminum truss, truss, truss, open booth insert cue rack, tooth column truss.
主要包括钢质桁架、铝质桁架、敞开摊位桁架、插片桁架、球杆网架、齿柱桁架。
The information in the DAD file is used, when the XML column is enabled, to create the insert, update and delete triggers that help in keeping the side tables in sync with the XML document.
当启用xml列时,使用这个DAD文件中的信息创建insert、update和delete触发器,从而帮助副表与XML文档保持同步。
For example, the following INSERT statement stores the string that consists of alpha, beta, and gamma into the GRAPHIC column UCS2COL of the table uctable_1.
例如,以下insert语句将由alpha、beta和gamma组成的字符串存储在uctable_1表的graphic列ucs2col中。
For example, the following INSERT statement stores the string that consists of alpha, beta, and gamma into the GRAPHIC column UCS2COL of the table uctable_1.
例如,以下insert语句将由alpha、beta和gamma组成的字符串存储在uctable_1表的graphic列ucs2col中。
应用推荐