Manage Binds

Create a New Bind

In the Create New Bind wizard's Definition page, you define the details of the bind.

To define the bind details:

1. In the Setup workspace, in the left navigation, click Binds.
   You see the Binds workspace with the current list of binds.

2. Click Create New.
   You see the Create New Bind Wizard.

3. Enter a Name for the new bind in the space provided.

4. Select the Application Type by clicking on the corresponding button.
   –  Accounting
   –  Non Accounting

5. For Accounting application type, select the Action from the drop-down list. Valid values include:
   –  T2
   –  T4
   –  TR

6. Click the Enabled checkbox to activate the Application Type State.

7. Select the Origin by clicking on the corresponding button.
   –  Custom
   –  Eagle

8. Click to the activate the Advanced Options check box and from the drop-down list, select an advanced option. Options display depending on the Application Type chosen above.
   Accounting Options include:
   – ARRAYSIZE
   – BLOBSTATS
   – COLLECTION
   – DELAYEDINIT
   
   Non-Accounting Options include:
   –  PARAMTYPE
   –  SQLTYPE
   –  SQL
   –  TABLE_NAME
   Additional boxes and lists appear after selecting the desired option. Items can be added and/or deleted using the   buttons as needed.

9. Under Stored Procedure, select a Schema from the drop-down list. Next, select a Package from the drop-down list. Finally, select a Stored Procedure from the drop-down list.

10. Click Show Stored Procedure to show the stored procedure details in the space below.

11. Click Save & Close or Click Next to define Inputs.

Define the Bind Inputs

In the Input page of the Create New Bind wizard, you can define the bind inputs and parameters.

To define the bind inputs:

1. Click Refresh Parameters.
   All of the parameters will be cleaned and repopulated based on the stored procedure selected in the Create New Bind page.

2. Click Ok.

3. To manually edit a parameter name, click on the text box and type in a new name.

4. To change the order of the parameters, click the up and down arrows.

5. Click Save & Validate.

Edit a Bind

You can edit a bind from the wizard.

To edit a bind :

1. In the setup workspace, in the left navigation, click Bind.
   You see the Binds workspace with the current list of binds.

2. Select the bind you want to edit, and then click Edit.
   The Edit Bind wizard displays.

3. Update the fields following the steps outlined in Create a New Bind.

4. Click Save & Validate.
   The edited bind redisplays in the workspace.

Duplicate a Bind

You can duplicate a bind.

To edit a bind :

1. In the setup workspace, in the left navigation, click Bind.
   You see the Binds workspace with the current list of binds.

2. Select the bind you want to duplicate, and then click Duplicate.
   The Duplicate Bind wizard displays.

3. Update the fields following the steps outlined in Create a New Bind.

4. Click Save & Close.
   The duplicate redisplays in the workspace.

Delete a Bind

You can delete a bind from the system.

To delete a bind:

1. In the setup workspace, in the left navigation, click Bind.
   You see the Binds workspace with the current list of binds.

2. Select the bind you want to delete and then click Delete.
   You see a warning message asking you to verify your selection.

3. Click Yes.
   The bind is deleted from the system.