 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 27 matches |
| Author | Message |
|---|---|
 Topic: Read array in reverse order and remove duplicates |
|
| koolspark Replies: 2 Views: 2448 |
 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: 3150 |
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: 3150 |
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: 3150 |
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: 2448 |
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: 5502 |
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: 1532 |
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: 5046 |
Forum: Utilities Posted: Wed Mar 16, 2011 8:47 am Subject: Match & Replace |
| any help? | |
| Topic: Match & Replace |
|
| koolspark Replies: 11 Views: 5046 |
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: 5046 |
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: 5046 |
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: 5046 |
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: 5046 |
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: 5046 |
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: 2167 |
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 ... |
|
All times are GMT - 5 Hours |