Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a built-in Ebcidic converter in QV? My data source is in Ebcidic, and is relatively un-readable in QV. If there's not a built-in function, is there a simple script that can convert during a load? My load will range around 1-2 million records, so anything too logic-heavy will considerably increase my load time.
Thanks,
Aaron
Hi Aaron,
How are you accessing the information? via IBM Driver and directly to Qlik or are you sending it to a RDBMS before qlikview?
In the ibm odbc you can indicate (i believe it was in navigator), to convert the codepage 65535.
Regards
Hi Aaron,
How are you accessing the information? via IBM Driver and directly to Qlik or are you sending it to a RDBMS before qlikview?
In the ibm odbc you can indicate (i believe it was in navigator), to convert the codepage 65535.
Regards
Found it. Thank you.
For some reason, I'm unable to configure the ODBC connection through QlikView, but it has to be done though another application (the first time I used Excel). I couldn't figure out how to get back into the set-up to check that conversion option, so I had to get at it through the IBM System i ODBC Data Source Administrator (which I've never done before).
This has been a great crash-course in database connections.
Thanks for pointing me in the right direction.