Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SYNCSORT - Match the key for the first bytes

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
elsajthomas

New User


Joined: 30 Nov 2006
Posts: 6
Location: fort worth

PostPosted: Fri Jan 15, 2010 3:11 pm    Post subject: SYNCSORT - Match the key for the first bytes
Reply with quote

Hi,

I have two FB files of the exact same length. Lets say for the sake of simplicity FB 100. The requirement is to
(a) Match the key (1,5,CH) for the first bytes and get all the records in File 1 which is not present on File 2 into file 3
(b) If key (1,5,ch) matches, then compare the date fields (6,18) (ccyy-mm-ddhh.mm.ss) and if the difference is either positive or negative 3 hours, then ignore that record, write remaining records into file 3

(a) is definitely possible in sort and i have done this. However can we do (b) as well either way directly or convert the date into hours/second and then do comparison and suggestions will definitely help. I understand we can do this in cobol using and INTEGER-OF-DATE function. However matching is much simpler in sort.

Thanks
Elsa
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10375
Location: italy

PostPosted: Fri Jan 15, 2010 3:20 pm    Post subject: Reply to: SYNCSORT
Reply with quote

quoting verbatim expat with the proper legalese about copyright, IP ownership, fair use assumption, the usual blah blah icon_wink.gif
Quote:
Because the solution for sort related questions may vary from product to product, please ensure that you state clearly which sort product you are using.

If you are not sure, then by running a simple sort step shown below, you will be able to find out for yourself.

If the messages start with ICE then your product is DFSORT. Please also post the output of the complete line which has a message code ICE201I, as this will enable our DFSORT experts to determine which release of DFSORT that you have installed. This may also affect the solution offered.

If the messages start with WER or SYT then the product is SYNCSORT and should be posted in the JCL forum. Please also post the information telling which version of SYNCSORT is installed, as this may also affect the solution offered.

Thank you for taking your time to ensure that the valuable time of others is not wasted by offering inappropriate solutions which are not relevant due to the sort product being used and/or the release that is installed in you site.

Code:
//SORTSTEP EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN   DD *
ABC
//SORTOUT  DD SYSOUT=*
//SYSIN    DD *
  SORT     FIELDS=COPY


You also need to provide more detail than you already have.

What is the DSORG, RECFM & LRECL of the input file.


please refrain from posting the same question on multiple forums,
as said zillions times by expat find the sort product that You are using
and post only once. Thank You in advance for caring!
also when posting use a meaningful title, SYNCSORT does not convey any useful info about Your issue
Back to top
View user's profile Send private message
elsajthomas

New User


Joined: 30 Nov 2006
Posts: 6
Location: fort worth

PostPosted: Fri Jan 15, 2010 3:43 pm    Post subject: SYNCSORT - Timestamp Comparison
Reply with quote

Thank you for your suggestions.
We have SYNCSORT as the utility. However, the reason for the multiple posts, is because my colleage uses DFSORT. For this particular scenario, should the posting be done differently? Your suggestions are welcome.

I will ensure the subject line is more meaningful. Thank you for pointing that out.

Please let me know if you feel you need more information or I need to re-word differently.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Fri Jan 15, 2010 3:48 pm    Post subject:
Reply with quote

Please also post the information telling which version of SYNCSORT is installed, as this may also affect the solution offered.
Back to top
View user's profile Send private message
elsajthomas

New User


Joined: 30 Nov 2006
Posts: 6
Location: fort worth

PostPosted: Mon Jan 18, 2010 9:32 am    Post subject: SYNCSORT - Match the key for the first bytes
Reply with quote

In IO
SYNCSORT FOR Z/OS 1.3.2.0

Using help on synsort, the following appears.
Version 3 Release 7.

Please let me know if this informaiton will suffice
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am
No new posts Match records - scdinesh DFSORT/ICETOOL 6 Wed Feb 22, 2017 5:02 am
No new posts JCL sort Match and NoMatch rakeshsekar1987 SYNCSORT 2 Thu Feb 02, 2017 10:26 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us