Operations Orchestration Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

How do I use SQL Query operation?

Highlighted
Occasional Contributor

How do I use SQL Query operation?

Hello everyone,

 

Can anyone let me know how do I use SQL Query Operation? Can I paste the Query directly in the (query) input parameter of HPOO( the same query I run in MS SQL Server)?

 

When I place the same query directly in the "Query" input parameter, I get syntax error. But when ran in MS SQL Server I have no errors.

 

Regards,

nagavardhan

3 REPLIES
Frequent Advisor

Re: How do I use SQL Query operation?

Is the query that you're executing a SELECT statement?

 

If you're doing anything else you need to use a SQL Command.

 

If you're still having issues a little more detail would be helpful -- the query and any logged error messages

//Actively seeking HPOO opportunities
Regular Advisor

Re: How do I use SQL Query operation?

what kind of syntax error you got? It might point to some line or so. Please specify.
Occasional Contributor

Re: How do I use SQL Query operation?

It is possible to post how you mapped your input variable to the Operation and what kind of error you are getting
Murali Mohan Dingari | HP Software
| M • 425 429 4056
mdingari@hp.com • hp.com/software