IBM Mainframe Forum

If by SE you mean the line command in SDSF then use SET HEX ON to display the output in hex - and put the field boundaries (><) into your DISPLAY statement so that you can see the full extent of the value.

Hello,

I suspect this depends on local definitions. . .
Neither of those hex values shows anything "printable" on my system . . .

ß is not printable in Reflection either but ALT+225 (using the numeric keypad will display it in Word or Notepad or here. I'm looking at the Extended ASCII Chart.

the problem is the - while going the data in the cobol host variables to sql query ( insert/update) data is converting ( to EBCIDIC I think ). And in the same way while retrieving the data from sql query to host variables data is converting.

So for the above sql select query value Y is displayed ( in spool edit mode) as ß

DEC HEX EBCDIC ASCII
089 59 ß Y

I would like to know why the data is converting?

Seems problem is with CCSID's. Any idea what values need to be used to avoid conversion?

Only your support can tell that as it is country specific and may even depend on company if processing for clients in other countries.

In my precompile, CCSID(500) was used, but in bind I can see 'ENCODING UNICODE(01208)'. I overrided CCSID in bind with - ENCODING#500# now data is populating during & retrieving in select statements correctly.

Thanks

Can somebody please explain what ill happend if there is no plan and package?

Hai,
[deleted as not relevant to the topic and answers could be found using the search facility]

Please start a new topic instead of adding onto an unrelated one.