MVSFORUMS.com

Hallo Kolusu,

thank you for your answer.

Yes, you are right - program invocation by IKJIFT01 with ISPSTART PGM ....., PROGRAM (....) PLAN (....) does noz work with any simple search.

Thus: W ...

Hallo *,

I like to parse PO datasets containing JCL and like to retrieve lists with found datasets, programs etc. which are involved in the JCL.

Background: JCL should be deleted, including depe ...

Dear all,

does anybody have some PL/1 or Cobol sample how to call this RACF interface?

Background: I would like to do some evaluation from an CICS based Webservice transaction.

Thus the sol ...

Hi *,

this PL/1 code snippet creates a new dataset, DSORG = PS, LRECL=80 in the zOS file system, writes one line and close the dataset. After execution the dataset is cataloged.

Details for all ...

Hallo,

I'm responding to my own post from 2007 (!!).

I used the last days my own coding to allocate a new PS file (never done the last years, always PO files). This PS file allocation with DISP= ...

Spolacek,

your links, remarks according "detach partition" seems to be for DB2 LUW, right?

This does not work for DB2 zOS, my impression.

For deleting all records in one partition ...

kolusu,

sorry for my late feedback.

First of all thank you for your time.

Yes, this obviously works. My solutuion with the additional table and the left outer join might be easier to under ...

Hi kolusu,

my impression is: This does not work.

See the discussed sample above: YNYNN << "B" has 1 and 3

How is this generated?

The provided SQL pads from the left so ...

kolusu,

yes, you are right about the expected result. Your idea with the SUM operator is great, looks pretty good.

But: In my sample I used 5 digits, 5 possible values. The real SQL should han ...

Hallo *,

this documentation

https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-listagg

says, that LISTAGG function works with required function level FL 501.

bauer

Hallo kolusu,

thank you for asking again.

The allocation of the tables should be clear.

Table MySchema.SUPPORT contains all valid numbers from 1 up to MAX_allowed_value. In the sample 5. The ...

Hi Kolusu,

thank you for your answer - but this is not 100% the situation, see my sample.

There might be expected results like 'YNYNN' (or more digits like 'NNNNNNNY......) Sad

.

This means: ...

Ok, using a support table which contains all numbers from MINVALUE up to MAXVALUE this solution works.

CREATE TABLE MYSCHEMA.ORIGINAL
(F1 SMALLINT, F2 CHAR(1));

CREAT ...

Hi,

I have a table something like this:

Field1 Field2
------------------
A 1
B 1
B 3
C 3

Field2 is limited from 1 (minvalue) to lets say 5 (max ...

Well, I try to reduce the size of memory (ZIP) before for example sending the data .....,
thank you for asking.

But we have implemented a other solution now for the complete problem.