Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-08-26 02:34 AM

How to convert EBCDIC character set data using qlik view sql load

Hi,

can anyone help me with the logic that need to be used to convert the EBCDIC character set data to normal characters (readable format) using sql load option.

I tried using mapping function to convert EBCDIC data with qlik load file option but not able to use the same mapping function for sql load.

Thanks,

Narasimha

675 Views
0 Likes
1 Reply
petter
Partner - Champion III
Partner - Champion III
‎2018-08-26 12:26 PM

I don't recommend doing your own conversion character by character - even with a map.

First of all - all ODBC / OLEDB drivers on Windows that support your SQL database can do the conversion for you. EBCDIC is an extended familiy of character sets - not just one. Just like the ASCII/ANSI is ...

So be sure to identify which EBCDIC code page your database is set to. Then go into the ODBC-driver and find the conversion options there to specify the source EBCDIC code page and then you should get a Windows readable character set.

626 Views