Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need to create dynamic sort card

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
sampaul4u

New User


Joined: 27 Mar 2010
Posts: 19
Location: folirida

PostPosted: Tue Dec 23, 2014 12:43 pm    Post subject: Need to create dynamic sort card
Reply with quote

Good Day to All.

Need your help to create a Dynamic Sort Card.
My scenario like below.
The input file contains multiple employee numbers just below (This input file numbers can be decreased or increased depends upon the output created in the previous steps).
Employee number:
1001
1002
1003
1004

The output should be like below format.
SORT FIELDS=COPY
INCLUDE COND=((1,4,PD,EQ,1001), AND,
(1,4,PD,EQ,1002), AND,
(1,4,PD,EQ,1003), AND,
(1,4,PD,EQ,1004))

Thanks in advance for your timely help.

Regards
Pal
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Tue Dec 23, 2014 1:30 pm    Post subject:
Reply with quote

Please find my remarks below

1.Please use code tags
2.At this moment I see a space before AND thats an error might be due to lack of code tag
3.Also Your condition is not going to work due to two reasons AND should be replaced by OR and PD should be replaced by ZD
4.Also in this case you might not need a dynamic sort card but just could use JOINKEYS (It depends on the size of the input file)

Could you let us know what could be the size of the input file?

Please clarify on your requirment and get back to us if you have any more questions someone will be happy to help you icon_smile.gif
Back to top
View user's profile Send private message
sampaul4u

New User


Joined: 27 Mar 2010
Posts: 19
Location: folirida

PostPosted: Tue Dec 23, 2014 2:32 pm    Post subject:
Reply with quote

Hi Pandora,

I corrected & converted the requirements with code tags.

Code:
SORT FIELDS=COPY             
INCLUDE COND=((1,4,ZD,EQ,1001),OR,
                (1,4,ZD,EQ,1002),OR,
                 (1,4,ZD,EQ,1003),OR,
                 (1,4,ZD,EQ,1004))


The input file record length is 120.

Regards
Pal
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Tue Dec 23, 2014 2:40 pm    Post subject:
Reply with quote

Pandora-Box wrote:

Could you let us know what could be the size of the input file?
sampaul4u wrote:

The input file record length is 120.


My bad icon_redface.gif , I mean to ask how many records do you expect to be present in input file or even maximum records you expect ?
Back to top
View user's profile Send private message
sampaul4u

New User


Joined: 27 Mar 2010
Posts: 19
Location: folirida

PostPosted: Tue Dec 23, 2014 6:26 pm    Post subject: Reply to: Need to create dynamic sort card
Reply with quote

Around 15000 to 20000 records I will get in the input file,.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Tue Dec 23, 2014 6:36 pm    Post subject: Re: Reply to: Need to create dynamic sort card
Reply with quote

sampaul4u wrote:
Around 15000 to 20000 records I will get in the input file,.


It is better to use JOINKEYS rather dynamically creating the sort card

Search the forum for samples
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us