Using substitution methods in Java
For this recipe, we will make a very
simple modification to the
IKM SQL Control Append by combining a Java variable and a substitution API. Then we will use this KM in an interface to see how the code gets generated.
You will need to have a project ready where the
IKM SQL Control Append KM has been imported. You must also have a table that can be used as a target table using this IKM in an interface.
How to do it...
- Rename the
IKM SQL Control Append KMto
IKM SQL Control Append with Variable and Substitution.
- Add a step. Name the step
Retrieve Session Numberand write the following code in that step:
There is no need to set the technology for this step: as you ...