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
 

 

While sorting duplicate records do not get sorted

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

New User


Joined: 20 May 2005
Posts: 12
Location: bangalore

PostPosted: Fri May 20, 2005 2:40 pm    Post subject: While sorting duplicate records do not get sorted
Reply with quote

Hi Everybody there

I hav a doubt
How can u make sure that while sorting duplicate records do not get sorted?

icon_razz.gif
Back to top
View user's profile Send private message

varsha

New User


Joined: 20 May 2005
Posts: 12
Location: bangalore

PostPosted: Fri May 20, 2005 2:42 pm    Post subject: JCL sort
Reply with quote

Hi

Tell me in JCL sort you have 3 records in i/p file.
how will you make sure that the 1st record goes into ist, 2nd goes into 2nd and 3rd goes into 3rd.?
Back to top
View user's profile Send private message
varsha

New User


Joined: 20 May 2005
Posts: 12
Location: bangalore

PostPosted: Fri May 20, 2005 2:44 pm    Post subject:
Reply with quote

Hi

what parameters are required in JCL for creating a VSAM dataset?
Back to top
View user's profile Send private message
varsha

New User


Joined: 20 May 2005
Posts: 12
Location: bangalore

PostPosted: Fri May 20, 2005 2:46 pm    Post subject: SPUFI
Reply with quote

HI

What is SPUFI?
What is its use? what are the advantage of SPUFI?
Back to top
View user's profile Send private message
varsha

New User


Joined: 20 May 2005
Posts: 12
Location: bangalore

PostPosted: Fri May 20, 2005 2:49 pm    Post subject: QUERies
Reply with quote

Hi
How to run a cobol+db2 pgm. thru JCL?



If a job abends where do u see it?



How do u differentiate between a PS & PDS?
Back to top
View user's profile Send private message
varsha

New User


Joined: 20 May 2005
Posts: 12
Location: bangalore

PostPosted: Fri May 20, 2005 2:51 pm    Post subject:
Reply with quote

Hi

where can u see the structure of a VSAM dataset?


which parameter indicates that a PDS is being defined?


Whatever pgms. u code where do they get stored?
Back to top
View user's profile Send private message
subhasis_50

Moderator


Joined: 09 Mar 2005
Posts: 363
Location: Earth

PostPosted: Fri May 20, 2005 3:26 pm    Post subject: Re: sorting
Reply with quote

Hi,
During sorting if you dont want to sort duplicate records give
SUM FIELDS=NONE
For your 2nd question, give
SORT FIELDS=COPY

For creating a VSAM dataset through JCL u have to use IDCAMS utility.
You will get the details in the following link.
http://ibmmainframes.com/viewtopic.php?t=390&highlight=idcams

For know details about spufi
see
http://ibmmainframes.com/viewtopic.php?t=540

For Compile and run JCL see
http://ibmmainframes.com/viewtopic.php?t=1363&highlight=cobol+db2+run+jcl

For seeing the abends go to the spool. If in your job u have given DDNAME for storage dump. Then u will get a file in the spool. Open that file in the DUMPMASTER. For know more details on dumpmaster see
http://ibmmainframes.com/viewtopic.php?t=1977

For Difference between PDS & PS see
http://ibmmainframes.com/viewtopic.php?t=2866
Hope it will help you
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Fri May 20, 2005 3:26 pm    Post subject:
Reply with quote

I think that all your questions could be inserted correctly in the exact forum... and before a new post(but I'm not a moderator) you can also use a search for your questions... but:
1) depend on your sort fields parameter;
2) first, second and third are the relative position? if you need a sort to order records, you must put an example or tell us a key which your input file must be sorted and other kind of info as its organization, length and so on(and think that you can DFSORT without sorting...);
3) To create a VSAM you can use IDCAMS utility and specify within the sysin all the parameter you need: mainly command is DEFINE(usually with CLUSTER) then you can pass the other as space, key, recsize, share options... and so on;
4) Spufi is a DB2 utility that allow you to excute SQL Statement online and in background mode;
5.1) to run a cobol+db2 program you must compile your program in appropriate method and than you can execute it in two main way: CAF or RUN
5.2) in your spool viewer as SDSF...
5.3) PS is a file sequential and PDS is a file partitioned that work as folder and file within are unique on it. A Pds cannot contain a PS. Obviously their allocation is different... and for a PDS you must specify a number of directory block(that is zero for a PS)
6.1) go in 3.4 option and near the entry of vsam digit LISTCAT and see its information;
6.2) as above;
6.3) the load is stored in LOADLIB(different in each installation because it's custom for application developers)



For more detail use the search in this forum... most of your request are well documented.
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 Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


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