|
View previous topic :: View next topic
|
| Author |
Message |
balajipradeep
New User
Joined: 12 Mar 2009
Posts: 21
Location: chennai
|
|
|
|
hi
below are my code
| Code: |
SELECT CERT_NBR, PRDT_TYPE_CDE
FROM UCPROD.UBR_PARENT_CERT
WHERE (PRDT_TYPE_CDE='PDP ' AND CERT_NBR='N00368967') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00733613') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00733667') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00738510') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00742070') OR
(PRDT_TYPE_CDE='MA ' AND CERT_NBR='N00743284') OR
(PRDT_TYPE_CDE='MA ' AND CERT_NBR='N00745075') OR
(PRDT_TYPE_CDE='MA ' AND CERT_NBR='N00752625') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00753097') OR
(PRDT_TYPE_CDE='MA ' AND CERT_NBR='N00754770') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00760092') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00770990') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00777288') OR
(PRDT_TYPE_CDE='MAPD' AND CERT_NBR='N00782741')
|
am getting the following mess
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL " ". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: ( + - ? : NOT CASE CAST USER
EXISTS <FLOAT> CURRENT NEXTVAL
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 502 0 0 -1 116 0 SQL DIAGNOSTIC INFORMATION
How to fix this? |
|
| Back to top |
|
 |
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Don't see any syntax error. .Are you sure what you have posted is what you executed??? |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
Check the query by doing HEX ON for any non displayable(unwanted) characters..
I just simulated one.... I was able to get similar error... |
|
| Back to top |
|
|
Ajay Baghel
Active User
.jpg)
Joined: 25 Apr 2007
Posts: 206
Location: Bangalore
|
|
|
|
Looks like you are missing semicolon (;) at the end of the query.
Try with it. |
|
| Back to top |
|
|
|
|
