发明名称 |
DATABASE QUERY CURSOR MANAGEMENT |
摘要 |
Disclosed aspects include managing a query cursor. Based on a first query having a first Structured Query Language (SQL) syntax, a first query cursor is established. A second query is detected. The second query has a second SQL syntax which differs from the first SQL syntax. Based on a relationship of the second query with respect to the first query cursor, a determination is made to use the first query cursor to provide a valid results-set for the second query. Using the first query cursor, the valid results-set for the second query is provided. |
申请公布号 |
US2016342652(A1) |
申请公布日期 |
2016.11.24 |
申请号 |
US201514833897 |
申请日期 |
2015.08.24 |
申请人 |
International Business Machines Corporation |
发明人 |
Baranczyk Shawn J.;Konik Rafal P.;Mittelstadt Roger A.;Muras Brian R. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
1. A system for query cursor management, the system comprising:
a memory having a set of computer readable computer instructions, and a processor for executing the set of computer readable instructions, the set of computer readable instructions including: establishing, based on a first query having a first Structured Query Language (SQL) syntax, a first query cursor; detecting a second query having a second SQL syntax which differs from the first SQL syntax; determining, based on a relationship of the second query with respect to the first query cursor, to use the first query cursor to provide a valid results-set for the second query; and providing, using the first query cursor, the valid results-set for the second query. |
地址 |
Armonk NY US |