The Fetch Once after Prior Select command moves a single row/record/table (pointed to by the cursor) to ECMap’s record definition buffer, after a select statement has retrieved the data from a database. A new record is moved only one time during map execution. This command is equivalent to Sequential I/O - Read Record.
SQL Application File Name – the internal ECMap name that provides the link to the database to which the data is moved.
SQL Application File Record – the internal ECMap name for the specific rows/record/table (in the file/database specified above) to which the data is moved.
SQL Table Name – the name of the database table that corresponds to the internal ECMap file name. This is the actual database table from which the data was retrieved.
