Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# Importing EAI Settings

You can import the EAI setting by using the following syntax:

    swadm IMPORT_EAI_SETTING <EAISTEP_TYPE> <Complete filename with path>

You can restrict the user access to stored procedures by setting a filter to avoid unauthorized access. In the Name dropdown, the stored procedures are filtered. Once the filter is set, you can view the stored procedures relevant only to you.

To filter the stored procedures in the Name dropdown, run the following command:

    swadm IMPORT_EAI_SETTING EAIDB C:\SWSERVER\FilterSettings.txt

The `IMPORT_EAI_SETTING` filter can have P+ and P- commands, which filter in a sequential order by creating subsets in each step execution.

For example, there are the following stored procedures in the database:
SP_GET_PROC1, SP_GET_PROC2, SP_GET_PROC3, SP_SET_PROC1, SP_SET_PROC2, and SP_SET_DESCRIPTION.

If you require a list of all the stored procedures present in the database, you must set the following filter:

    P+*

where:

| • | P is a procedure.

| • | + appends and fetches the procedures (while '-' excludes the procedures)

Note: '+' is applied on the main set of the stored procedures whereas '-' is always applied on the resultant set obtained after filtering the stored procedures.

| • | * is a wild character that matches zero or more characters.

Note: '?' is another wild character that matches only a single character.

If you set the following filter on the stored procedures, observe how the filter is applied in each step execution and what stored procedures are obtained at the end.

    P+*
    P-SP_SET*
    P+SP_SET_DESCRIPTION*

| • | In the first step, P+* fetches all the stored procedures from the database.

    SP_GET_PROC1
    SP_GET_PROC2
    SP_GET_PROC3
    SP_SET_PROC1
    SP_SET_PROC2
    SP_SET_DESCRIPTION

| • | In the second step, the filter P-SP_SET* excludes all the stored procedures starting with SP_SET that is, SP_SET_PROC1 and SP_SET_PROC2 from the total list of stored procedures. The following are the stored procedures fetched from the database after you apply the second filter.

    SP_GET_PROC1
    SP_GET_PROC2
    SP_GET_PROC3

| • | After applying the final filter P+SP_SET_DESCRIPTION*, the following stored procedures are fetched.

    SP_GET_PROC1
    SP_GET_PROC2
    SP_GET_PROC3
    SP_SET_DESCRIPTION

After importing the EAI setting, you can list the filtered stored procedures in the Name dropdown list by clicking the Refresh button.

Note: If you have imported a text file for the EAI setting, that text file contains rules for the filters. The stored procedures are fetched from the database and are filtered based on the filters in the text file.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2025. Cloud Software Group, Inc. All Rights Reserved.