MVSFORUMS.com

[Kathy]

Hello,
When I executed the below UPDATE query
UPDATE ABCD.TABLE
SET NAME = 'KAT'
WHERE NAME = 'ABC'
AND SEX = 'F'
AND (AGE > '01.10.1774')
AND OCUNTRY IN ('IND') ;

I am endedup with the below message
-----------------------------------------------------------------------DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "-". SOME SYMBOLS THAT MIGHT BE
LEGAL ARE: ( END SET CALL DROP FREE HOLD LOCK OPEN PARM ALTER BEGIN
CLOSE
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 1660 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'0000067C' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------------------------------------------------------------------------------------------
Any idea.
Thnx
Kathy

[kolusu]

Kathy,

I don't see '-' symbol anywhere in your query. I suspect that you have some garbage value after column 72. Clear those characters and rerun your query

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Kathy]

Hello Kolusu,
I am sure that there no such '-' char after 72 clmn and even before that.
If I try to execte some other query in the same place its working fine

Any idea.

Thnx
Kathy

[vini]

Kathy , If you are sure of that , are you also sure that you have Pasted the UPDATE QUERY just as it was when you Executed it ??? If not , paste the EXACT query here. There is no doubt that the presence of a hypen (-) somewhere is cause of the problem.

[Ganti]

Kathy,

There is a OCUNTRY, I am not sure if that is correct.
Also, I think your WHERE condition needs some parantheses.

Could you try this -

UPDATE ABCD.TABLE
SET NAME = 'KAT'
WHERE
(NAME = 'ABC'
AND go-away-spammer-sucker = 'F'
AND (AGE > '01.10.1774')
AND COUNTRY IN ('IND')) ;
_________________
Ganti