MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 176 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Drop 'unpaired' key records based on value in another field.
tcurrier

Replies: 5
Views: 3261

PostForum: 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: 3261

PostForum: 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: 3261

PostForum: 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: 5410

PostForum: 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: 5410

PostForum: 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: 2676

PostForum: 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: 13073

PostForum: 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: 13073

PostForum: 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: 13073

PostForum: 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: 10184

PostForum: 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: 1880

PostForum: 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: 3512

PostForum: 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: 3512

PostForum: 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: 3687

PostForum: 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: 3687

PostForum: 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 ?
 
Page 1 of 12 Goto page 1, 2, 3 ... 10, 11, 12  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group