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.
Rename the
IKM SQL Control Append KM
toIKM SQL Control Append with Variable and Substitution
.Add a step. Name the step
Retrieve Session Number
and write the following code in that step:<%v_sess=odiRef.getSession("SESS_NO")%>
Move this step up to make sure that it is the very first step in the KM, the same way we did it in step 6 of Using Java variables in KMs.
Edit the step
Create...