Recompiles all invalid objects in a supplied schema. This operation will only run if invalid objects are found. Operation returns various outputs to indicate invalid object count (before and after) and number of objects recompiled.
Environment/Instance Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
JDBC URL |
| Yes | The JDBC URL of the database. |
JDBC User |
| No | The username that will be used to connect with. |
JDBC Password |
| No | The password of the username. |
JDBC Driver Path |
| Yes | Classpath for locating the JDBC Driver (e.g. for Weblogic - |
Project Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
Inputs
Input Name | Input Code | Required | Description |
---|---|---|---|
Schema Name(s) |
| No | Comma separated list of schema where objects will be compiled. |
Outputs
Output Name | Required | Description |
---|---|---|
| The returned value from the query. | |
FDJDBC_OUT_RECOMPILE_COUNT | ||
FDJDBC_OUT_POST_INVALID_CNT |
Artifacts
This operation does not produce or consume artifacts.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
Endpoint Execution
This operation will randomly execute on one of the endpoint identified during selection.