Help Needed: Cognos Powerhouse. Accessing Flat File in Power House

[Vidyasagar Goparaju]

Hi Vamsi,

I think there is a mismatch between your subfile record length and the text file record length.

Find out the subfile record length using qshow and convert your VENDORS.txt file using 'dd' command as following:

dd bs=<record length> cbs=<record length> conv=block if=VENDORS.txt of=DUNS_EXTRACT.sf

That should do the trick.

Sagar

-----Original Message-----
From: powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.com
[mailto:powerh-l-bounces+vgoparaju=tradepointsystems.com at lists.sowder.co
m]On Behalf Of vamsi krishna
Sent: Tuesday, November 07, 2006 1:04 PM
To: powerh-l at lists.sowder.com
Subject: Help Needed: Cognos Powerhouse. Accessing Flat File in Power
House


Hi ,
I need your help in Powerhouse. Actually i am very new to this technology.
I work on a Unix system on which Cognos Powerhouse is installed.
I have a text file( flat file) which contains a list of records with single
item(call SRC). I need to access this data, and for that i need to put this
data in a subfile and access through Powerhouse. I created a empty subfile
with required structure and replaced the subfile with the text file
mv VENDORS.txt DUNS_EXTRACT.sf

 and tried to access it using quiz, and results were ambiguous(one record
was split in two lines).
For eg if the record SRC was EA3F446
while doing i got the results in two lines:
EA3
F446
Which is
please tell me how to convert this txt file to a subfile.

I'd be really grateful to you if you can help me in this

Thanks and Regards,
Vamsi
-- 
"Nothing is impossible as impossible itself says i m possible"
-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.