Question

2
Replies
44
Views
VinothSadayappan Member since 2014 10 posts
Virtusa
Posted: November 16, 2017
Last activity: November 16, 2017
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
Share this page LinkedIn