Running the Create Database Call Wizard

The business services framework provides a Create Database Call Wizard that generates Java code for calling a database operation. You create a database call in the code already created by the Create Business Service Wizard. You must be at an appropriate location within the code to create the database call method. A TODO tag should be available to help you find this location. The Create Database Call Wizard helps you select a table or business view to use for your new database operation call. After you launch the wizard, it displays a page that has the following database operations:

• Select

• Insert

• Update

• Delete

After you select the type of database operation you want to use, the wizard helps you search for a table or business view to use in your database operation call. The wizard then guides you through a series of steps prompting you for information.

After you specify the appropriate information, the wizard creates a conceptual SQL statement that you can preview. If the SQL statement does not show what you need, you can return and change your specifications. When you are satisfied with your selections, the Database Call Wizard generates the call and accompanying code, which is unique for the database operation that you selected.

The Create Database Call Wizard allows the data types and operations identified in this table:

Data Type	Data Type Shown in Wizard	Allowed Operators
EVDT_CHAR	Character	=, >, >=, <, <=, <>
EVDT_JDEDATE	Date	=, >, >=, <, <=, <>
EVD_INT	Integer	=, >, >=, <, <=, <>
EVDT_LONGVARCHAR	Character (BLOB)	Not allowed in WHERE clause
EVDT_LONGVARBINARY	Binary (BLOB)	Not allowed in WHERE clause
EVDT_STRING	String	=, >, >=, <, <=, <>, LIKE If size is greater than 255, Oracle database treats as a BLOB, which is not allowed in WHERE clause
EVDT_VARSTRING	Variable String	Not allowed in WHERE clause
EVDT_JDEUTIME	JDE Utime	=, >, >=, <, <=, <>
EVDT_MATH_NUMERIC	Numeric	=, >, >=, <, <=, <>
EVDT_ID	Identifier (ID)	=, >, >=, <, <=, <>

To run the Database Call Wizard:

1. Open the Java file for the business service.

2. In the JDeveloper editor pane, place the cursor at a valid position for inserting the Java method.

3. From the context menu, select EnterpriseOne, and then select Create Database Call.

   If Create Database Call is disabled on the context menu, the cursor is not at a valid position in the code.

4. Click Next.

5. On the Create EnterpriseOne Database Call introduction window, click Next.

   If the authentication page appears, enter your credentials, and then click Next.

6. On the Select a Database Operation page, select a database operation and then click Next.

7. On the wizard search page, select one of these object types:

   • Table

   • Business View

8. Find a table (business view) by performing one of the following tasks:

   • If you do not have any information about the table (business view), click Find to list all tables (business views) and scroll through the list. Select a table (business view).

   • If you have some information about the table (business view) you want to use, complete one or more of these search fields to filter the search, and then click Find:

     – Object Name

     – System Code

     – Description

     – Reporting System Code

     You can use wild cards in any of these search fields.

     Select a table (business view) from the search results, and then click Next.

   • If you know which table (business view) you want to use, click Advanced Find.

     Using the drop-down list box, select the appropriate information for each of these fields, and then click Next:

     – Object Type

     – Object Name

9. The next page of the wizard opens showing the operation that you selected along with the attributes of the table (business view) that you selected.

10. Depending on the database call operation you are creating, go to one of these tasks in this guide:

    • Create a Select database operation.

    • Create an Insert database operation.

    • Create an Update database operation.

    • Create a Delete database operation.