Joined: 26 Nov 2002 Posts: 11813 Topics: 74 Location: San Jose
Posted: Tue Apr 05, 2016 10:51 am Post subject: Re: EBCDIC, UNICODE Conversion Problem, SQL -873
Select for this view works, no problem.
Update, Insert doesn't work.
Solution for Update, Insert: Instead of Trigger like this, but it is not possible to create this Trigger.
Any comments ?
How to provide the data of one table as EBCDIC data and UNICODE data ?
Functions EBCDIC_STR and UNICODE_STR instead of CAST doesn't work.
Remark: The Topic, that not all UNICODE chars (2 Byte) can be converted to EBCDIC (1 Byte) is of course well know, but not relevant for this question.
Thank you for all helpful comments.
Unless I am missing something why can't you do an INSERT on the base table itself instead of the View? View is merely snapshot of what you have in your base table. _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
Joined: 10 Oct 2003 Posts: 282 Topics: 40 Location: germany
Posted: Fri Apr 15, 2016 8:17 am Post subject:
Just for information:
The answer from IBM is, that this is not possible. With DB2 you cann't do this. No Views are possible which deal with different CCSIDs.
Possible of course is:
- One UNICODE Table
- Access to this table from any UNICODE environment
- Access to this table from any EBCDIC Environment, data is transferred to EBCDIC, with correct CCSID, handled by DB2 (specification of correct CCSID during BIND PACKAGE process in case of PL/1, COBOL Destination of course is necessary)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum