Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grouping (ish) assistance
i think that pivot and crosstab are a non starter on DB2 z/os .... but I will keep looking. Les -
Grouping (ish) assistance
no bp_id can be anything up to 80 different numbers. will look at the crosstab and pivot table .. again thanks for help Les -
Grouping (ish) assistance
This is on DB2 z/os, and yes I can achieve this with QMF, but I would rather not ... I am pleased that you have confirmed my thoughts that it is not possible in raw SQL. If anybody else has some thoughts on this then please do reply. many thanks for all your help. -
Grouping (ish) assistance
Hi All, I know I have not posted before but I do find this site very good for SQL information, however, I am struggling with generating my required output from a table. Let me explain. I have a table defined as (this is simplified) and with data in as below Interval_timestamp bp-id countX...
