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 12 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Get count of field value occurrences for a Group
guhanath

Replies: 10
Views: 5783

PostForum: Utilities   Posted: Mon Apr 09, 2018 12:45 am   Subject: Get count of field value occurrences for a Group
Hi Kolusu,

Thanks for the suggestion and i have implemented without DCB. The code is working well. Thank You.

Thanks,
Nath.
  Topic: Get count of field value occurrences for a Group
guhanath

Replies: 10
Views: 5783

PostForum: Utilities   Posted: Mon Apr 02, 2018 9:35 am   Subject: Get count of field value occurrences for a Group
Hi Kolusu,

Thanks for solution.

why do you need an ICETOOL code? You do realize that ICETOOL under the covers calls DFSORT? so what exactly are you trying to achieve ?

I would like to re-ord ...
  Topic: Get count of field value occurrences for a Group
guhanath

Replies: 10
Views: 5783

PostForum: Utilities   Posted: Fri Mar 30, 2018 8:50 am   Subject: Get count of field value occurrences for a Group
Hi,

How can i use KEYBEGIN suppose my input file is like below for the same output.



Input file

FL1 FL2 FL3 (REC Length 13, Fixex Block)
--- ---- ----
PPP NKY1 KEY1
PPP NKY2 K ...
  Topic: Get count of field value occurrences for a Group
guhanath

Replies: 10
Views: 5783

PostForum: Utilities   Posted: Fri Mar 30, 2018 1:10 am   Subject: Get count of field value occurrences for a Group
Hi Kolusu,

Thanks, its working for me.

Can i get this code in ICETOOL instead of SORT? I can use CTL1CNTL cards in that than SORT to re-sorting the records.

Thanks,
Nath.
  Topic: Get count of field value occurrences for a Group
guhanath

Replies: 10
Views: 5783

PostForum: Utilities   Posted: Thu Mar 29, 2018 8:46 am   Subject: Get count of field value occurrences for a Group
Hi Arun Raj,

Yes. It's may be the order as you mention. But first duplicate record should have 1 and remaining duplicate records should be 0.

Thanks,
Nath
  Topic: Get count of field value occurrences for a Group
guhanath

Replies: 10
Views: 5783

PostForum: Utilities   Posted: Thu Mar 29, 2018 4:59 am   Subject: Get count of field value occurrences for a Group
Hi,

I have modified my output file. Please find below the expected output file.


Output file

FL1 FL2 FL3 (REC Length 8, Fixex Block)
--- ----- ----
PPP AAA1 1
PPP AAA2 1
QQ ...
  Topic: Get count of field value occurrences for a Group
guhanath

Replies: 10
Views: 5783

PostForum: Utilities   Posted: Thu Mar 29, 2018 4:18 am   Subject: Get count of field value occurrences for a Group
Hi,

I am having a requirement like below and would like to do in DFSORT in one step. Please help me on this.


Input file

FL1 FL2 (REC Length 8, Fixex Block)
--- ---
PPP AAA1
PPP A ...
  Topic: Split HTML record using tags
guhanath

Replies: 11
Views: 9034

PostForum: Utilities   Posted: Mon Sep 12, 2016 12:16 am   Subject: Split HTML record using tags
Hi Magesh,

Thanks for coding on SORT. I will check this and post you if any thing either work or not.

@Kolusu,

Thanks. Yes, I can understand the business rules. Any how i will check it in S ...
  Topic: Split HTML record using tags
guhanath

Replies: 11
Views: 9034

PostForum: Utilities   Posted: Sat Sep 10, 2016 7:34 am   Subject: Split HTML record using tags
Hi Kolusu,

Thanks for your help. I have tried with your code but got RC=12 with below error message.


SYT000I SYNCTOOL RELEASE 1.7.0 - COPYRIGHT 2008 SYNCSORT INC.
SYT001I ...
  Topic: Split HTML record using tags
guhanath

Replies: 11
Views: 9034

PostForum: Utilities   Posted: Fri Sep 09, 2016 3:55 am   Subject: Split HTML record using tags
Hi Kolusu,

Sorry for confusion. My input file record length is 300 (FB) and each record contains the string '</TD>'. I want to break the record after '</TD>' string.

Suppose one rec ...
  Topic: Split HTML record using tags
guhanath

Replies: 11
Views: 9034

PostForum: Utilities   Posted: Thu Sep 08, 2016 12:19 pm   Subject: Split HTML record using tags
Hi Magesh,

Thanks for looking into this.

Yes. The Rec1 and Rec2 are in a single line (Single Record) with LRECL=300.
  Topic: Split HTML record using tags
guhanath

Replies: 11
Views: 9034

PostForum: Utilities   Posted: Thu Sep 08, 2016 8:16 am   Subject: Split HTML record using tags
Hi,

I am having an input file which is in format of html tags.I would like to split each record from input file after by '</TD>' string. Below given the sample input and required output file ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group