85
with Tags:
ascii
X
X
All posts
ASCII to EBCDIC Conversion with DFSORT
( Scroll down if you're not interested in DB2 ) This past week I've been updating our SQL Analysis code to cope with Unicode SQL statements. (If you bind a package or plan once you've gone to DB2 Version 8 New Function Mode the statement text is stored in the Catalog in Unicode.) These statements are in Unicode UTF-8 which is extremely similar to ASCII. So I snaffled some existing code of mine... [More]
|
DFSORT - Now With Extra Magical Ingredients
Thanks to Scott Drummond for reminding me of last Autumn's DFSORT Function PTFs - UK90025 and UK90026. They're mentioned in the preview for z/OS Release 13 so now is not such a bad time to be talking about them. So let me pick out a few highlights: Translation Between ASCII And EBCDIC, And To And From Hex and Binary For a long time DFSORT has been able to translate to upper case (TRAN=LTOU), to... [More]
|
DB2 Accounting Trace And Unicode
As I said in this post I recently came across the need to handle Unicode when processing DB2 Accounting Trace (SMF 101). I was astonished not to have run into it before in all my many sets of customer data. So I had two things to do: Understand the circumstances under which it happens - which isn't just "be on Version 8 and it will happen automatically." and Figure out how to handle... [More]
|
