IMPORT subcommand (GETCOGNOS command)

The required IMPORT command specifies the data to import. The subcommand is followed by one of the following alternatives:

FIELDS. Specifies a list of fields to include.

  • This is required if MODE=DATA.
  • The keyword is followed by an equals sign (=) and a list of fields.
  • Each field specification must be enclosed in quotes. The general form of a field specification is '[namespace].[query subject].[query item]'.
  • Valid variable names are automatically generated based on the query item name. Optionally, you can specify a variable name in parentheses after the field specification. Names must be unique and must conform to variable naming rules. See the topic Variable Names for more information.
  • Optionally, you can also specify AGGREGATE=YES to import aggregated data instead of raw data. If no aggregation is defined in the IBM® Cognos® Business Intelligence package, this setting is ignored.

REPORT. Specifies the name of a list report to read.

  • This is required if MODE=REPORT.
  • The keyword is followed by and equals sign (=) and a report name enclosed in quotes.
  • The only type of report that can be read is a list report.

Example

 /IMPORT FIELDS=
  '[Sales (query)].[Product brand].[Product number]',
  '[Sales (query)].[Product brand].[Introduction date]',
  '[Sales (query)].[Product brand].[Product color code]' (Color),
  '[Sales target (query)].[Product brand].[Product size code]'(Size)