Re: [Bulk] Re: SQL - Limit and Offset Not Working

[Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>]

Brian:

I do not see SF99701 "DB2 for IBM i"     listed ...

Mark S, Waterbury

> On 3/7/2016 12:12 PM, Brian wrote:
> 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