Translations - OPALE - 10.0 - Utilisation - Tri et regroupement de spools - MAPSORTPAG/31/en
Différence entre versions
De MappingDoc
(Page créée avec « When you wish to link an EBCDIC table and one in UTF-8, clause where TABLE_EBCDIC.CHAMP1 = TABLE_UTF8.CHAMP1 does not work anymore. It doesn't because data isn't containe... ») |
|||
Ligne 1 : | Ligne 1 : | ||
− | When you wish to link an EBCDIC table and one in UTF-8, clause where TABLE_EBCDIC.CHAMP1 = TABLE_UTF8.CHAMP1 does not work anymore. | + | When you wish to link an EBCDIC table and one in UTF-8, the clause where TABLE_EBCDIC.CHAMP1 = TABLE_UTF8.CHAMP1 does not work anymore. |
It doesn't because data isn't contained in the same encoding. Apply a cast on field: | It doesn't because data isn't contained in the same encoding. Apply a cast on field: | ||
Read(TABLE_UTF8,"Select … From … Where cast(BIB.TABLE_UTF8.CRITERE0 as char(8) ccsid 37) = $TABLE_EBCDIC.CRITERE ") { } | Read(TABLE_UTF8,"Select … From … Where cast(BIB.TABLE_UTF8.CRITERE0 as char(8) ccsid 37) = $TABLE_EBCDIC.CRITERE ") { } |
Version actuelle datée du 9 octobre 2019 à 09:06
When you wish to link an EBCDIC table and one in UTF-8, the clause where TABLE_EBCDIC.CHAMP1 = TABLE_UTF8.CHAMP1 does not work anymore. It doesn't because data isn't contained in the same encoding. Apply a cast on field: Read(TABLE_UTF8,"Select … From … Where cast(BIB.TABLE_UTF8.CRITERE0 as char(8) ccsid 37) = $TABLE_EBCDIC.CRITERE ") { }