Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More

Reading COBOL sources via JDBC directly

MVP & Luminary
MVP & Luminary

Reading COBOL sources via JDBC directly

Hi all,

this example shows basically how you could read COBOL sources directly via JDBC.

You need tho following things:

1. the QlikView JDBC Connector: http://jdbcconnector.com

2. the HXTT Cobol JDBC driver: http://www.hxtt.com/cobol.html

2. the COBOL files (.DAT, .IDX, .CPY, .FD), the copybook file or other structural information is required.

The example loads the employee master audit file (PR22EMA.DAT) from the Deltek solution GCS Premier.

- Ralf

Some more hints:

- in some cases you have to square bracket the columns names manuelly: [YOUR-COBOL-COLUMN-NAME]

- sometimes field groupes get not un-nested by the driver: you can specify the grouped fields directly as listed in the .FD file

- columns with "occurs" clause get concatenated: XYZ OCCURS 5 TIMES -> returns as value "[0,0,0,0,0]"

  Update: this seems not to work in all cases, sometimes it returns a JAVA_OBJECT. In this case you have to address

  column by index to unnest: SELECT XYZ(0) as XYZ1, XYZ(1) as XYZ2 .. XYZ(4) as XYZ5 ...

Labels (1)
Attachments
Comments
MVP & Luminary
MVP & Luminary

Please download the newest HXTT COBOL driver here: http://www.hxtt.com/cobol.zip

0 Likes
Not applicable

Hi Ralf,

I've got a random file created in cobol from a client.

I installed on my laptop the jdbc connector and added in it the library found within the hxtt cobol (Cobol_JDBC30.jar).

Within qlikview, i select in the edit script the JDBCConnector_x64.dll, but it is asking for a URL.

Can you provide some tips on how to create this url ?

I tried some combinations but I was getting a message like jvm.dll cannot be loaded and it's not properly configured.

Any hint ?

I've also posted a related question in the community:

http://community.qlik.com/thread/124120

Thx.

0 Likes
MVP & Luminary
MVP & Luminary

Hi Jean-Pierre,

you will find everything on the HXTT site:

installation.html - HXTT Cobol JDBC Drivers for Cobol FB VB data file v2.0

It's very dependend on the COBOL dialect.

- Ralf

0 Likes
Not applicable

Hi,

I've tried to download the files, but I cannot connect COBOL with Qlik. It gives me an error: it says that aren't suitable driver found for my file. How can I do?

0 Likes
MVP & Luminary
MVP & Luminary

Hi Miriana,

this is very likely a configuration issue. Connact me directly to get help: ralf.becher@tiq-solutions.de

- Ralf

0 Likes
Contributor II
Contributor II

Hi, When i used file *.dat dont work. Somebody help me

0 Likes
MVP & Luminary
MVP & Luminary

Hi, do you literally try to use *.dat? I guess you'll need the full filename.

0 Likes
Contributor II
Contributor II

Thanks for you answer, Any file with extension .dat of cobol dont work. When i work with file with extension .fd work so fine, but no with extension .dat or .idx

0 Likes
MVP & Luminary
MVP & Luminary

You will also need the copybook file for the record structure..

0 Likes
Contributor II
Contributor II

do you have an example, what type of extension is a copybook file? thanks a lot

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2012-04-05 09:36 AM
Updated by: