Question

3
Replies
748
Views
Reeti Kalra (ReetiK84)
Infosys
Technology Analyst
Infosys
IN
ReetiK84 Member since 2016 5 posts
Infosys
Posted: February 20, 2018
Last activity: February 21, 2018
Posted: 20 Feb 2018 18:30 EST
Last activity: 21 Feb 2018 7:35 EST
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.