Re: version of db2

On Mar 16, 2016, at 11:06 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

Find the release of OS you are running by running the following:
DSPPTF
Record what you see in "Release of base option" _____________
F3


Find out what DB2 Group PTF you are running by
WRKPTFGRP PTFGRPLVL(*LATEST)
F11=Display descriptions
Find DB2 FOR IBM I
5=Display
Record what you see for "Level" ___________

Go to
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i/welcome
Select the version of the Operating system (IBM i 7.2 for example)
Expand Database
Expand Reference
Expand SQL Reference
Most popular areas are "Statements" and "Built-in Functions / Scalar
Functions"

This is how you'll know what you can use.

Some statements and functions are dependent upon the level of the DB2
group ptf you are running. For example: What's new for IBM i 7.2.
Broken down by dates of certain group PTF's like
What's new as of October 2015


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/16/2016 10:54 AM
Subject: version of db2
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Is this IBM i running db2? if so which version. we are working in Sql and
want to know which command are supported.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.