topic Re: Re: Re: JDBC Connector to Cobol - URL path in QlikView

JDBC Connector to Cobol - URL path

Wed, 02 Jul 2014 13:56:00 GMT

Dears,

I'm trying to connect to files created in cobol.

For that, I installed the jdbc connector (32bit) and used the library file Cobol_JDBC30.jar.

After which I was able to see the JDBCConnector.dll (32) in the list of databases in the edit script.

It's now asking for a url to be configured.

Can anyone provide some tips for how to create this url ?

Thx.

Re: JDBC Connector to Cobol - URL path

rbecher — Fri, 04 Jul 2014 08:44:59 GMT

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

Re: Re: JDBC Connector to Cobol - URL path

Tue, 22 Jul 2014 09:25:58 GMT

Hi Ralf,

Thx for your answer, the url works fine.

The customer uses Cobol MicroFocus version 5.

Files created are .dat files (but cannot be read as Table Files) with an index file.

Based on the attached error, we either need files with specific extensions or a Create Table statement.

I doubt that we can get those extensions, but I'll be checking that later today on client site.

On the other hand, can you suggest a skeleton code of how to include the sql "create table" statement within the qv script ?

Appreciate your help.

Re: Re: Re: JDBC Connector to Cobol - URL path

Thu, 24 Jul 2014 13:47:31 GMT

I'm attaching a sample cobol file (dat and idx).

Appreciate suggestions of how to load it into QV.

Re: Re: Re: JDBC Connector to Cobol - URL path

rbecher — Thu, 24 Jul 2014 15:18:49 GMT

I guess you will need a copybook file (cpy) also to describe the data structure.

Re: Re: Re: JDBC Connector to Cobol - URL path

Wed, 30 Jul 2014 08:46:43 GMT

Thx Ralf.

As you suggested, I just had to add the .cpy named same as the cobol data file and the reload worked fine.

But I got a little more complex file regarding its structure with one of the fields declared as:

02 ragtab.

03 ragmon pic s9(14)v999 occurs 12 times.

Seems that the connector doesn't recognize it, and the reload is creating 1 field (ragmon) with all values similar to: [Ljava.lang.Object;@bb1bc4

I also tried using a newer library Cobol_JDBC40.jar (instead of Cobol_JDBC30) but I got this error:

Failed to load table WRAG000:Unsupported index file format 3 now.

Have you come across such case ?

Is there any workaround or new library/driver that may recognize the "occurs" syntax ?

Appreciate your time and help.

Re: Re: Re: JDBC Connector to Cobol - URL path

rbecher — Wed, 30 Jul 2014 09:33:40 GMT

Cannot say what the reason is, this has worked before. Could be a config problem or a case for our professional services.

Re: Re: Re: JDBC Connector to Cobol - URL path

Thu, 31 Jul 2014 09:31:14 GMT

I see, so if the demo file on your community blog works fine for "occurs", the difference is using the 64-bit connector (JDBCConnector_x64.dll).

I downloaded a 64-bit version of the jvm.dll from a website and replaced the one under C:\Program Files (x86)\Java\jre7\bin\client and placed it also under C:\Windows\SysWOW64.

However I'm not able to fully register the dll (regsvr32 command) as I'm getting below error:

I'd be thankful if you can confirm that the "occurs" syntax works or doesn't work with a 32-bit connector.

And how can I get the 64-bit dll to work fine.

Many thanks.

Re: Re: Re: JDBC Connector to Cobol - URL path

rbecher — Thu, 31 Jul 2014 09:39:07 GMT

Where you've downloaded the program?? The only working solution is the actual trial download from our website! All other versions hanging around sonewhere are not legal nor supported anymore. However, your problem is not related to 32bit or 64bit version!

Re: Re: Re: JDBC Connector to Cobol - URL path

rbecher — Thu, 31 Jul 2014 09:49:55 GMT

Btw the program comes with an comfortable installer, no need for dll hacking. If you want to try the trial you have to remove and deregister all former versions..

Re: Re: Re: JDBC Connector to Cobol - URL path

Thu, 31 Jul 2014 10:32:32 GMT

Surely Ralf, that's not the intention at all.

And I already have java installed from java website (java 7 update 60). So jvm.dll was already there and I replaced this file alone.

But when I first tried using the 64-bit connector within QV, I was getting an error:

"Can't load the jvm.dll. Please make sure it's properly configured."

However the 32-bit worked fine except for the "occurs" syntax.

It was a suggestion from someone who had same problem within oracle to replace the jvm with a 64-bit version and it appeared to be logical having the above error.

So as per your reply, do you suggest I uninstall java-related software and reinstall your connector ?

I don't have any previous jdbc connector installations, the trial connector is the first one I install on my laptop.

Thanks.

Re: Re: Re: JDBC Connector to Cobol - URL path

rbecher — Thu, 31 Jul 2014 10:49:18 GMT

You can deinstall the connector, install Java 64bit, reinstall the connector. But, as I said I guess the issue is not related to this.

Re: Re: Re: JDBC Connector to Cobol - URL path

Thu, 31 Jul 2014 13:51:07 GMT

Indeed, after installing java 64-bit, I was able to choose related connector and reload data.

However I still get the [Ljava.lang.Object;@bb1bc4 in the field declared as "occurs".

What are my options now to make this work ?

Re: Re: Re: JDBC Connector to Cobol - URL path

rbecher — Thu, 31 Jul 2014 17:25:17 GMT

As I said earlier our professional services could investigate the issue and could probably build a solution..

Re: JDBC Connector to Cobol - URL path

Tue, 05 Aug 2014 09:19:30 GMT

Dear Ralf,

Further to the above and to discuss how your professional services could investigate this issue, please provide me with your email address such that we discuss next steps.

Re: JDBC Connector to Cobol - URL path

rbecher — Tue, 05 Aug 2014 09:26:01 GMT

Dear Joseph,

this is my email address: ralf.becher@tiq-solutions.de

Regards,

Ralf

Re: Re: Re: JDBC Connector to Cobol - URL path

rbecher — Wed, 13 Aug 2014 15:17:10 GMT

To unnest OCCURS n TIMES columns you have to address them by index in the SELECT statement:

SELECT mycolumn(0) as mycolumn1, mycolumn(1) as mycolumn2, ... etc.

Re: JDBC Connector to Cobol - URL path

Thu, 14 Aug 2014 15:55:51 GMT

Many thanks for your help Ralf

Adding a select statement and explicitly listing the array fields solved it.

Re: JDBC Connector to Cobol - URL path

Thu, 14 Aug 2014 17:26:09 GMT

Hi Ralf, Im having troubles making a conecction to dat files, made it with PowerCobol, dosnt have idx file or cpy files.

how can I select all columns without know it?

Re: JDBC Connector to Cobol - URL path

rbecher — Thu, 14 Aug 2014 18:31:50 GMT

If you made the file I guess you have the data structure somewhere in the code and you can store it as cpy file?