Question

3
Replies
605
Views
ReetiK84 Member since 2016 4 posts
Infosys
Posted: 2 years ago
Last activity: 2 years 8 months ago
Closed

how to access scalar value returned from a sql query

Hi,

I have used sql connector to write a query and I need scalar values to be returned so that I can use them in a switch case to put my logic.

As there is one method get table to access the data which is returned in table format from a query but if we want to access the scalar value , do we need to mention in sql properties return type as scalar and just execute the query and I will be able to use output parameter? or is there any other method to access that?

I cannot test database connection now so not able to see that.

Thanks,

Reeti

System Administration
Moderation Team has archived post
Share this page LinkedIn