IBM Mainframe Forum

Hi All,

Can you please help me on how to display the Euro symbol in the mainframe flat file?

There is a column in the db2 table which can store the value with the Euro sign. When I query the column using IBM Data studio it is able to display the Euro sign, where as when I query the column in File-Aid I can only see a blank.
also when I unload the data from the table iinto a flat file it is filled with a blank field.

IBM datastudio:


On mainframe:


please advise.

Thanks,
Shakti.

Coded and split

My advice, Shakti-chan, is:

1. Do not append your request to a five-year-old thread; start a new one.
2. Do include code, data, and anything for which alignment may be significant in Code tags.
3. Determine what code pages contain the € glyph and how to use them.

These users thanked the author Akatsukami for the post:

Shakti Hazaru (Wed Aug 03, 2016 12:59 am)

X'9E' is usually the EBCDIC bits for the Euro glyph.

Hi Steve,

Thanks for the response, I have manually edited the flat file in hex format with X'9E' now I can see the below in the file.

HÆîîÔ This is SË correspondence.

While unloading the data from a table to the file, is there anything that we need to take care to write the Euro glyph properly in the flat file?
instead we manually edit the file?
Please advise.

Thanks,
Shakti.

Shakti Hazaru wrote:While unloading the data from a table to the file, is there anything that we need to take care to write the Euro glyph properly in the flat file?
instead we manually edit the file?
Please advise.

By "table," I presume you mean a DB2 table that contains rows with the Euro glyph in them. Sadly, I am no DB2 expert, but I think the unload process will just copy the Euro glyph. The only way is to unload the table and find out.

When you edit the data you might see something like this when you use the ISPF hex option.
I am using Verson 4.8.3 of the QWS3270 PLUS terminal emulator which actually attempts to display something that sort of resembles the Euro glyph. What other emulators do, or (more usually) don't do, I can't say.

A code page is the assigned meanings for the 256 (in EBCDIC -- this can be more or less depending upon what you're referring to) bit patterns that make up the collating sequence. EBCDIC uses two primary code pages, 1047 and 037. 037 has teh Euro symbol while 1047 does not. Hence you need to ensure that File Aid and the process writing your data into a data set (it is NOT a "flat file" -- files on z/OS only exist on tape and within Unix System Services) are using 037; I suspect you're getting the blanks because they are using 1047.