Example IQD file
COGNOS QUERY
STRUCTURE,1,1
DATABASE,household
TITLE,[Region_DIM]
BEGIN SQL
{select * from Region_DIM}
END SQL
COLUMN,0,serial
COLUMN,1,CategoryName
COLUMN,2,Region of main residence
The database (Household in this example) specified in the IQD file needs to be defined in the Cognos.ini file, like this.
household = ^User ID:^?Password:;LOCAL;OL;DBInfo_Type=MS;Provider=SQLNCLI10;User ID=%s;Password=%s;Data Source=localhost;
Provider_String=Initial Catalog=household;@COLSEQ=
The file location is different between the Cognos versions. For Cognos 10, the file is located at: \c10\CS7Gateways\bin.
See