Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to read COBOL data files in qlikview?

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

1 Solution

Accepted Solutions
rajeshvaswani77
Valued Contributor III

Re: how to read COBOL data files in qlikview?

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

11 Replies
rajeshvaswani77
Valued Contributor III

Re: how to read COBOL data files in qlikview?

Hi Marcos,

Please see this post.

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

Thanks,

Rajesh Vaswani

suniljain
Honored Contributor

Re: how to read COBOL data files in qlikview?

Not applicable

Re: how to read COBOL data files in qlikview?

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

carbal1952
Contributor II

Re: how to read COBOL data files in qlikview?

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

rajeshvaswani77
Valued Contributor III

Re: how to read COBOL data files in qlikview?

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

Not applicable

Re: how to read COBOL data files in qlikview?

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
Valued Contributor III

Re: how to read COBOL data files in qlikview?

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

Not applicable

Re: how to read COBOL data files in qlikview?

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

Genius!

carbal1952
Contributor II

Re: how to read COBOL data files in qlikview?

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 ?

....

Community Browser