Qlik Community

QlikView Connectors

Not applicable

Re: Error in connection JDBC-COBOL --- QVX_UNEXPECTED_END_OF_DATA

I correct the brackets I get error

Hi Ralf

I have attached the original files that I sent the customer, are 3 files, a

indice.dat, secuenci.dat and secuenci.vix.

Apparently secuencia.vix and index.dat are complements

I translated what the client told me about this topic:

"Attached is a text file but has included the index. It's called INDEXES.

This file type corresponds to a version lower than we currently have.

In our Unix server platform handle ACUCOBOL GT 4.2.0 file types mentioned

above and flat files where the table index is separate and has a. Vix. As I

was saying is the native form of a Fox database that handles the base as .

Dba and the index table as . Idx. An example of this is the file that

secuenci.vix secuenci and attachment."

thanks

--

Saludos cordiales

Ricardo Escobar Duque

*Qlikview Consultant Specialist *

QlikView - Authorized reseller

tfno. (593-2) 227 1333

cel. (593) 09 90 48 997

e-mail: rescobar@cliksoft.com.ec <hpelaez@cliksoft.com.ec>

www.cliksoft.com.ec

MVP
MVP

Re: Error in connection JDBC-COBOL --- QVX_UNEXPECTED_END_OF_DATA

The file secuenci.vix doesn't belong to cfactura.dat .

Please check whether there's a vutil (vutil32.exe for Windows) on AcuCobol installationdirectory, which can rebuild vix for it.

- Ralf

Not applicable

Re: Error in connection JDBC-COBOL --- QVX_UNEXPECTED_END_OF_DATA

Hi Ralf

I talked to my client and we think a solution, which includes transforming

the data into flat files that can read QlikView, using vutil32.

My client has an aging infrastructure and old that needs to be modernized,

we expect this project of QlikView will be a start to helps changes this

infrastructure.

Thank you very much all your support on this issue.

Best regards.

MVP
MVP

Re: Error in connection JDBC-COBOL --- QVX_UNEXPECTED_END_OF_DATA

Hi Ricardo,

however, can you create a .vix file for cfactura.dat that I can finish this test case? I'm still working out a solution for this with HXTT. Could be helpful for other clients also.

Best regards,

Ralf

MVP
MVP

Re: Error in connection JDBC-COBOL --- QVX_UNEXPECTED_END_OF_DATA

Ricardo,

the problem is fixed now after HXTT sent a new version. You can download the example here: http://bit.ly/JaT1zp

Although there are still some corrupted or incorrect numericals in the file which are skipped with the parameterignoreDirtyData=true.

I hope this helps!

- Ralf

Highlighted
Not applicable

Re: Error in connection JDBC-COBOL --- QVX_UNEXPECTED_END_OF_DATA

Hi Ralf

Thanks for the information!

I downloaded the new version of HXTT, modify the URL of the connection

including :

ignoreDirtyData=true & connector.ignoreFetchErrors=true

The URL Connection :

CUSTOM CONNECT TO

"Provider=JDBCConnector.dll;jdbc:cobol:///C:/cfactura.dat?ignoreDirtyData=true&connector.ignoreFetchErrors=true;XUserId=XKfTSeB;XPassword=ALadULC;";

It works!, Get information cfactura.dat.

thank you very much Ralf.

RE.

Community Browser