Reading a flat file with Cognos

[Guy Werry]

The answer would be easier if we knew what platform, version!

We are on HP-Ux, and an older version of Powerhouse, 7.33.D3.  In this kind of environment Quiz/Qtp are not very good for doing this because they don't handle parsing fields of varying size very well.

The Unix utility 'awk', on the other hand, excells at this kind of thing.  It can be used to parse a tab or comma delimited file and then write it out into fixed-length records that Quiz/Qtp like.

Hope that helps.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
Matthew Cox
Sent: Friday, June 23, 2006 3:00 PM
To: powerh-l at lists.sowder.com
Subject: Reading a flat file with Cognos


Is it possible to read a delimited flat file with Quiz or QTP? I have
information from another platform that I would like to update in my
Powerhouse application without spending thousands on an ODBC driver.

Thanks,.
Matt



-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.