Creating an export file from Cognos 8

[bruin4ever]

Hi Everyone:

I would greatly appreciate if anyone could help me leverage Cognos 8 to create a output datafile that will be imported into another system.

My two questions are:
1. Assuming I have the query written in Reports Studio, how do construct the output to create a fixed length (or tab delimited) file? (I know I can export to excel, but is there a "export-to-text-file" option?
2. What properties do I have at my disposal to make the fields fixed length? (The underlying database is a Cache DB, not an Oracle DB so I don't have the "RPAD" function to ensure that short fields can be padded)

Thank you!
George
bruin_4ever@yahoo.com

[blom0344]

You can run the report as a .csv output, which is text. You may need to process the textfile after generation in order to get fixed length fields. However why do you need this?