可通过用针对外键的默认值来填充fact表,来将外部连接转换为内部连接。
Outer joins can be converted to inner joins by augmenting fact tables with default values for foreign keys.
为了从表中检索结构化类型数据,必须有一些将类型转换成一个标量值,换句话说,这些值的类型必须基于某种内置的 DB2 数据类型。
To retrieve structured type data from a table, there must be some way to convert that type into a single scalar value whose type, in turn, must be based on one of the built-in DB2 data types.
在调用存储过程时,并没有将转换表中的实际值传递给存储过程,而是只传递了一个单值。
When a stored procedure is invoked, the actual values in the transition table are not passed to the stored procedure. A single value is passed instead.
应用推荐