DB2 Byte 문자열 자르기(한글)

select SUBSTR(REPLACE('년간1회금액입력,견적서금액상이,2회금액시2순위업체',' ',''),1,10)||'...'
     , SUBSTRING('년간1회금액입력,견적서금액상이,2회금액시2순위업체',1,10,CODEUNITS32)||'...'
     , SUBSTRING('년간1회금액입력,견적서금액상이,2회금액시2순위업체',1,10,CODEUNITS16)||'...'
     , SUBSTRING('년간1회금액입력,견적서금액상이,2회금액시2순위업체',1,10,OCTETS)||'...'
     , SUBSTRING('년간1회금액입력,견적서금액상이,2회금액시2순위업체',1,2,OCTETS)
  from SYSIBM.SYSDUMMY1;

 

Options to specify unit of measurement:

CODEUNITS16

Specifies that DB2 is to count the length by 16-bit (or 2-byte) code units. For every character that is 2 bytes or less in the string, DB2 counts a length of 1.

CODEUNITS32

Specifies that DB2 is to count the length by 32-bit (or 4-byte) code units. For every character that is 4 bytes or less in the string, DB2 counts a length of 1. CODEUNITS32 always returns the same value as CODEUNITS16 unless you have supplementary characters.

OCTETS

Specifies that DB2 is to count the length by bytes. For every byte in the string, DB2 counts a length of 1.

The OCTETS option is not available for all of the listed functions.

 

참고 URL

http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.char%2Fsrc%2Ftpc%2Fdb2z_specifylengthcalcutation.htm