INSERT

INSERT includes a file of commands in a session. INSERT is especially useful for including a long series of data definition statements or transformations. Another use for INSERT is to set up a library of commonly used commands and include them in the command sequence as they are needed.

Note: Equals signs (=) used in the syntax chart are required elements.

INSERT  FILE='file specification' [PASSWORD='password']
       [SYNTAX = {INTERACTIVE*}]
                 {BATCH       }
       [ERROR = {CONTINUE*}]
                {STOP     }
       [CD = {NO*}]
             {YES}
       [ENCODING = 'encoding specification']

*Default if keyword omitted.

This command takes effect immediately. It does not read the active dataset or execute pending transformations. See the topic Command Order for more information.

Release History

Release 13.0

  • Command introduced.

Release 16.0

  • ENCODING keyword added for Unicode support.

Release 22.0

  • PASSWORD keyword introduced.

Example

INSERT FILE='/examples/commands/file1.sps'
  SYNTAX=BATCH ERROR=STOP CD=YES ENCODING='UTF8'.