RESTART_SELECT_NEXT

Syntax

Command
Mandatory parameter
Optional parameter
Mandatory keyword
Optional keyword

RESTART_SELECT_NEXT ([<Table>])

Description

Makes that the pointer values in RETAINPTR will be neglected at the next table query execution, provided that there have not been executed any previous RESTART_SELECT_NEXT executions during the same transaction. This means that when this instruction is encountered on first instance, the next table query will continue from the initial pointer position. All following queries that are executed during the same transaction will continue from the current pointer position, even if these queries are preceded by a new RESTART_SELECT_NEXT.

Diagram

Returned value type

None

Parameters

Parameter	Description
<Table>	Name of a table.

Remarks


This statement is only intended to be used in the context of LINC migrations. It should therefore not be used for any other purposes.

If a table has been specified, the pointer will be neglected at the next table query that is performed on that specific table.
This means that if the RESTART_SELECT_NEXT instruction contains a table specification, then it will not reset the table cursor position until a query on the concerned table is encountered.

Example

routine process_main
begin_routine
    loop for num-copy := 1 to 10
        rou_checkrepeat ()
    endloop
    if not bool-had-error
        reset_to_start_transaction
        restart_select_next ()
        loop for num-copy := 1 to 10
            rou_checkrepeat ()
        endloop
    endif
    error := bool-had-error
end_routine

Return to

Commands