Default language.

Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

INTERVAL statement and parameter


The INTERVAL statement specifies the time interval that applies to the data that is included in reports produced by subsequent REPORT statements in the same job stream.

If a default interval is specified in the report, the INTERVAL statement overrides that default interval.

When used as a parameter of the REPORT statement, the specified interval relates only to the reports that are specified in that REPORT statement. The INTERVAL parameter overrides a default interval and any previously specified INTERVAL statement.

Valid abbreviations for INTERVAL are INT and I.

The date format in the INTERVAL specification is determined by one of the following options:

  • Global option called Site date formatting style option (acts as the default for all users)
  • User Profile Presentation Options field called Date formatting style option (overrides the global default)
  • User Options Presentation Options field called Date formatting style option (overrides the User Profile specification)

For more information, see Valid-date-formats-for-the-START-and-END-keywords.

This section contains the following topics:

Related topic



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*