You can add checkpoints to lines in the SQL and XQuery
editor to help you verify results at specific points in a set of statements.
When the statements are run from the SQL and XQuery editor, each checkpoint
causes the run environment to stop running until you start it again.
About this task
Adding checkpoints to your statements gives you the option
to run only a subset of the statements so that you can verify the
results before you continue to run the remaining statements. When
you add a checkpoint to your statements, all the statements before
that checkpoint are run when you click
Run SQL. For
example, you can add multiple checkpoints to a large set of statements
to run the statements in separate groups and verify the results as
each group of statements is run. If multiple statements are on a single
line, adding a checkpoint to that line excludes all statements on
that line from being run with any statements before the checkpoint.
Tip: You can use checkpoints in combination with the run options
to run and verify the results of your statements, including the run
options
Run statements starting from the cursor location and
Run
selected statements. For example, you can place your cursor
at any statement or in between any two checkpoints and then click
Run
statements starting from the cursor location in the run
menu

to
run only the statements from the position of the cursor to the next
checkpoint.