MVSFORUMS.com

oops... our shop uses SYNCSORT.... that must be the issue here?

SYNCSORT FOR Z/OS 1.4.0.1N U.S. PATENTS: 4210961, 5117495 (C)
100312: SYNCSORT ...

Thanks, Kolusu-

The 2222222222 1D record was dropped as expected, but the
4444444444 1A record was also dropped... I only wanted to drop
records if there was a single 1D record.... Thanks.

Hi, I have a situation where I need to drop 'unpaired' records based on a 'status' field...

Here is my input:

Key Field Status
1111111111 1D
1111111111 1A
2222222222 1D <- drop re ...

perfect .... thanks very much Kolusu...

now we don't have to add an additional step to the job and change the existing one.

We ran into a production problem with
this. Apparently the 'LAST USING(CTL1)' first retained only the last record (with the 'A'), then dropped the record because of the 'INCLUDE=(7,1,CH,NE,C'A')'.
S ...

Hi, I'd like to recall all migrated datasets whose names meet a specified high level qualifer(s), via a batch job .... For example:

NODE1.NODE2.*
NODE1.NODE2.NODE3.*

Is there a way to do this ...

Thank you very much, Kolusu ...

Thanks, Kolusu...

Pardon my ignorance, as I should be able to figure this out, but
what if the field to be added to is 5 bytes instead of 1 ?

//SORTIN DD *
XXX 00889 TOM
AAA 01099 ...

Hi, I'd like to add 1 to a numeric field in a file.
From the example below, obviously column 5 I'd like to convert
to 1, 2, 3, 4.

How can I do this with SORT ?

//SORTIN DD *
...

Along the lines of retaining previous values, would it be possible to reformat a report into detail lines that contain a date value appended to the front of the detail line? Here is my example:

I ...

Is there a way to get a list of cataloged datasets without knowing the ENTIRE high level qualifier ?

For example, I could have datasets that start with:

H2501T
H2501S
H2501AR
H2501TS
etc. ...

Looks like I have found one way to do it:

SELECT CASE(STATE_CODE)
WHEN '01' THEN 'AL'
WHEN '02' THEN 'AZ'
WHEN '03' T ...

In QMF, is there a way to immediately convert a numeric value to an alpha value for display purposes ?

In other words, say I have a column called STATE_CODE that contains values 01 thru 49. When I ...

I got the following error using the second query :

SELECT POL_NUM, POL_SUFFIX ...

I only have version 8. Any chance of getting this functionality in V8 ?