sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
This is a testing Query, if this works i got to make a bigger query. This is not working itself. I think its correct.
This table contains only this 3 columns
Code: |
SELECT * FROM
(SELECT ID,"NAME",DEPTNO
FROM SHANDB.EMPLOYEE
ORDER BY ID DESC
FETCH FIRST 3 ROWS ONLY) AS RESULTES |
Errors :
I checked for the syntax errors in ISQL
Code: |
SQL009: Invalid TOKEN detected while processing a
SELECT statement.
Expecting one of UNION ORDER FOR OPTIMIZE |
Sometimes the query works after this also, so i executed it
When executed this is the error i got
Code: |
DSNT408I SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD ORDER. TOKEN
UNION EXCEPT WAS EXPECTED
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 506 0 0 -1 66 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000001FA' X'00000000' X'00000000'
X'FFFFFFFF' X'00000042' X'00000000' SQL DIAGNOSTIC
INFORMATION
BPA0012E: DB2 SQL/DDL ERROR HAS OCCURRED - ROLLBACK ISSUED.
RETCODE = 8 |
Please HELP me |
|