Question

1
Replies
347
Views
vikat Member since 2015 4 posts
PEGA
Posted: 2 years ago
Last activity: 2 years 3 months ago
Closed

Stored Procedure parameters (blank property)

Scenario:

We have an integration page where data is set from the work page. Connect SQL, calling SP, picks up parameter values from this page.

Problem Statement:

When there are no values to the properties, they do not show up on the integration page. Thereby parameters are not passed to the SP.

Where as, Downstream system is expecting blank values to be passed in the parameters.

@PropertyhasValue() and @PropertyExists() both returns false.

Data Integration
Moderation Team has archived post
Share this page LinkedIn