SQL prepare error

Question

Question

Mike Minor · Feb 9, 2018

I'm trying to learn how To use SQL in CACHE, so I hope I don't bore you with "Dumb" questions....

I'm getting "ERROR #6022: Gateway failed" message following this line of code.

s sc=gc.Prepare(hstmt,pQuery)

This line of code comes from an example I found in the documentation. pQuery is the "Select" statement setting up the variables and tables I'm trying to pull information from.

What does that error indicate?

Thank you.

Discussion (5)0

Log in or sign up to continue

Stephen Wilson · Feb 12, 2018

For reference, you can get a list of error codes from General Error Codes and SQL Error Codes . From the error description, it seems to be complaining about the 1st parameter.

If the 'gc' object is a %SQL.Statement then the %Prepare method only takes one parameter. What happens when you pass in pQuery to the %Prepare method?

Have you tried executing the SQL in the SQL Shell or System Management Portal?

do $System.SQL.Shell()

0 0

Kyle Baxter · Feb 14, 2018

I'd bet my breakfast that your first line of code connects to a remote database, and that is failing. Therefore, when you go to prepare your query, it is failing due to no connection. Check the status code from your Connect() call and let us know what that says.

0 0

score 0 · Answer 1 · 2018-02-09T07:45:44-05:00

Vivek Ranjan · Feb 9, 2018

What's hstmt? You can call like this. SET sc= gc.%Prepare(pQuery)

0 0

score 0 · Answer 2 · 2018-02-09T08:45:33-05:00

Robert Cemper · Feb 9, 2018

changed group from "Community Feedback" to "Caché"

0 0

score 0 · Answer 3 · 2018-02-10T19:06:20-05:00

That looks like you are trying to connect using a %SQLGatewayConnection. Can you post the preceeding lines of code?

If so, make sure the DSN exists and can connect. The statement is correct for the desired database and the odbc drivers are correct for your system.