char(176) function to column as value

[kum_d]

Hi ,

In one of existing datastage job ,for one coulmn say subfunction they have taken the value as char(176) which in the table holds the values of ascii characters after loading.

Plesae see the below query :

INSERT INTO T17020_TXN_CODE_DIM
( TXN_CODE_KEY, TXN_CODE, TXN_SUB_FUNCTION, TXN_CODE_FULL,
TXN_CODE_SDESC, TXN_CODE_LDESC, TXN_SUB_FUNCT_SDESC, TXN_SUB_FUNCT_LDESC,
TXN_SUB_INDEX, IMPORT_EXPORT_KEY, PLUS_MINUS_IND)
VALUES
(342, 'CSN', chr(176), CONCAT('CIR', chr(176)),
'CLRC RSCND', 'ACS CLRC RESCIND', 'CLRC RSCND', 'ACS CLRC RESCIND',
176, 1, 0
)


Here in the above query i am unable to understand what is the char(176) function

Can any one please tell me what is the usage of this char(176) function.

[DSguru2B]

It converts the decimal value to its ascii character. Search about CHR() in google to get more explanation.