Author |
Message |
Topic: Read array in reverse order and remove duplicates |
koolspark
Replies: 2
Views: 2343
|
Forum: 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 |
Topic: Read Unique rows from a DB2 table |
koolspark
Replies: 5
Views: 3029
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: Utilities Posted: Wed Mar 16, 2011 8:47 am Subject: Match & Replace |
any help? |
Topic: Match & Replace |
koolspark
Replies: 11
Views: 4992
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ... |
|