The mainframe use EBCDIC and the field in teradata table is UNICODE. We load Chinese Character from mainframe to teradata table by using mload, but data is garbled.
Can you provide any sample to load Chinese Character in Mainframe(Zos) by using mload successfully ?
You can try using UTF8 session charset to load your data on mainframe. The way to evoke UTF8 on mainframe is:
//MLOAD EXEC PGM=MLOAD,
//SYSDUMP DD SYSOUT=*
Thank you for your reply.
After I add // PARM='CHARSET=UTF8' in job, there is an error message CLI0543 when it creates logtable. How to fix it?
Here is the explanation of mainframe CLI0543:
CLI0543 External security reported a security violation
Explanation: The logon request was rejected by the TDP SECLOGON feature.
Notes: This error is generated by TDP, reflecting either a rejection by an external security capability, or an error occurred
preparing the request for external security.
Remedy: Check the TDP job log for additional information ensure that the MSGS option of the SECLOGON command is
enabled. If an authorization failure occurred, ask your security administrator to review the access rules for the resource
which corresponds to the user- name you were attempting to logon with.
Possible Reason/Solution - Chinese data cannot be represented in usual EBCDIC. you would require the input to be Unicode either UTF-8 or UTF-16 to successfully have the data in chinese in the Tables. You will also require to define the charset as UTF-8 (if you are providing UTF-8 File).
Moreoever you will have to see what Version of Teradata you are running because the one we use does not accepts UTF-16 directly for Channel attached system(Mainframes). Only UTF-8 is acceptable.