#DateForumTypeThreadPost
420 Nov 2015 @ 01:05 PSTGeneralReplyDifferent checksum HASH_MD5 in SQLA and BTEQI debugged it further and found the function does not behave the same with EXTENDED ASCII chars in the input
320 Nov 2015 @ 12:40 PSTGeneralTopicDifferent checksum HASH_MD5 in SQLA and BTEQ select hash_md5('     1.|     1.|  0.|33|22|520|      .00|      .00| 0.| 0.|S|¦|A| &...
212 Aug 2015 @ 06:10 PDTDatabaseReplyDecode non-displayed char non-spacesThanks dnoeth !! So '00'xc is a special DB2 value (or no value). Here is my actual problem with '00'xc value. This col XXX is part of large concatenated string that is passed to HA...
111 Aug 2015 @ 02:27 PDTDatabaseTopicDecode non-displayed char non-spacesHi There, We have a column say XXX as CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL Data from a source DB2 system has been loaded in this column., when i query it it just shows as spaces ...