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
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?