Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
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
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
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.