Character set which z/os Support
Posted: Tue Aug 02, 2016 10:59 pm
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:
1> SELECT CASE_NO, ADD_INFORMATION1_TX FROM TEST_RTRV_REQ_INQ where case_no='D0t7e' with ur
2> go
CASE_NO ADD_INFORMATION1_TX
---------------- -------------------------------
D0t7e H€îîÔ This is SË côrrëspôndénce
On mainframe:
ADD_INFORMATION1_TX
VC(6800)
----+---10----+---20----+---30--
**************************** TOP
H.îîÔ This is SË côrrëspôndénce
please advise.
Thanks,
Shakti.
Coded and split
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:
1> SELECT CASE_NO, ADD_INFORMATION1_TX FROM TEST_RTRV_REQ_INQ where case_no='D0t7e' with ur
2> go
CASE_NO ADD_INFORMATION1_TX
---------------- -------------------------------
D0t7e H€îîÔ This is SË côrrëspôndénce
On mainframe:
ADD_INFORMATION1_TX
VC(6800)
----+---10----+---20----+---30--
**************************** TOP
H.îîÔ This is SË côrrëspôndénce
please advise.
Thanks,
Shakti.
Coded and split