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
 

 

Diffrence between sort, dfsort, icetool, sync sort

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

New User


Joined: 13 Jun 2005
Posts: 8
Location: hyderabad

PostPosted: Mon Jan 30, 2006 5:01 pm    Post subject: Diffrence between sort, dfsort, icetool, sync sort
Reply with quote

hi friends

i am having a file wich is having 1000 records , and i want to do sorting using jcl
in that i want to sort only the records in between 10 and 50 and i should stop after 50th recoed

and can i know the diffrence between sort, dfs sort, icetool, sync sort.

will they work the same ...

or any thing that differs ...[/b]
Back to top
View user's profile Send private message

chvj123

New User


Joined: 13 Jun 2005
Posts: 8
Location: hyderabad

PostPosted: Mon Jan 30, 2006 5:04 pm    Post subject: db2 cursor
Reply with quote

i have a table wich consists of 10 colums , and i have to update only one column init , cani know how to do this using cursors
Back to top
View user's profile Send private message
chvj123

New User


Joined: 13 Jun 2005
Posts: 8
Location: hyderabad

PostPosted: Mon Jan 30, 2006 5:07 pm    Post subject: jcl cond parameter
Reply with quote

hi friends

in jcl we have condition parameter in that i have 3 steps

so to check the return code of previous step wich lies between 21 to 44

so how shuld i code the thing in my jcl program

regards,
vj
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Mon Jan 30, 2006 5:11 pm    Post subject: Re: sorting (jcl)
Reply with quote

Quote:
i have a table wich consists of 10 colums , and i have to update only one column init , cani know how to do this using cursors



Cursor is used where there is in need of selection of multiple rows. since ur requirement is only one row y r u trying to do with cursor???? Try the simplest way my frnd icon_smile.gif
Back to top
View user's profile Send private message
dtalele
Currently Banned

New User


Joined: 25 Jan 2006
Posts: 13
Location: mumbai

PostPosted: Mon Jan 30, 2006 5:14 pm    Post subject: Re: sorting (jcl)
Reply with quote

HI,
chvj123,

fOLLOWING IS THE JCL FOR YOUR PROBLEM,

//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=
//SORTOUT DD DSN=
//SORTWK01 DD UNIT=SYSDA
//SYSIN DD *
SKIPREC=n
STOPAFT=n
/*

SKIPREC SKIPS THE N RECORDS & STOPAFTER STOPS AFTER N RECORDS.

SO YOU CAN APPLY YOUR CASE ACCORDINGLY
Back to top
View user's profile Send private message
jimmy_augustine

New User


Joined: 06 Feb 2004
Posts: 1
Location: Ireland

PostPosted: Mon Jan 30, 2006 5:37 pm    Post subject: Re: sorting (jcl)
Reply with quote

khamarutheen wrote:
Quote:
i have a table wich consists of 10 colums , and i have to update only one column init , cani know how to do this using cursors



Cursor is used where there is in need of selection of multiple rows. since ur requirement is only one row y r u trying to do with cursor???? Try the simplest way my frnd icon_smile.gif



I dunno how this topic is in this question about JCL. how ever his question was to how to update using a curson when he have 10 columns in a table.
He just mentioned that he only want to update one column, not just one row. Any way, if you want to update using cursors, then declare a curson with update option. Then use the update sql with current option
Thanks
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Jan 30, 2006 10:21 pm    Post subject:
Reply with quote

Quote:
i am having a file wich is having 1000 records , and i want to do sorting using jcl
in that i want to sort only the records in between 10 and 50 and i should stop after 50th recoed


You can use a DFSORT job like the following to sort records 10-50. Change the SORT statement to specify the key(s) you want to sort on.

Code:

//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...  input file
//SORTOUT DD DSN=...  output file
//SYSIN DD *
   OPTION SKIPREC=9,STOPAFT=41
   SORT FIELDS=(1,5,CH,A)


Quote:
and can i know the diffrence between sort, dfs sort, icetool, sync sort.

will they work the same ...


DFSORT is IBM's sort product. Syncsort is Syncsort, Inc's sort product. SORT is a generic name for sort products. ICETOOL is a multipurpose utility that you get free with DFSORT.

For more information on DFSORT and DFSORT's ICETOOL, visit the DFSORT website at:

http://www.ibm.com/storage/dfsort/

DFSORT and Syncsort have similarities and differences. If you or anyone else on this board would like some documents prepared by the DFSORT Team that describe what we see as the advantages of DFSORT over Syncsort, as well as considersations for migrating from Syncsort to DFSORT, send me an e-mail offline (yaeger@us.ibm.com). Please put "DFSORT" somewhere in your Subject line to catch my attention.
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 How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm


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