Truncate - to delete the records in the existing table.
截去—删除已有表中的记录。
A Sybase existing table is a type of proxy table in Sybase ase.
Sybase现有表(existing table)是Sybasease中的一种代理表。
Columns can be edited directly or loaded from an existing table definition.
可以直接对列进行编辑，或者从已有的表定义中导入列。
The manufacturer had an existing table with the depot polygons already defined.
制造商有一个已经定义了维修站多边形的现成的表。
Publishing XML documents based on the existing table data is a common scenario.
根据已有的表数据发布XML文档是一个常见的场景。
Here is the command to create the nickname for the existing table if the Control Center is not used.
下面是在不使用ControlCenter的情况下为现有表创建昵称的命令。
Note that "create existing table" requires the Sybase ase be at Version 11.9.2 or Version 12 or 12.5.
注意，“createexisting table ”命令要求Sybasease的版本为Version11.9.2、Version12或Version 12.5。
This is a powerful technique that lets you easily copy all or part of an existing table into a second table.
这是一种功能强大的技术，允许您很容易地将现有表的全部或部分复制到第二个表中。
Moreover, if an ALLOW read ACCESS load operation fails or is aborted, pre-existing table data can still be read.
此外，如果ALLOWREADACCESS加载操作失败或者被中断，预先存在的表数据仍然可以被读取。
WASPostUpgrade calls EJBDeploy using the arguments -35 -dbschema EJB to preserve the existing table/schema rules.
WASpostUpgrade使用 -35 -dbschemaEJB 参数来调用EJBDeploy以保留现有的表/模式规则。
The existing table definition must specify the characteristics of the columns of the stored procedure’s first result set.
现有表定义必须指定存储过程第一个结果集的各列的特征。
In DB2 Viper 2, customers can now create XML columns in any new or existing table, inside of any new or existing database.
在DB 2Viper2中，用户现在可以在任何新的或已有的数据库中，在新的或已有的表中创建xml列。
Figure 1 illustrates the WebSphere Information Integrator nickname, Sybase existing table and stored procedure relationship.
图1说明了DB 2 II昵称、Sybase现有表和存储过程之间的关系。
The "create existing table" command in Sybase ase allows you to map the proxy table to a table, view, or procedure at a remote location.
Sybasease中的“createexisting table ”命令允许将代理表映射到在远程位置的一个表、视图或者过程。
If the stored procedure has multiple result sets, the Sybase existing table can only retrieve the first result set from the stored procedure.
如果存储过程有多个结果集，那么sybase现有表只能从存储过程那里获得第一个结果集。
This routine creates a copy of your existing table with the new partitioning key and loads it partially or fully with the data from the original table.
这个例程用新的分区键创建了现有表的一个副本并用来自原始表的数据对它进行部分或全部加载。
Creating an "existing table" creates a proxy table, then retrieves and stores metadata from a remote table and places the metadata into the proxy table.
创建“现有表”时，首先会创建一个代理表，然后检索和存储远程表中的元数据，并将该元数据放入到这个代理表中。
For example, you can browse your database for tables that need to be modified or dropped, perform extended alters, and add columns to an existing table.
例如，您可能需要浏览数据库，修改或删除表，执行扩展修改，在现有的表中添加列。
Creating an empty table with the same structure as an existing table can be done by specifying the LIKE option of the CREATE table command (Listing 4).
通过在CREATETABLE命令中指定LIKE选项，创建一个与现有表结构相同的空表(清单4)。
This SQLJ application connects to a database with data source object ds and fetches the rows from existing table Employee with positioned iterator ByPos.
SQLJ应用程序连接到数据源对象为 ds 的数据库，并使用已定位的迭代器ByPos从现有的Employee表中获取行。
Figure 2 shows the relationship between the WebSphere Information Integrator nickname, the Sybase existing table and the stored procedure in the example.
图2展示了示例中DB 2 II昵称、Sybase现有表和存储过程之间的关系。
Tables and views within the same database must have distinct names, but creating an index with the same name as either an existing table or view is allowed.
相同数据库中的表和视图必须使用不同的名称，但是允许创建与现有的表或视图同名的索引。
The above error can occur if the Sybase existing table definition did not specify the appropriate data type for a column of the stored procedure's result set.
如果sybase现有表定义没有为存储过程结果集的某一列指定适当的数据类型，就可能发生上述错误。
With these techniques, you'll coax Grails into using your existing table and field names, even if they don't conform to the Grails standard naming conventions.
学会了这些技术，您就可以让Grails使用现有的表和字段名，即使它们不符合Grails标准命名规定。
Sybase existing tables can be used with a WHERE clause specifying column names of the existing table to restrict the output received from the stored procedure.
对于Sybase现有表，可以使用where子句指定现有表的列名，以限制存储过程的输出。
This could occur if the Sybase existing table definition specifies a column length that is too short for values in the column of the stored procedure's result set.
如果sybase现有表定义指定了一个列的长度，但是这个长度对于存储过程结果集中这一列的值来说太短了，就会发生这种错误。
The error could also occur if the Sybase stored procedure has multiple result sets and the existing table definition is not for the columns of the first result set.
如果sybase存储过程有多个结果集，而现有表定义不是针对第一个结果集中的各列，那么也可能发生这种错误。
If your table statistics are up to date, you can quickly and inexpensively check the cardinality of the columns in your existing table by issuing the following statement.
如果表的统计信息是最新的，那么就可以通过如下语句快速检查现有表内列的基数。
The WebSphere Information Integrator user or application then selects from the nickname, and WebSphere Information Integrator will connect to Sybase and select from the existing table.
DB 2II用户或应用程序从昵称中进行选择，而DB 2 II则连接到Sybase，并从现有表中进行选择。
The above error can occur if the Sybase existing table definition declares one of the columns to be NOT NULL but there is no value for that column in one of the records of the result set.
如果sybase现有表定义声明某一列为NOT NULL，但是在结果集中的某一行记录在那一列没有值，就可能发生上述错误。
应用推荐