To utilize this functionality, you need to refer to the database cursor by name, as shown in Listing 6.
要利用此项功能,您需要按名称引用数据库游标,如清单6所示。
The previous example held the database cursor open between user interactions, preventing other users from accessing database segments that are locked.
在前面的示例中,两个用户交互之间将保持数据库游标打开,从而防止其他用户访问被锁定的数据段。
The EJB 2.x approach enables the flexibility to do performance enhancing tricks like map the get() methods onto a database cursor or stream implementation, reducing the number of transformations.
EJB 2.x方法允许灵活地进行性能增强,例如将get()方法映射到数据库指针或流实现上,以降低转换次数。
All of this is fine, but the real value of directly manipulating a cursor is the ability to update the database at a particular position.
上述这些游标都很有用,但是,直接操纵游标的实际价值在于在特定位置更新数据库的能力。
With the help of sample scenarios, the article demonstrates how DB2's LOAD FROM CURSOR feature can be used to copy data fast and simple within a database and also between different databases.
本文通过示例场景演示了如何使用DB2的LOADFROM CURSOR特性在一个数据库中以及不同的数据库之间快速轻松地复制数据。
As the example in Listing 1 demonstrates, to work with an SQL cursor, you need to have a suitable database.
如清单1中的示例所示,要使用SQL游标,您必须有一个适当的数据库。
Now that federated access to the table in the source database is configured, the LOAD FROM CURSOR operation works exactly the same as already shown.
配置了对源数据库表的联邦访问之后,就可以像前面一样执行LOADFROM CURSOR操作。
A sensitive cursor provides a dynamic view of the underlying data, whereas an insensitive cursor generally isn't sensitive to any changes made to the database while the cursor is open.
敏感游标将提供底层数据的一个动态视图,而不敏感游标通常对游标打开时数据库的变化不敏感。
Now when performing the LOAD FROM CURSOR operation within the stored procedure, DB2 tries to establish the remote connection to database SAMPLE with the authorization ID of the local user.
在存储过程中执行LOADFROM CURSOR操作时,DB2尝试用本地用户的授权ID连接远程数据库SAMPLE。
There are several implementations of the Adapter class, for specific tasks, such as the CursorAdapter for reading database data from a Cursor, or an ArrayAdapter for reading from an arbitrary array.
针对特定的任务有着很多不同的Adapter类实现,比如CursorAdapter依据Cursor读出一个数据库的数据,而一个ArrayAdapter则从任一个数组进行读取。
The last step to prepare the LOAD FROM CURSOR operation is to configure the federated access to table SALES in the source database SAMPLE.
准备LOADFROM CURSOR操作的最后一步是配置对源数据库sample中sales表的联邦访问。
That means: Using LOAD from CURSOR, a table can be copied from one database into another database, too. This can be accomplished in two ways.
这意味着:通过使用LOADFROM CURSOR,也可以把表从一个数据库转移到另一个数据库。
Three exploits followed: an attack on Microsoft Word, an exploit for Microsoft's animated cursor vulnerability and the Slammer worm, which exploited a flaw in Microsoft's SQL database engine.
最后是三个漏洞:一个是攻击MicrosoftWord的,一个是利用Microsoft's animated cursor vulnerability漏洞的,最后是利用Microsoft's SQL数据库引擎漏洞的Slammer worm蠕虫。
Instead, the remote database is just specified in the DECLARE CURSOR statement using the database option.
只需使用DATABASE选项在DECLAREcursor语句中指定远程数据库。
When you select a set of data from a table or tables in a database, the returned data is known as a cursor.
当您通过数据库的一个或多个表选择一组数据时,返回的数据也称为游标。
A cursor is a database structure that allows you to iterate through the results of an SQL query.
游标是一种数据库结构,它将允许您循环访问SQL查询的结果。
XMLReader is a pull parser and you code for it in much the same way as for a database query result table in a cursor.
XMLReader是一种pull解析器,其编码方法和数据库查询结果表的游标中非常类似。
In both cases, this functionality is implemented within the Derby database (or any other SQL-compliant database) by a cursor.
在两种情况下,此功能在Derby数据库(或者任何其他兼容sql的数据库)中都是通过游标来实现的。
Specifies the path to the database that contains the table or view associated with the Cursor object.
指定数据库的路径,该数据库包含与临时表对象相关的表或视图。
Finally, the detailed idea and class implementation to backup and restore database as well as the application of stored procedure and cursor in restoring database are given.
详细给出了备份和还原的具体思路和类实现,存储过程和游标在还原中的应用。
Finally, the detailed idea and class implementation to backup and restore database as well as the application of stored procedure and cursor in restoring database are given.
详细给出了备份和还原的具体思路和类实现,存储过程和游标在还原中的应用。
应用推荐