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 232 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Convert Amount having decimal point to PD using Syncsort
vini

Replies: 2
Views: 1641

PostForum: 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 Very Happy
  Topic: Convert Amount having decimal point to PD using Syncsort
vini

Replies: 2
Views: 1641

PostForum: 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: 5757

PostForum: 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: 5757

PostForum: 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: 5757

PostForum: 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: 5757

PostForum: 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: 5757

PostForum: 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: 5757

PostForum: 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: 5757

PostForum: 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: 3745

PostForum: 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: 13364

PostForum: 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: 13364

PostForum: 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: 13364

PostForum: 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: 13364

PostForum: Application Programming   Posted: Thu Jul 05, 2012 10:57 am   Subject: COBOL Combined Condition
Came across the following piece of code: Confused
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: 5690

PostForum: Utilities   Posted: Fri May 25, 2012 5:19 pm   Subject: Convert a VBA PDS to FB PDS
HRECOVER with REPLACE worked like a charm. Very Happy
 
Page 1 of 16 Goto page 1, 2, 3 ... 14, 15, 16  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group