SQL - Run SQL Scripts - wrong code page

By kimot, 27 December, 2022

If you are experiencing illegible output in Run SQL Scripts like this

select BKHSYS as LPAR, 
       BKHMC as Class
from QUSRBRM.QA1AHS                                                
where BKVOL = 'AS0047';

CCSID

A column with a different CCSID setting may be to blame. 
Then you can successfully use the case directive

select cast(BKHSYS as char(20) ccsid 37) as LPAR, 
       BKHMC as Class
from QUSRBRM.QA1AHS                                                
where BKVOL = 'AS0047';

CCSID II

Coded Character Set Identifier used on every field you can display using command 

DSPFFD FILE(QUSRBRM/QA1AHS)

Or you can try to setup correct Host Code Page in ACS Session Configuration

HCP

and restart Run SQL Scripts session


You can also check the JDBC Configuration (default) which Run SQL Scripts uses :

Translate