Absent Member.. Nagavardhan Absent Member..
Absent Member..
1590 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

Labels (1)
Tags (1)
0 Likes
3 Replies
Trusted Contributor.. jarodb Trusted Contributor..
Trusted Contributor..

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
0 Likes
Absent Member.. AlexGg Absent Member..
Absent Member..

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.
0 Likes
Absent Member.. dingari Absent Member..
Absent Member..

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.