Database access system
AssigneeInternational Business Machines Corporation
InventorsTakaaki Shiratori, Akio Kido, Shigeru Tachikawa, Tsuneo Mochizuki
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsTakaaki Shiratori, Akio Kido, Shigeru Tachikawa, Tsuneo Mochizuki
Estimating the term…
The invention enables transformation of an SQL statement of CHAR type to another SQL statement of another data type adequate for a database that is defined by a character string type other than CHAR type, thereby enabling to access the database using an SQL statement of CHAR type. At a call level interface (CLI driver), a literal such as a condition clause of an SQL SELECT statement that is included in an application program, a column value of an UPDATE statement or the like is passed to a function of the call level interface as a parameter. The call level interface examines a character type and a character code included in the passed literal, selects the most probable one of character string data types of a database to be accessed, modifies its access syntax in line with the selected data type and attempts to access the database. Accessing of the database is attempted while sequentially modifying the access syntax in the order of probability.
A database access system for interfacing database access from an application, comprising:
A recording medium for storing a program adapted for implementing functions of an interface in a database access system, said program being executable to carry out machine-effected steps of:
A database access system for interfacing database access from an application, comprising:
A recording medium for storing a program adapted for implementing functions of an interface in a database access system, said program being executable by a computer under control of said recording medium to carry out the steps of:
Dependencies are inferred from the claim text.