I am trying to select 3 rows of each group from a table. Please see below what I've tried.
Code: Select all
---------+---------+---------+---------+---------+---------+---------+---------+
SELECT POLISNR, VOLGNR_VORD 00010003
FROM 00011003
( SELECT POLISNR, VOLGNR_VORD, 00012003
RANK() OVER(PARTITION BY POLISNR 00013005
ORDER BY VOLGNR_VORD) AS NUM 00014004
FROM YSS1S1C1.T2941_VORD 00014103
) AS X 00015005
WHERE X.NUM <=3 00016005
Code: Select all
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW FUNCTION BEFORE NEW
FUNCTION MODE
DSNT418I SQLSTATE = 56038 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHSMF2 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 58 0 0 -1 235 507 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'0000003A' X'00000000' X'00000000' X'FFFFFFFF'
X'000000EB' X'000001FB' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+---------+
Some one please help me out in resolving the problem. Or any other alternative query to do the need.
We are running on DB2 V10
Code: Select all
DSN7100I -D01T DSN7GCMD
*** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(101) MODE(CM8 )
PROTOCOL LEVEL(2) GROUP ATTACH NAME(....)
--------------------------------------------------------------------
DB2 DB2 SYSTEM IRLM
MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC
-------- --- ---- -------- -------- --- -------- ---- --------
........ 0 D01T -D01T ACTIVE 101 TST1 I01T D01TIRLM
--------------------------------------------------------------------
SPT01 INLINE LENGTH: 32138
*** END DISPLAY OF GROUP(........)
DSN9022I -D01T DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION
***
Bunch of thanks in advance.