DataSource

The DataSource option specifies a main Impromptu Query Definition (IQD) data source and one or more alternate data sources, with their associated options.

For more information on IBM® Cognos® data sources and options, see appqueryopts.

The syntax is as follows:

DataSource objDataSource AlternateSource filename  [altdatasourceopts]

where objDataSource is the object name and altdatasourceopts is one or more of the following:

  • Isolationnumber
  • DmsSignonobjSignon
  • IMRNamestring
  • SourceSignonList signon signons...] EndList
  • SQLstring
  • Stampnumber

Example

The following example shows the SQL for an Impromptu Query Definition (IQD) data source:

DataSourceMake 103 "Report1" Separator " " SourceType DataSource DecimalSep " 
"Thousandsep " " Columns True Timing PopYesCreateDefault Source "C:\Report1.iqd" 
SQL 'select T1."PROD_TYPE" as c1,' 'T1."PROD_LINE" as c2, T1."PRODUCT"'  'as c3, T1.
"PROD_COST" as c4,' 'T2."ORDER_DT" as c5 from "ORDRDETL" T3,' '"PRODUCT" T1,"ORDER" 
T2' 'where (T3."PROD_NO" = T1."PROD_NO")' 'and (T2."ORDER_NO" = T3."ORDER_NO") and' '
(T1."PROD_TYPE" = "Outdoor Products) " Isolation 0 SourceSignonList 105 1105 
EndList ImrName "C:\Report1.imr" Stamp 930750524  Speed False SetCurrent True 
ServerSource False Presummarized False