While sorting duplicate records do not get sorted

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

Hi Everybody there

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

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

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.?

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

Hi

what parameters are required in JCL for creating a VSAM dataset?

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

HI

What is SPUFI?
What is its use? what are the advantage of SPUFI?

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

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?

varsha · New User Joined: 20 May 2005 Posts: 12 Location: bangalore

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?

subhasis_50 · Moderator Joined: 09 Mar 2005 Posts: 368 Location: Earth

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

MGIndaco · Posted: Fri May 20, 2005 3:26 pm Post subject:

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.