Author |
Message |
Topic: Drop 'unpaired' key records based on value in another field. |
tcurrier
Replies: 5
Views: 3482
|
Forum: Utilities Posted: Fri Jan 31, 2014 4:21 pm Subject: Drop 'unpaired' key records based on value in another field. |
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 ... |
Topic: Drop 'unpaired' key records based on value in another field. |
tcurrier
Replies: 5
Views: 3482
|
Forum: Utilities Posted: Fri Jan 31, 2014 1:46 pm Subject: Drop 'unpaired' key records based on value in another field. |
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. |
Topic: Drop 'unpaired' key records based on value in another field. |
tcurrier
Replies: 5
Views: 3482
|
Forum: Utilities Posted: Fri Jan 31, 2014 10:11 am Subject: Drop 'unpaired' key records based on value in another field. |
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 ... |
Topic: ICETOOL - drop records and keep last duplicate key record |
tcurrier
Replies: 2
Views: 5646
|
Forum: Utilities Posted: Fri Jun 15, 2012 4:32 pm Subject: ICETOOL - drop records and keep last duplicate key record |
perfect .... thanks very much Kolusu...
now we don't have to add an additional step to the job and change the existing one. |
Topic: ICETOOL - drop records and keep last duplicate key record |
tcurrier
Replies: 2
Views: 5646
|
Forum: Utilities Posted: Fri Jun 15, 2012 3:04 pm Subject: ICETOOL - drop records and keep last duplicate key record |
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 ... |
Topic: Recalling migrated datasets by dataset HLQs |
tcurrier
Replies: 2
Views: 2830
|
Forum: Utilities Posted: Thu Feb 02, 2012 2:17 pm Subject: Recalling migrated datasets by dataset HLQs |
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 ... |
Topic: add 1 to column using SORT |
tcurrier
Replies: 4
Views: 13419
|
Forum: Utilities Posted: Tue Jan 31, 2012 8:31 pm Subject: add 1 to column using SORT |
Thank you very much, Kolusu ... |
Topic: add 1 to column using SORT |
tcurrier
Replies: 4
Views: 13419
|
Forum: Utilities Posted: Tue Jan 31, 2012 7:22 pm Subject: add 1 to column using SORT |
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 ... |
Topic: add 1 to column using SORT |
tcurrier
Replies: 4
Views: 13419
|
Forum: Utilities Posted: Tue Jan 31, 2012 1:02 pm Subject: add 1 to column using SORT |
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 *
... |
Topic: Retain previous record values into subsequent record |
tcurrier
Replies: 8
Views: 10663
|
Forum: Utilities Posted: Thu Jan 26, 2012 7:29 am Subject: retaining previous values when putting out new detail line |
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 ... |
Topic: catalog list without entire HLQ ? |
tcurrier
Replies: 1
Views: 2052
|
Forum: Utilities Posted: Thu Dec 01, 2011 5:06 pm Subject: catalog list without entire HLQ ? |
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.
... |
Topic: convert numeric code to alpha literal in QMF ? |
tcurrier
Replies: 4
Views: 3844
|
Forum: Database Posted: Mon Nov 21, 2011 7:40 pm Subject: convert numeric code to alpha literal in QMF ? |
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 ... |
Topic: convert numeric code to alpha literal in QMF ? |
tcurrier
Replies: 4
Views: 3844
|
Forum: Database Posted: Mon Nov 21, 2011 8:28 am Subject: convert numeric code to alpha literal in QMF ? |
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 ... |
Topic: column of generated sequence numbers ? |
tcurrier
Replies: 5
Views: 3963
|
Forum: Database Posted: Wed Nov 02, 2011 8:59 am Subject: column of generated sequence numbers ? |
I got the following error using the second query :
SELECT POL_NUM, POL_SUFFIX ... |
Topic: column of generated sequence numbers ? |
tcurrier
Replies: 5
Views: 3963
|
Forum: Database Posted: Tue Nov 01, 2011 5:06 pm Subject: column of generated sequence numbers ? |
I only have version 8. Any chance of getting this functionality in V8 ? |
|