Re: SQL - Limit and Offset Not Working

Thanks to both of you guys. I sent reply on first one just as this rolled in :-)

Query results for both are below. Not sure if this means I have what I need or not though.

SELECT cast(left(PTF_GROUP_NAME, 7) as char(7)) as group, cast (left(PTF_GROUP_DESCRIPTION,15) as char(15)) as title, PTF_GROUP_LEVEL, PTF_GROUP_TARGET_RELEASE, PTF_GROUP_STATUS FROM qsys2.group_ptf_info where ptf_group_description = 'DB2 FOR IBM I'

GROUP TITLE PTF_GROUP_LEVEL PTF_GROUP_TARGET_REL PTF_GROUP_STAT
EASE
SF99145 PERFORMANCE TOO 9 V7R1M0 INSTALLED
SF99367 TCP/IP PTF 9 V7R1M0 INSTALLED
SF99368 IBM HTTP SERVER 36 V7R1M0 INSTALLED
SF99369 IBM I INTEGRATI 16 V7R1M0 INSTALLED
SF99380 WEBSPHERE APP S 14 V7R1M0 UNKNOWN
SF99381 WEBSPHERE APP S 13 V7R1M0 UNKNOWN
SF99572 JAVA 22 V7R1M0 INSTALLED
SF99617 DB2 WEB QUERY F 6 V7R1M0 INSTALLED
SF99627 7.1 ELECTRONIC 11 V7R1M0 INSTALLED
SF99637 DB2 WEB QUERY F 9 V7R1M0 INSTALLED
SF99705 HARDWARE AND RE 22 V7R1M0 INSTALLED
SF99706 HIGH AVAILABILI 8 V7R1M0 INSTALLED
SF99707 TECHNOLOGY REFR 11 V7R1M0 INSTALLED
SF99708 GROUP SECURITY 47 V7R1M0 INSTALLED
SF99709 GROUP HIPER 152 V7R1M0 INSTALLED
SF99710 CUMULATIVE PTF 15,142 V7R1M0 NOT INSTALLED
SF99711 ALL PTF GROUPS 3 V7R1M0 UNKNOWN

-----
SELECT * FROM SYSTOOLS.GROUP_PTF_CURRENCY
ORDER BY PTF_GROUP_LEVEL_AVAILABLE - PTF_GROUP_LEVEL_INSTALLED DESC

PTF_GROUP_CURRENCY PTF_GROUP_ID PTF_GROUP_TITLE

UPDATE AVAILABLE SF99709 710 Group Hiper
UPDATE AVAILABLE SF99708 710 Group Security
UPDATE AVAILABLE SF99368 710 IBM HTTP Server for i
UPDATE AVAILABLE SF99705 710 Hardware and Related PTFs
UPDATE AVAILABLE SF99572 710 Java
UPDATE AVAILABLE SF99706 710 High Availability for IBM i
INSTALLED LEVEL IS CURRENT SF99145 710 Performance Tools
INSTALLED LEVEL IS CURRENT SF99367 710 TCP/IP PTF
INSTALLED LEVEL IS CURRENT SF99369 710 IBM i integration with BladeCenter and System x
INSTALLED LEVEL IS CURRENT SF99617 710 DB2 Web Query for IBM i V1.1.1
INSTALLED LEVEL IS CURRENT SF99627 710 7.1 Electronic Services Group PTF
INSTALLED LEVEL IS CURRENT SF99637 710 DB2 Web Query for IBM i V1.1.2
INSTALLED LEVEL IS CURRENT SF99707 710 Technology Refresh

On 3/7/2016 12:06 PM, Rob Berendt wrote:

SELECT cast(left(PTF_GROUP_NAME, 7) as char(7)) as group,
cast (left(PTF_GROUP_DESCRIPTION,15) as char(15)) as title,
PTF_GROUP_LEVEL,
PTF_GROUP_TARGET_RELEASE, PTF_GROUP_STATUS
FROM qsys2.group_ptf_info
where ptf_group_description = 'DB2 FOR IBM I'

And you can compare this to what's available at IBM with:
SELECT * FROM SYSTOOLS.GROUP_PTF_CURRENCY


Rob Berendt