The previous installment in this column identified some common input data types and how to check them.
本专栏的前一期文章指出了一些常见的输入数据类型以及检查它们的方法。
A user can enforce validation on an XML column using check constraints.
用户可以使用检查约束来加强对xml列的验证。
The above example creates a check constraint on the column INFO which is of type XML.
以上例子在类型为XML的info列上创建了一个检查限制。
If an XML validation check constraint exists on the XML column of the table, the user may need to validate the new XML value before the update either manually or by creating a trigger.
如果在表的xml列上存在XML验证检查约束,在手动更新或者通过触发器更新之前,用户可能需要验证新的xml值。
Additional code could be added to perform a check to see if the new value is a user-defined value indicating that the database value should be set to NULL or the default value defined for the column.
可以添加额外的代码来执行一个检查,检查新值是不是一个用户定义值,用以表明数据库值应该被设置为NULL或针对该列定义的默认值。
Check the column keys in the tag to make sure that the column keys are realigned to match the data fields returned by the SQL query.
检查标签中的列关键字,来确认列关键字已经被重新排序,并且与SQL查询返回的数据字段相符。
On the Object Explorer Details page, right-click the column headings, and then click to clear the Collation check box.
对象资源管理器详细信息本页右键单击该列标题,然后单击以清除排序规则复选框。
You should still keep in mind that on the logical level the KTOKD column in the KNA1 table is connected to the check table T077D, not its text table T077X.
您应该始终在逻辑层面上记住KNA1表上的ktokd列,它连接检查表t 077d,而不是其文本表t 077x。
In addition to the check mark symbols in the far left margin, there are small triangles in a column to the right of these.
除了最左侧的复选符号之外,在右边的某一列中还有一些小三角。
Figure 24 defines the column to be used as the key to check the duplicate records.
图24定义了列,用作检查重复记录的键。
Check back with this column periodically as we continue to provide new and practical information on IBM Support-related tools and resources.
欢迎您定期访问本专栏,以了解我们提供的关于IBMSupport相关的工具和资源的最新实用信息。
Check the "names" column displayed in the center pane.
检查显示在中央窗格的“names ”列。
Check out the Alertbox section, a bi-weekly column about current issues on usability.
网站的Alertbox部分是一个讨论当前可用性问题的双周专栏。
The fourth column of the table does not have an icon, but the Check Box template does.
表格的第四列并没有一个图标,但是CheckBox模板没有。
Check out Lester's Informix DBA column in this issue for more tidbits, and let us know what you think of the new version, and what you're most excited about.
查阅这一期Lester的Informixdba专栏,了解更多趣闻,让我们知道您对新版本的想法以及您最喜爱的特性。
Creating a table with check constraint on an XML column.
创建一个xml列包含检查限制的表。
If informational check constraints exist on the primary key column, you should explicitly specify informational check constraints on their corresponding foreign key columns. For example.
如果在主键列上存在信息检查约束,那么应该在它们相应的外键列上指定信息检查约束。
In this case, the DBA can put a check constraint on the XML column and ensure that the application USES one of the pre-registered schemas for validation.
对于这种情况,DBA可以在xml列上放置检查(check)限制,并确保应用程序使用预注册的模式之一执行验证。
Listing 5. Create check constraint on an XML column.
清单5.在xml列上创建检查限制。
Now, follow these steps to add a new constraint to check for the existence of a masking method if a column is set as privacy data
现在,添加一个新约束,以便在将一个列设为privacydata时检查是否存在一个masking方法。
SYSCAT.COLCHECKS Contains a row for each column that is referenced by a table check constraint db2 select constname, tabname, colname, usage from syscat.colchecks
COLCHECKS为表检查约束所引用的每个列保持一个行db2select constname,tabname,colname,usage from syscat.colchecks
When you want to determine whether a given row includes a comment, you no longer need to check for a null value in the COMMENT column.
确定某一个行是否包含注释时,不再需要检查COMMENT列的null值。
Selecting the Title check box, and typing in a value (such as TO) changes the column heading for this column.
选中Title复选框,在后面输入一个值(例如TO)将改变这个列的标题。
A check constraint is a type of constraint which can be put on a table column at the time of the creation of the table.
检查约束(checkconstraint)是一类可以在创建表时作用到表列的约束。
To publish, select the check box in the publish column next to the name of the profile (see Figure 19).
发布前,在与这个概要文件名称相邻的Publish栏目中选择这个复选框(请看图19)。
I told myself not to check my email until the column was done, but I did peak at my Facebook because I was awaiting a response.
我告诉自己专栏文章写完之前不看电子邮件,但我还是登陆了我的Facebook(“脸谱”社交网站),因为我在等一个回复。
Figure 7: Use-case description (to-be scenario) : "Check in Guest" using a two-column style.
图七:用例描述(未来情景):“顾客登记”使用两栏格式。
Select the check box in the Select column for the CallForwardingSample.sar file, and click Start to start the application.
为CallForwardingSample.sar文件选中Select列的复选框,并点击Start以启动应用程序。
Select the check box next to the name of your portlet in the portlet title column, and then click OK (Figure 27).
在portlettitle列中选择您的portlet名称旁边的复选框,然后单击OK(图27)。
Check Export overall results and Split output if columns exceed 250 (250 is the maximum column limit for a Microsoft Excel file).
选择Exportoverallresults及Splitout putifcolumnsexceed 250(对于一个MicrosoftExcel文件来说,250是最大值)。
应用推荐