how to read COBOL data files in qlikview?

[#1]

Hello everyone,

I cant find the way to read COBOL data files in QlikView.

I know there is a connector and drivers, but I don know how to use this tools.

If someone can explain this a little, or maybe tell me a way to convert my COBOL files in a excel o something that QV can read.

I know there is a not free programs from cobol to do this, but im searching something more easy and fast

[rajeshvaswani77]

Hi Marcos,

Please see this post.

http://community.qlik.com/docs/DOC-2904

Thanks,

Rajesh Vaswani

[suniljain]

you can refer

http://community.qlik.com/message/68040#68040

[#4]

Hi Sunil,

I read that posts, but I dont get how to use this tool, someone have any tutorial for this?

I recently can convert de cobol data files into a CSV, but i have problems when a Comma is in a number or between words that belong to the same filed, and qlikview separate this like two diferent fields.

Example:

the:      U$D 42,686

become:  U$D 42     |    686

so not worth it...

[Anonymous]

To delimited your CSV files use char ; instead of char ,

[rajeshvaswani77]

In addition to what car bal has suggested, on the same lines.

You can use tilde as well, since it would be never used in normal.

thanks,

Rajesh Vaswani

[#7]

Thanks to all..but I still have this problem:

Im using a program call dat2flat.exe from cobol to make this CSV , this one run under D.O.S.

I Make a .bat file and in prompt I put: c:\dat2flat.exe  -out-file=MyText.txt  IV04.000

but I cant find the way to replace the Comma for another character.

Any Idea?

[rajeshvaswani77 · Accepted solution]

Can you at command prompt just type c:\dat2flat.exe/?

This will show if the exe file can be given any parameters to do this.

thanks,

Rajesh Vaswani

[#9]

Great, the parameter is "separator=','" for comma.

Genius!

[Anonymous]

Marcos:

May be some information will help us to answer:

What type or brand of Cobol are you using ?

What type of file is IV04.000 (sequential, indexed, line sequential, direct, ...)

Are a programmer,an user or both ?

Can you access the source that create the fiile to convert ?

Do you can run an utility that can convert the mentioned file to some txt ?

....