Question

2
Replies
224
Views
VinothSadayappan Member since 2014 10 posts
Virtusa
Posted: 2 years ago
Last activity: 2 years 10 months ago
Closed
Solved

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

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

Regards

Vinoth, S

Data Integration
Moderation Team has archived post
Share this page LinkedIn