Specifies where and how the data is
retrieved from the database, when using a stored procedure
Navigation
- In AgilePoint Envision, open a process template.
- Navigate to the Database stencil.
- On the Database stencil, drag the
Query Database AgileShape, and drop it on the process template.
- On the SQL Type list, select Stored Procedure.
- On the Configure field, click the Ellipses button.
Field Definitions
| Field Name |
Definition |
Connection String
|
- Definition:
- Specifies the connection string that is used to connect to the database.
- Click
Choose to select a connection string from the list of
shared custom attributes (defined and managed in Enterprise Manager.)
- Click Create to
create a new connection string.
- Allowed Values:
- A valid SQL connection string.
- Default Value:
- server=myserver;database=pubs;trusted_Connection=yes
- Custom Attributes:
- Yes
- Example:
- server=DataServer;database=StoreDb;trusted_Connection=yes
|
Create
|
- Opens the Following Window:
- Database Connection Configuration Window
- Purpose of this Window:
- Creates a connection string with specified information.
|
Choose
|
- Opens the Following Window:
- Browse Custom Attributes Window
- Purpose of this Window:
- Specifies a connection string from a list of shared custom attributes.
|
Stored Procedure Name
|
- Definition:
- The name of the stored procedure.
- Allowed Values:
- A valid stored procedure name.
- Default Value:
- None
- Custom Attributes:
- Yes
- Example:
- GetUserDetail
|
Parameter Name
|
- Definition:
- The parameters for the stored procedure.
- Allowed Values:
- A valid parameter for specified stored procedure.
- Default Value:
- None
- Custom Attributes:
- Yes
- Example:
- OrderNumber
|
Value/Attr Name
|
- Definition:
- The value of the parameters for the stored procedure.
- Allowed Values:
- A valid value for the specified parameter.
- Default Value:
- System.String
- Custom Attributes:
- Yes
|
in/out
|
- Definition:
- Specifies the in/out parameters for the stored procedure.
- Allowed Values:
-
- Input - Specifies that the parameter is an input value for the stored procedure.
- Output - Specifies that the parameter is an output value for the stored procedure.
- InputOuput - Specifies that the parameter can be input/output value for the stored procedure.
- ReturnValue - Specifies that the parameter is a return value for the stored procedure.
- Default Value:
- None
- Custom Attributes:
- No
|
Data Type
|
- Definition:
- Specifies the SQL server data type of the specified parameter for the stored procedure.
- Allowed Values:
- Bit
- Decimal
- Float
- DateTime
- VarChar
- Binary
- Integer
- Default Value:
- None
- Custom Attributes:
- Yes
|
Size
|
- Definition:
- Specifies size of input parameter for the stored procedure.
- Allowed Values:
-
- Default Value:
- None
- Custom Attributes:
- No
|
Add
|
- Function:
- Adds new parameter for the stored procedure.
|
