Patent Document ID: 9047337
Application ID: 11741683

Base Claim:
1. A method of providing database connectivity within an integrated development environment (IDE) tool, the method comprising: displaying a portion of source code in an editing pane of the IDE tool, wherein the portion of the source code includes at least a text string representing a database statement; determining a database to be accessed using the database statement; establishing a database connection between the IDE tool and the database; retrieving a data model associated with the database; upon determining the database statement includes one or more host variables passing data to the database, prompting for a value for each host variable; evaluating, based on the data model, the database statement to identify any errors in the database statement, wherein evaluating the database statement includes executing the database statement and providing an option to commit or rollback one or more database changes made as a result of executing the database statement; providing programming assistance based on the database statement and the data model, including providing an indication of any errors identified by the evaluation; and storing, by the IDE tool, the value provided for each host variable to allow the database statement to be re-executed from within the IDE tool without again prompting for values for the host variables.

---

Claim 2:
2. The method of claim 1 , wherein the data model comprises a relational schema specifying an organization of tables, columns, and keys defined for the database associated with the data model.