The RECONNECT statement moves the current database record of the run unit
  from one set to another (possibly the same) set.

  Format -

   RECONNECT [ record-name ] WITHIN { { set-name } ... }
                                    { ALL              }

      [           [{| REALM                    |}]          ]
      [ RETAINING [{| RECORD                   |}] CURRENCY ]
      [           [{| { SET [ set-name ] ... } |}]          ]
      [           [{| { { set-name } ...     } |}]          ]

      [ ON ERROR stment ] [ NOT ON ERROR stment ]

      [ END-RECONNECT ]