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]"