HI,
Can anyone tell me , how can i Start creating my Iqd file in notepad. I have gone through some of the answers listed here in this weblog. but finding hard to start with database drivers(where i would get them) and how to write in the file.
thanks anyone.
I always use this IQD, where DBNAME is the database name specified in cognos.ini. Your query is placed between brackets and after the sql you can specify the column names as they appear in Transformer.
COGNOS QUERY
STRUCTURE,1,1
DATABASE,DBNAME
TITLE,Report6
BEGIN SQL
{select
columnA,
columnB,
columnC
from
table
where columnA > 0
}
END SQL
COLUMN,0,Column A
COLUMN,1,Column B
COLUMN,2,Column C