The Body page contains executable code. The input parameters you entered on the Basic page fill in here automatically.
You can write your own procedure here from scratch, if you choose. In Connect CDC terminology, you are defining a procedure, a named, complex expression, which the Expression Handler will validate and later compile.
-
Enter your code, observing the rules for procedure as described in Specifying procedures.
-
Click the Validate button to verify the syntax of your procedure. At a minimum, the procedure requires a return statement between the procedure and end statements in order to validate.
-
Once the procedure is valid, click OK to complete the creation of the compiled method.
The compiled method is now available in the Method column on the Table Properties, Mapping page of a source or target table. You can use this compiled method to map data from one or more source columns to any target column for which you want data converted.