Sort card

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
Sunilkumar
Member
Posts: 8
Joined: Thu Oct 04, 2012 2:36 pm

Sort card

Post by Sunilkumar » Thu Oct 04, 2012 2:59 pm

Hi All,
In my application, for every new FTP card we write a module so that the we can use the current working day or previous working day as a part of the Non-Mainframe file name. Rest of the parameter is hard coded.

ex:
ABCDEFGH.US.COM
USERNAME
PASSWORD
CD FOLDER1
CD FODLER2
PUT HXXXXXX.X.XXXXXX.XXXXXXXX.XXXXXXXX +
585_20120916_MAIP.XML

20120916 is the date which will keep changing as per our requirement. It can be todays date/ last working /last Monday.

Now I intend to write to do this by SYNCSORT. I am able to insert current date. I'm thinking to use the OPC passed dates which will fulfill my all requirement. Below is my sort card.


[/img]

Code: Select all

//  SET GL0066='120916'                                 
//STEP001  EXEC PGM=SORT    PARM='JP1"&GL0066"'         
//SORTIN   DD   *                                       
ABCDEFGH.US.COM                                         
USERNAME                                                
PASSWORD                                                
CD FOLDER1                                              
CD FODLER2                                              
PUT HXXXXXX.X.XXXXXX.XXXXXXXX.XXXXXXXX +                
  585_MAIP.XML                                          
//SORTOUT DD   DSN=FILENAME                             
//SYSIN   DD   *                                        
  OPTION COPY                                           
  OUTREC IFTHEN=(WHEN=(1,71,SS,EQ,C'.XML'),             
     BUILD=(1:1,6,7:&DATENS,13:C'_',14:7,67))           
//SYSOUT  DD   SYSOUT=*                                 
//                                                      
While real perfection is only one, relative perfections must be many.

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Thu Oct 04, 2012 3:05 pm

So why post in JCL when you have a sort question. All sort questions on this forum should be posted in the Sort section of the forum. And it is only good practice to study the layout of a forum and read its rules before posting thus avoiding this mistake.

Leave your post where it is (you cannot move it anyway) and someone may move it for you or it will be dealt with here.
Regards
Nic

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Thu Oct 04, 2012 3:07 pm

And? Have you discovered whether your version of SyncSort supports JPn?

Sunilkumar
Member
Posts: 8
Joined: Thu Oct 04, 2012 2:36 pm

Post by Sunilkumar » Thu Oct 04, 2012 3:18 pm

JPn is supported only in DFSORT/ICETOOL but not in SYNCSORT.
While real perfection is only one, relative perfections must be many.

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Thu Oct 04, 2012 3:21 pm

Sunilkumar wrote:JPn is supported only in DFSORT/ICETOOL but not in SYNCSORT.
So why code it in your SYNCSORT control cards?
And, what is your QUESTION? You have not asked one yet!
Regards
Nic

Sunilkumar
Member
Posts: 8
Joined: Thu Oct 04, 2012 2:36 pm

Post by Sunilkumar » Thu Oct 04, 2012 3:25 pm

In my jcl there is a variable GL0066 which I'm using to hold the required date and want it pass to the build parameter in outrec of the sort sysin.
While real perfection is only one, relative perfections must be many.

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Thu Oct 04, 2012 3:27 pm

Jolly good! Go on then!
Clue: have you used the search facility of the forum? or Google? I suggest a Google query along the lines of 'pass a parameter to syncsort'
Regards
Nic

Sunilkumar
Member
Posts: 8
Joined: Thu Oct 04, 2012 2:36 pm

Post by Sunilkumar » Thu Oct 04, 2012 3:50 pm

After searching google I received following two ways to pass the value.

1. DFSPARM
2. SYMNAMES

I think (whatever the examples I saw) we can only pass some hard-coded value. Instead of these hard-coded value I want to pass the variable which hold the date.
While real perfection is only one, relative perfections must be many.

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Thu Oct 04, 2012 4:14 pm

You will have to pass your parm to some program that can accept it and have that program create your sort card(s) as per examples.
Regards
Nic

Sunilkumar
Member
Posts: 8
Joined: Thu Oct 04, 2012 2:36 pm

Post by Sunilkumar » Thu Oct 04, 2012 5:48 pm

Can I get an equivalent of sort card for ICETOOL utility? I don't have any experience on ICETOOL.
While real perfection is only one, relative perfections must be many.

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Thu Oct 04, 2012 6:05 pm

ICETOOL is part of DFSORT. As you use SYNCSORT you need SYNCTOOL. You should have access to the manual somewhere. Ask around. But you will, probably, have the same restrictions as you have with trying to get parameters into SYNCSORT.
Regards
Nic

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Thu Oct 04, 2012 11:23 pm

Your topic has been moved to the part of the froum where sort questions are discussed.

Your system may or may not recognize ICETOOL. Often, SYNCTOOL is given an alias of ICETOOL.
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others