Data Access Beans
Concepts
Visual composition
Data access beans
Connection aliases and SQL specifications
Parameterized SQL statements
Select bean
Modify bean
ProcedureCall bean
DBNavigator bean
Selector beans
Tasks
Accessing relational data with Data Access beans
Adding the Select, Modify, or ProcedureCall beans to the Visual Composition Editor surface
Making an SQL specification
Making a new SQL specification
Defining a Database Access class
Composing or editing an SQL statement
Composing an SQL statement visually
Specifying the tables for an SQL statement
Joining tables
Specifying search conditions
Specifying result columns
Sorting the result set
Remapping data to a different SQL data type
Displaying the SQL statement
Composing an SQL insert, update, or delete visually
Specifying columns and their values for an SQL update or insert
Composing an SQL procedure call visually
Specifying the stored procedure for an SQL CALL statement
Working with stored procedure parameters
Defining result sets returned by a stored procedure
Displaing the SQL statement for a ProcedureCall bean
Composing an SQL statement manually
Editing Select bean properties
Executing a Select bean
Editing Modify bean properties
Executing a Modify bean
Editing ProcedureCall bean properties
Executing a ProcedureCall bean
Specifying data properties
Specifying a connection alias
Defining a database access class
Defining or editing a connection alias
Displaying and navigating the result set
Adding Selector beans to the Visual Composition Editor
Editing CellSelector bean properties
Editing RowSelector bean properties
Editing ColumnSelector bean properties
Editing CellRangeSelector bean properties
Using Selector beans
Using Selector beans data access properties
Inserting, updating, or deleting data in a result set
Adding the DBNavigator bean to the Visual Composition Editor surface
Reference
IBM APIs
Data access beans
Package com.ibm.db
Package com.ibm.ivj.db.uibeans
Data access beans
DBNavigator
Select
Modify
ProcedureCall
CellSelector
ColumnSelector
RowSelector
CellRangeSelector