If you happen to re-use a small collection of stored procedures throughout all of your process flows, there is a shortcut that you can adopt when configuring your activities. Before launching the Design Console, you can add some lines to the config.properties (located in the bin directory under your Enterworks Installation). The lines that are added to the config.properties provide a default configuration that will be adopted by all newly created decision point activities. The following is an example of the lines that you might add to your config.properties:
#
# Default Stored Procedure configuration for Decision
# Point Activities
#
# if dpa.defaults.storedprocedures.enabled is not specified
# then defaults will not be loaded
#
# true if stored procedures are enabled at the activity
# false if stored procedures are disabled at the activity.
# A false value here over-rides the indvidual 'enabled' values
# of each procedure.
#
dpa.defaults.storedprocedures.enabled=true
#
# number of stored procedures defined
#
dpa.defaults.storedprocedures.procedure-count=1
#
# The following keys include a number from 0 to
# procedure-count - 1, describing each procedure
#
# fully qualified name of stored procedure 0
#
dpa.defaults.storedprocedures.0.name=NicksContent.system.getValue
#
# true if stored procedure 0 is enabled
#
dpa.defaults.storedprocedures.0.enabled=true
#
# the number of parameters for the procedure 0
#
dpa.defaults.storedprocedures.0.parameter-count=4
# ----- parameter 0 of procedure 0 -------------
#
# the value to be passed in to parameter 0 of stored procedure 0
# If the parameter is of type OUT or INOUT a work item key must
# be specified with or without % symbols.
# If the parameter is of type IN then literal values may be
# specified or a work item key may be specified wrapped with
# % symbols.
#
dpa.defaults.storedprocedures.0.param.0.value=%sys.workitem.uid%
#
# the direction of parameter 0 stored procedure 0
#
# 0=IN
# 1=OUT
# 2=INOUT
#
dpa.defaults.storedprocedures.0.param.0.in-out-type=0
#
# the data type of parameter 0 stored procedure 0
#
# 0=STRING
# 1=BOOLEAN
# 2=DATE
# 3=NUMBER
#
dpa.defaults.storedprocedures.0.param.0.data-type=0
# ----- parameter 1 of procedure 0 -------------
#
# the value to be passed in to parameter 1 of stored procedure 0
# If the parameter is of type OUT or INOUT a work item key
# must be specified with or without % symbols.
# If the parameter is of type IN then literal values may be
# specified or a work item key may be specified wrapped
# with % symbols. dpa.defaults.storedprocedures.0.param.1.value=%casenumber%
#
# the direction of parameter 1 stored procedure 0
#
# 0=IN
# 1=OUT
# 2=INOUT
#
dpa.defaults.storedprocedures.0.param.1.in-out-type=0
#
# the data type of parameter 1 stored procedure 0
#
# 0=STRING
# 1=BOOLEAN
# 2=DATE
# 3=NUMBER
#
dpa.defaults.storedprocedures.0.param.1.data-type=0
# ----- parameter 2 of procedure 0 -------------
#
# the value to be passed in to parameter 2 of stored procedure 0
# If the parameter is of type OUT or INOUT a work item key
# must be specified with or without % symbols.
# If the parameter is of type IN then literal values may be
# specified or a work item key may be specified wrapped
# with % symbols.
#
dpa.defaults.storedprocedures.0.param.2.value=%requesttype%
#
# the direction of parameter 2 stored procedure 0
#
# 0=IN
# 1=OUT
# 2=INOUT
#
dpa.defaults.storedprocedures.0.param.2.in-out-type=0
#
# the data type of parameter 2 stored procedure 0
#
# 0=STRING
# 1=BOOLEAN
# 2=DATE
# 3=NUMBER
#
dpa.defaults.storedprocedures.0.param.2.data-type=0
# ----- parameter 3 of procedure 0 -------------
#
# the value to be passed in to parameter 3 of stored procedure 0
# If the parameter is of type OUT or INOUT a work item key
# must be specified with or without % symbols.
# If the parameter is of type IN then literal values may be
# specified or a work item key may be specified wrapped with % symbols. dpa.defaults.storedprocedures.0.param.3.value=balance
#
# the direction of parameter 3 stored procedure 0
#
# 0=IN
# 1=OUT
# 2=INOUT
#
dpa.defaults.storedprocedures.0.param.3.in-out-type=1
#
# the data type of parameter 3 of stored procedure 0
#
# 0=STRING
# 1=BOOLEAN
# 2=DATE
# 3=NUMBER
#
dpa.defaults.storedprocedures.0.param.3.data-type=0
Using the above example will cause all newly created Decision Point Activities to adopt the following default Stored Procedure Configuration:
