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 27 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Read array in reverse order and remove duplicates
koolspark

Replies: 2
Views: 2343

PostForum: Application Programming   Posted: Thu Jul 28, 2022 11:37 am   Subject: Read array in reverse order and remove duplicates
hi Kolusu,
Thank you very much for your help. It worked Smile
  Topic: Read Unique rows from a DB2 table
koolspark

Replies: 5
Views: 3029

PostForum: Database   Posted: Fri Jul 15, 2022 8:38 am   Subject: Read Unique rows from a DB2 table
Hi Kolusu,
Thank you very much for your response. please find below the data from our database. I've ordered them on 'SYS_TMSTMP DESC'

---------+---------+---------+---------+---------+---------+- ...
  Topic: Read Unique rows from a DB2 table
koolspark

Replies: 5
Views: 3029

PostForum: Database   Posted: Thu Jul 14, 2022 10:31 am   Subject: Read Unique rows from a DB2 table
Hi Kolusu,
Thank you very much for your quick response and really sorry for not putting my question right in the first place. I did some research on our data and found that if the customer didn't sel ...
  Topic: Read Unique rows from a DB2 table
koolspark

Replies: 5
Views: 3029

PostForum: Database   Posted: Wed Jul 13, 2022 4:03 pm   Subject: Read Unique rows from a DB2 table
I've a DB2 table. Whenever a customer pays their insurance premium through a credit Card, we make an entry to the DB2 table with a tracking number, policy#, Card#, Timestamp#, Amount paid.

TRK# ...
  Topic: Read array in reverse order and remove duplicates
koolspark

Replies: 2
Views: 2343

PostForum: Application Programming   Posted: Mon Jul 11, 2022 4:00 pm   Subject: Read array in reverse order and remove duplicates
hi,

We have 300 bytes VSAM KSDS file (online file, used in CICS) with Policy number, renew count, cycle date and sequence number as part of the key.
Every time the policy premium is paid, a new r ...
  Topic: compare two files in sort
koolspark

Replies: 1
Views: 5489

PostForum: Utilities   Posted: Thu May 17, 2012 8:39 am   Subject: compare two files in sort
hi,

I've a specific requirement to compare two files & write into two output files.

F1: (file1 can contain duplicates)
LRECL = 400
key = (110,06,CH)

F2:(file2 doesn't contain any dupl ...
  Topic: Extract data from flat flie based on condition using SORT
koolspark

Replies: 1
Views: 1512

PostForum: Utilities   Posted: Tue Apr 26, 2011 5:54 am   Subject: Extract data from flat flie based on condition using SORT
I've a file with LRECL=1200, which has client addresses starting from position 326 to 505 (total 180 bytes).
This address is split into 6 fields, each of 30bytes lenth.
address-line-1 from 326 to ...
  Topic: Match & Replace
koolspark

Replies: 11
Views: 4992

PostForum: Utilities   Posted: Wed Mar 16, 2011 8:47 am   Subject: Match & Replace
any help?
  Topic: Match & Replace
koolspark

Replies: 11
Views: 4992

PostForum: Utilities   Posted: Wed Mar 02, 2011 12:45 am   Subject: Match & Replace
papadi,

we are using 'Z/OS DFSORT V1R10'

Thanks,
  Topic: Match & Replace
koolspark

Replies: 11
Views: 4992

PostForum: Utilities   Posted: Tue Mar 01, 2011 12:47 pm   Subject: Match & Replace
INA
1111111111 AAAAAAA
1111111111 BBBBBBB
2222222222 CCCCCCCC ...
  Topic: Match & Replace
koolspark

Replies: 11
Views: 4992

PostForum: Utilities   Posted: Tue Mar 01, 2011 12:43 pm   Subject: Match & Replace
kolusu,
I'm really sorry failing to put forward my requirement clearly. with your first solution, i was missing the unmatched records from the first file in my output. also, i was not getting the dup ...
  Topic: Match & Replace
koolspark

Replies: 11
Views: 4992

PostForum: Utilities   Posted: Tue Mar 01, 2011 10:42 am   Subject: Match & Replace
kolusu,

If i find a match, then i should copy the data from the second file to output. I should not copy the data from first file.

INA file:
1111111111 aaaaaaaaaa
1111111111 bbbbbbbbbb

I ...
  Topic: Match & Replace
koolspark

Replies: 11
Views: 4992

PostForum: Utilities   Posted: Tue Mar 01, 2011 6:03 am   Subject: Match & Replace
Kolusu,
thanks for your time, but I'm not getting unmatched records from INA file. I need all unmatched records also from both INA & INB files and if a match is found then i should copy the reco ...
  Topic: Match & Replace
koolspark

Replies: 11
Views: 4992

PostForum: Utilities   Posted: Sun Feb 27, 2011 12:27 pm   Subject: Match & Replace
hi,

I've two files FILE1 and FILE2. LRECL=80 for both the files. I've to compare the two files on the first 10bytes & merge the records, write the records to FILE3. if the record exists only in ...
  Topic: MATCH & UNMATCH
koolspark

Replies: 4
Views: 2146

PostForum: Utilities   Posted: Tue Feb 08, 2011 5:34 am   Subject: MATCH & UNMATCH
I'm sorry. I gave wrong LRECL for the SORTOUT file. Your sort works fine.
If I want to sort the sortout file based on the first 10 bytes, where/how should i specify the SORT FIELDS ?

Thank you ve ...
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group