Question
PegaOne GmbH
DE
Last activity: 18 Dec 2017 5:53 EST
Obj-Browse on external table with char data type as key field, how to trim db field and compare?
Hi,
Doing Obj-Browse on external table as below
CREATE TABLE unitmaster (unitcode char(2) PRIMARY KEY, unitdesc varchar(50));
INSERT INTO unitmaster VALUES(1, 'unit 1');
INSERT INTO unitmaster VALUES(2, 'unit 2');
I have a logic defined on unitcode Is Equal to the Param.unitcode to match the record.
it is not retrieving the data, I tried to apply trim on .unitcode of external table as it is defined as char data type, but it is throwing
Proprietary information hidden(.unitcode) is undefined
Regards
Vinoth, S