Re: How do I use SQL Query operation? (390 Views)
Reply
Occasional Contributor
Nagavardhan
Posts: 4
Registered: ‎01-01-2012
Message 1 of 4 (421 Views)

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

Frequent Advisor
jarodb
Posts: 46
Registered: ‎06-17-2011
Message 2 of 4 (418 Views)

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
AlexGg
Posts: 86
Registered: ‎08-10-2006
Message 3 of 4 (406 Views)

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
dingari
Posts: 6
Registered: ‎05-12-2011
Message 4 of 4 (390 Views)

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

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.