jdbc to rfc

[Former Member]

Hi experts

in sender jdbc we r fetching data from one single row , in that row one column contains values and null values ,this null value should not post to the target and in target we r having 11 rows and one header (jdbc to RFC) same condition should be applied for all the rows. any logic help me urgent?

[Former Member]

Hi,

if you want to check null value do this,

SourceElement --> SplitByValue(EachValue) --> CollapseContext --> SplitByValue(EachValue) --> TargetElement.

Combination of SplitByValue and Collapse context automatically detect null and suppressed values. and consider it as blank value and create a node for it.

try this .

Regards,

Rohit.

Reward points if helpful

[sunil_singh13]

Hi Giri ,

You can implement the same using CollapsContext ,

Basically what it does is it will give "" (Blank) if the incoming value is null and you can check if input value is "" then implement logic for null and if it is not equal to "" then you can send that value you wish to .

Reward Points if Helpful .

Thanks

Sunil Singh

[Former Member]

Hi Giri,

You can check for the null values by writing UDF. So, you can send data to target interface only when it is not null.

Exactly same requirement:

[|]

Regards

Bhanu

Intelligroup.

Edited by: Bhanu Tiruveedula on May 5, 2008 3:43 PM