SQL code -104 in REXx

5 pts.
Tags:
REXX
This is my query. im passing a char value as input. but query returns -104. how to execute this

SELECT * FROM  Table WHERE Field='data'

Answer Wiki

Thanks. We'll let you know when a new response is added.

The SQLCODE is being returned by the RDBMS to your REXX EXEC. You might tell us what OS and what RDBMS you are using.

in DB2 for z/OS the SQLCODE -104 means an ILLEGAL SYMBOL – using DSNTIAR (or looking at the SQLCA) you can get the value that DB2 thinks is illegal.

You are a passing a char value… I assume this is used in the where clause. How are you passing it? As a parm? You might check the query AFTER you “pass a char value” to see exactly what the query looks like just before execution. things like the quote marks can throw one way off.

If you are using a different RDBMS or a different OS, please disregard my comments.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following