DB2 Global temporary table

Sample

 declare global temporary table SESSION.P1_HAVEBATCHIDS as
  (
   select ORGANISATION_CODE, RESULT, count(*) as TOT from
    (
     select
      ORGANISATION_CODE
      ,CASE WHEN coalesce(BATCH_RECEIVED_BATCH_ID, '') = '' then 'NO BATCHID' ELSE 'HAVE BATCHID' END AS RESULT
     from NPFP1.NPF_BATCH_RECEIVED
    ) t
   group by ORGANISATION_CODE, RESULT
  ) DEFINITION ONLY WITH REPLACE