Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in connection JDBC-COBOL --- QVX_UNEXPECTED_END_OF_DATA

Hello, please I need someone who knows about this give me a hand.

I spent several days trying to connect from the QlikView with some Cobol extension files. DAT, SEL, FD, VIX.

After much work and research and I have been able to connect using JDBC and
HXTT Cobol JDBC driver.

But I did not return any data, and I get the error QVX_UNEXPECTED_END_OF_DATA

My connection is:

CUSTOM CONNECT TO "Provider = JDBCConnector.dll; jdbc: cobol 😕 / / C 😕 cfactura.dat; XUserId = fEDDLOD; XPassword = DQLERBB;"

Therefore selected the data as follows:

test:
SQL SELECT * FROM cfactura;/ /


At compile I get the following error:

"Customer reading error

test:

SQL SELECT * FROM cfactura.



And then I get the following window where I recognized the names of the fields and the structure but no data


I thank you very much any help on this topic.

RE

15 Replies
Not applicable
Author

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

rbecher
MVP
MVP

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

Astrato.io Head of R&D
Not applicable
Author

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.

rbecher
MVP
MVP

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

Astrato.io Head of R&D
rbecher
MVP
MVP

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

Astrato.io Head of R&D
Not applicable
Author

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.