MVSFORUMS.com

Rama_Prayaga · Beginner Joined: 20 May 2003 Posts: 45 Topics: 15

Hi,

My program has Dynamic SQLs.

I am receiving SQL code -518 sometimes,

The reason while passing the string contains quotes, in between them.

like
MC Donald's resturant

As the data will be always dynamic....How should I Handle such cases.

Regards,
Rama Krishna Prayaga.

schintala · Posted: Wed Jul 20, 2005 12:18 pm Post subject:

I see below info from sql 518. Do you have any of these.

-518 THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT

Explanation: One of the following conditions exists:

o The statement named in the EXECUTE statement has not been prepared.

o The statement named in the EXECUTE statement identifies a SELECT,
VALUE INTO, or statement.

o The statement named in the EXECUTE IMMEDIATE statement identifies a
SELECT, VALUE INTO, or statement.

Programmer Response: Ensure that you prepare the statement prior to
EXECUTE. Also, ensure that the statement you prepare is not a SELECT or
VALUES INTO statement.

Rama_Prayaga · Beginner Joined: 20 May 2003 Posts: 45 Topics: 15

Hi schintala,

Yes My EXECUTE STATEMENT is not PREPARED because of the the strings which have quotes( ' ) (EXample:
MC Donald's resturant ) in them.How should I handle such situations is my problem now.

Regards,
Rama Krishna Prayaga

Dummy · Beginner Joined: 03 Jan 2003 Posts: 8 Topics: 1

Can you try using two continous single quotes instead of one? This works (considered as one quote) in few places.

Are you using a place holder or Iteral value?