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.
char(176) function to column as value
Moderators: chulett, rschirm, roy