Author |
Message |
Topic: Convert Amount having decimal point to PD using Syncsort |
vini
Replies: 2
Views: 1671
|
Forum: Utilities Posted: Mon Mar 28, 2022 10:08 pm Subject: Convert Amount having decimal point to PD using Syncsort |
Thank you so much Kolusu !!!
The provided solution worked like a charm |
Topic: Convert Amount having decimal point to PD using Syncsort |
vini
Replies: 2
Views: 1671
|
Forum: Utilities Posted: Sat Mar 26, 2022 10:55 pm Subject: Convert Amount having decimal point to PD using Syncsort |
Hello Sort Gurus,
Please let me know if there is a way to convert a field which is of type 9(8).9(2) into Packed Decimal (Comp-3) using Syncsort ?
Field starts at position 85 in the FB file.
Ex:
... |
Topic: Comparing Dates Between Files Using DFSORT |
vini
Replies: 9
Views: 5837
|
Forum: Job Control Language(JCL) Posted: Tue Mar 31, 2020 11:20 am Subject: Comparing Dates Between Files Using DFSORT |
Apologies one more time for not following all the rules of this board around posting questions.
Appreciate all the help and kindness shown especially in these stressful times with the ongoing COV ... |
Topic: Comparing Dates Between Files Using DFSORT |
vini
Replies: 9
Views: 5837
|
Forum: Job Control Language(JCL) Posted: Mon Mar 30, 2020 10:39 pm Subject: Comparing Dates Between Files Using DFSORT |
Kolusu - Here is the step I added to an existing job and ran but got no paired records....
//DH99ST11 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//INA DD DSN=DH20062.PAID.EXCEL.PT5,DISP=SHR
//INB ... |
Topic: Comparing Dates Between Files Using DFSORT |
vini
Replies: 9
Views: 5837
|
Forum: Job Control Language(JCL) Posted: Mon Mar 30, 2020 10:12 pm Subject: Comparing Dates Between Files Using DFSORT |
Hi Kolusu,
My sincere apologies for the less than ideal stating of requirements...
Ran the job with positions changed per what I understood/guessed but it did not pair any records.
That must ... |
Topic: Comparing Dates Between Files Using DFSORT |
vini
Replies: 9
Views: 5837
|
Forum: Job Control Language(JCL) Posted: Mon Mar 30, 2020 3:55 pm Subject: Comparing Dates Between Files Using DFSORT |
Please ignore the numbers in column 1 to 6 of sample data its of no significance. |
Topic: Comparing Dates Between Files Using DFSORT |
vini
Replies: 9
Views: 5837
|
Forum: Job Control Language(JCL) Posted: Mon Mar 30, 2020 3:50 pm Subject: Comparing Dates Between Files Using DFSORT |
Sample Data .... the layout in original post was made up for ease the actual spacing and lengths may vary....
File A
R00113078 A 06/27/2017 04/09/2019
R00436436 C 01/2 ... |
Topic: Comparing Dates Between Files Using DFSORT |
vini
Replies: 9
Views: 5837
|
Forum: Job Control Language(JCL) Posted: Mon Mar 30, 2020 3:37 pm Subject: Comparing Dates Between Files Using DFSORT |
Hi Kolusu,
FileA has approx 1000 records and FileB about 1Million records. File B is like the transaction data so each Contract ID Patend Cd combo can have multiple records in File B so the date ra ... |
Topic: Comparing Dates Between Files Using DFSORT |
vini
Replies: 9
Views: 5837
|
Forum: Job Control Language(JCL) Posted: Mon Mar 30, 2020 12:54 pm Subject: Comparing Dates Between Files Using DFSORT |
Hi,
There are 2 Files in FB format with varying LRECLS and layout as follows:
File A
CONTRACT-ID PIC X(08)
FILLER PIC X(10)
BGN-INCURRED-DT ... |
Topic: Listing the GDG generations which have Data |
vini
Replies: 1
Views: 3780
|
Forum: Job Control Language(JCL) Posted: Thu Jul 31, 2014 9:41 am Subject: Listing the GDG generations which have Data |
Hi,
Anyone can let me know how to find which are the generations which have any data in them via executing a utility/JCL ?
Any other method using File Aid foreground is ok as well.
There are t ... |
Topic: COBOL Combined Condition |
vini
Replies: 15
Views: 13428
|
Forum: Application Programming Posted: Fri Jul 06, 2012 4:45 pm Subject: COBOL Combined Condition |
Ooops I meant NOT with OR in the same field ... and not just an OR alone in an IF... |
Topic: COBOL Combined Condition |
vini
Replies: 15
Views: 13428
|
Forum: Application Programming Posted: Fri Jul 06, 2012 4:44 pm Subject: COBOL Combined Condition |
Papadi .... After understanding how this works with help of Anujs findings ... I must say you are absolutely right about avoiding OR on the same field in an IF.
The original statement in question ... |
Topic: COBOL Combined Condition |
vini
Replies: 15
Views: 13428
|
Forum: Application Programming Posted: Thu Jul 05, 2012 4:30 pm Subject: COBOL Combined Condition |
Kolusu,
I thought I had heard something similar before but wanted to double check.
Ever wonder why this translation occurs ? Isn't COBOL supposed to be very english-like for enhanced readability ... |
Topic: COBOL Combined Condition |
vini
Replies: 15
Views: 13428
|
Forum: Application Programming Posted: Thu Jul 05, 2012 10:57 am Subject: COBOL Combined Condition |
Came across the following piece of code:
IF WS-INDICATOR NOT = ('Y' AND 'P')
Question:
Does the 'AND' in the statement get converted to an 'OR' ? If not, when will this statement be ... |
Topic: Convert a VBA PDS to FB PDS |
vini
Replies: 6
Views: 5725
|
Forum: Utilities Posted: Fri May 25, 2012 5:19 pm Subject: Convert a VBA PDS to FB PDS |
HRECOVER with REPLACE worked like a charm. |
|