US5794231A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method for application-program database interface
Assignee: International Business Machines Corp
•
Filing: 1996-10-07
•
Granted: 1998-08-11
•
Expires: 2016-10-07
Abstract
Abstract The method provides for treating an embedded static SQL program that resides with the CLI application (rather than at the database manager) in an analogous manner to stored procedures. When the CLI application sends a SQL CALL statement syntactically identical to a stored procedure call, the CLI implementation can intercept the call and, instead of invoking the stored procedure, invoke the embedded static program.
Inventors
- 👤 Margaret H. Li
- 👤 Serge Joseph Limoges
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 23:45
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 6
Claim 1
Independent Claim
81 words
An improved method for database access by a call level interface (CLI) program, comprising: (a) defining a first keyword list of CLI embedded routine names; (b) defining a second keyword list of locations of said embedded routine names; (c) intercepting a CLI statement before delivery to the database upon detection of said first keyword; (d) loading embedded routines named in said first keyword from matching locations listed in said second keyword; and (e) executing said embedded routines by accessing said database.
Claim 2
Dependent Claim
81 words
An improved method for database access by a call level interface (CLI) program, comprising: (a) defining a first keyword list of CLI embedded routine names; (b) defining a second keyword list of locations of said embedded routine names; (c) intercepting a CLI statement before delivery to the database upon detection of said first keyword; (d) loading embedded routines named in said first keyword from matching locations listed in said second keyword; and (e) executing said embedded routines by accessing said database.
Claim 3
Dependent Claim
14 words
The method as claimed in claim 1, wherein said database is DB2 type database.
Claim 4
Dependent Claim
27 words
The method as claimed in claim 2, step (e) further comprising selecting a data field and opening a corresponding cursor, then returning control to said CLI program.
Claim 5
Dependent Claim
147 words
A computer program product comprising a computer usable medium having computer readable program code means therein for implementing an improved method for database access by a call level interface (CLI) program, comprising: (a) computer readable program code means for causing a computer to define a first keyword list of CLI embedded routine names; (b) computer readable program code means for causing a computer to define second keyword list of locations of said embedded routine names; (c) computer readable program code means for causing a computer to intercept CLI statement before delivery to the database upon detection of said first keyword; (d) computer readable program code means for causing a computer to load embedded routines named in said first keyword from matching locations listed in said second keyword; and (e) computer readable program code means for causing a computer to execute said embedded routines by accessing said database.
Claim 6
Dependent Claim
147 words
A computer program product comprising a computer usable medium having computer readable program code means therein for implementing an improved method for database access by a call level interface (CLI) program, comprising: (a) computer readable program code means for causing a computer to define a first keyword list of CLI embedded routine names; (b) computer readable program code means for causing a computer to define second keyword list of locations of said embedded routine names; (c) computer readable program code means for causing a computer to intercept CLI statement before delivery to the database upon detection of said first keyword; (d) computer readable program code means for causing a computer to load embedded routines named in said first keyword from matching locations listed in said second keyword; and (e) computer readable program code means for causing a computer to execute said embedded routines by accessing said database.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-08-10 | 2002-02-09 | 2002-08-11 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-08-10 | 2006-02-09 | 2006-08-11 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-08-10 | 2010-02-09 | 2010-08-11 | $7700.00 | Window Closed / Lapsed |