SQL Cursor

Overview

The SQLCursorWorkEntryExecutor class generates SELECT SQL statements from template statements specified in the Code-Block. The template statements have placeholders for source-to-target mappings that are substituted at runtime with appropriate values from the mappings.

This executable works like theSQLSetWorkEntryExecutor. The difference is that the SQLCursorWorkEntryExecutor is explicitly intended for source-to-target copy tasks. It processes the rows one by one to invoke Java transformer methods for each row. For example, you can use this executable for source-to-TableCursor target mappings where a Java transformer is required.

Select a Target Level mapping and Target Types table set, and create an appropriate SELECT … template statement for this executable class.

Parameters

See Common executable features below for details on other variables and syntax that can be used.