View previous topic :: View next topic
|
Author |
Message |
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
I am getting compilation error for ORDER BY clause in this Cursor.Please tell me why i am getting this error
EXEC SQL DECLARE IMAGE_TOUR_CSR2 CURSOR FOR
SELECT IMG_NME,
IMG_DTE,
IMG_FLAG
FROM IMG_TABLE
WHERE IMG_FLAG = 'S' OR 'R'
ORDER BY IMG_FLAG ,IMG_DTE
END-EXEC. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
What is the error code and its description? |
|
Back to top |
|
|
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
the compilation error and description for the above cursor problem is,
DB2 SQL PRECOMPILER MESSAGES
DSNH199I E DSNHPARS LINE 115 COL 20 INVALID KEYWORD "ORDER"; VALID SYMBOLS ARE: < > = <> <= !< !> != >= ¬< ¬> ¬= IN NOT . |
|
Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005 Posts: 165 Location: Bangalore
|
|
|
|
i think that the WHERE clause should be
WHERE IMG_FLAG = 'S' OR IMG_FLAG = 'R'
instead of WHERE IMG_FLAG = 'S' OR 'R' |
|
Back to top |
|
|
Suresh Ponnusamy
Active User
Joined: 22 Feb 2008 Posts: 107 Location: New York
|
|
|
|
Please try this
EXEC SQL DECLARE IMAGE_TOUR_CSR2 CURSOR FOR
SELECT IMG_NME,
IMG_DTE,
IMG_FLAG
FROM IMG_TABLE
WHERE IMG_FLAG = 'S'
OR IMG_FLAG = 'R'
ORDER BY IMG_FLAG ,IMG_DTE
END-EXEC.
(OR)
EXEC SQL DECLARE IMAGE_TOUR_CSR2 CURSOR FOR
SELECT IMG_NME,
IMG_DTE,
IMG_FLAG
FROM IMG_TABLE
WHERE IMG_FLAG IN ( 'S','R')
ORDER BY IMG_FLAG ,IMG_DTE
END-EXEC. |
|
Back to top |
|
|
babu_hi
New User
Joined: 11 Apr 2006 Posts: 93
|
|
|
|
Thanks Gautam....Now it is working fine with CNTL_FLAG = 'E' OR CNTL_FLAG = 'H' . |
|
Back to top |
|
|
|