Question

2
Replies
45
Views
Vinoth Sadayappan (VinothSadayappan)
PegaOne GmbH
Senior System Architect
PegaOne GmbH
DE
VinothSadayappan Member since 2014 10 posts
PegaOne GmbH
Posted: November 16, 2017
Last activity: November 16, 2017
Posted: 16 Nov 2017 6:01 EST
Last activity: 16 Nov 2017 8:37 EST
Closed

Obj-Browse on external table with char data type as key field.

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

Data-unitmaster@String.trim(.unitcode) is undefined

Regards

Vinoth, S

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.