Explain with example?

Read Best Answer

Editorial / Best Answer

jjtharappel  

 Profile Answers by jjtharappel Questions by jjtharappel

• Member Since Nov-2011 | Nov 24th, 2011

---

Run a JCL with the below sort step

Code
//STEP1    EXEC PGM=SORT                             
//SORTIN   DD DSN=input-file-name,DISP=SHR          
//SORTOF01 DD DSN=output-file-name-1,          
//            DISP=(NEW,CATLG,DELETE),               
//            SPACE=... 
//            LRECL=...,RECFM=FB     
//SORTOF02 DD DSN=output-file-name-2,          
//            DISP=(NEW,CATLG,DELETE),               
//            SPACE=... 
//            LRECL=...,RECFM=FB                     
//SORTOF03 DD DSN=output-file-name-3,          
//            DISP=(NEW,CATLG,DELETE),               
//            SPACE=... 
//            LRECL=...,RECFM=FB                        
//SYSOUT   DD SYSOUT=*                               
//SYSIN    DD *                                      
  SORT FIELDS=COPY                                        
  OUTFIL FNAMES=SORTOF01,                                 
   INCLUDE=(cond for file 1)  
  OUTFIL FNAMES=SORTOF02,                                 
   INCLUDE=(cond for file 2)  
  OUTFIL FNAMES=SORTOF03,                                 
   INCLUDE=(cond for file 3)
/*
//*
 

Haribabu

• Oct 15th, 2019

SORT FIELDS=COPY
OUTFIL FILES=OUT1,ENDREC=10000
OUTFIL FILES=02,STARTREC=10001,ENDREC=20000 OUTFIL FILES=03,STARTREC=20001,ENDREC=30000

also possible for OUTFIL FNAMES=(OUT1,OUT2,OUT3),SPLIT=10000

Rishu

• Jul 31st, 2014

In addition to the above solution, we can use SPLIT BY in SORT. But it will depend on condition of split.

Improve Answer

how do you create a new VSAM file with null record as header with JCL please provide me with coding

sai

• May 31st, 2019

USE PGM=IEBDG in JCL. Copy the Dummy file to VSAM using Repro

Answer Question  Select Best Answer

Hi,I have a file which contains 3 types of transactions with account number,transaction type and transaction creation date.The transaction types are 35,39 and 41.The file has duplicate records for all transactions(ie 2 records for each account number for each transaction).Now I need to remove the duplicate for the 39 type transaction alone and keep the remaining.That is only for the transaction type...

manikanta

• Feb 15th, 2019

We can do it by ICETOOL by selecting the firs duplicate row only and rest of the rows based on the transtion type it will not copy.
SELECT FROM(IN) TO(OUT) ON(starting post,length,CH) USING(CTL1) FIRST - it will copy the first records only.

Rishu

• Jul 31st, 2014

It is not possible to do it in single SORT step. 2 steps are required. First, extract all 39 type transaction record using EXCLUDE statement. Second, remove duplicate from step 1 file with SUM FIELDS=NONE. Third, merge output from step1 and 2.

Answer Question  Select Best Answer

Nandhakumar

• Nov 19th, 2018

Start is used to read a file dynamically (Some where in between the file), so its not needed for sequential read from end of the file. Moving High-values to Key field would absolutely work.

Premasai

 Profile Answers by Premasai Questions by Premasai

• Jun 12th, 2010

I dont think moving HIGH-VALUES will take you to the last record , as you need to access the record for which the key value is <= HIGH VALUES. And START KEY syntax does not allow you to search a ke...

Answer Question  Select Best Answer

- whether record size is (5+alternate key length+n*pmy key length ) or (5+pmy key length + n*alternate key length) where 'n' is the no. of duplicate alternate keys.

naveen

• Mar 6th, 2017

After creating the AI we need to create path and finally we need to create the Build index. Then only the AI will have the actual data in it.

sagyant

 Profile Answers by sagyant Questions by sagyant

• Oct 3rd, 2010

what i have come across,it is always 5 + alternate key length + n*primary Key lengththe key for alternate index is the alternate key and in the data part we have all the related primary keys populated.But i still do not understand how this data part get populated...:)

Answer Question  Select Best Answer

Subra Kondaveeti

• May 18th, 2016

The expansion for RDW is Record Description Word

Rishu

• Jul 31st, 2014

In addition to above, out of 4 byte of RDW, 2 bytes are for system control information and rest 2 byte for length of the record.

Answer Question  Select Best Answer

srinivas

• Sep 24th, 2014

Actually Dirty read is an another name for Uncommitted Read.Generally we use this in cobol-db2 program. When a user from one end is updating a table another user from other end can read the same table...

Srivi

• May 19th, 2013

Quite often in database processing, we come across the situation wherein one transaction can change a value, and a second transaction can read this value before the original change has been committed ...

Answer Question  Select Best Answer

Rishu

• Aug 2nd, 2014

There is no specific rule about average record length. It should be less than the maximum records length. VSAM uses this figure for efficiency purpose only.

venkat.palla

• Aug 7th, 2007

Average record length is the sub parameter of record size, which need to be defined while defining the vsamfile.  This sub parameter has a value which is less than or equal to another sub paramet...

Answer Question  Select Best Answer

Rishu

• Aug 2nd, 2014

VSAM is a Non-Relational database system while DB2 is a relational Database System(RDBS).

nlarsensmith

 Profile Answers by nlarsensmith Questions by nlarsensmith

• Dec 1st, 2010

Ans1) DB tables are preferred when we want to maintain relationship amoung data. If no relationship is required then we can choose any. Remeber DB2 tables are always stored in VSAM files.Ans2)Flat fil...

Answer Question  Select Best Answer

How to copy records from 2 files with duplicates? Without duplicates?

Rishu

• Jul 31st, 2014

With Duplicates:- simply merge two files. Without Duplicates:- SUM FIELDS=NONE

sekhar

• Jan 8th, 2012

UNION..........WITH OUT DUPLICATES
UNION ALL.........WITH DUPLICATES

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

nlarsensmith  

 Profile Answers by nlarsensmith Questions by nlarsensmith

• Member Since May-2009 | Dec 1st, 2010

---

If the record size parameter is not specified when the cluster is created, then the size is determined by the size of the Control Interval.

kumar

• Jul 3rd, 2014

For non spanned--(4089,4089)
for spanned---(4086,32600)

nlarsensmith

 Profile Answers by nlarsensmith Questions by nlarsensmith

• Dec 1st, 2010

If the record size parameter is not specified when the cluster is created, then the size is determined by the size of the Control Interval.

Improve Answer

K.Abhilash Kumar

• Nov 26th, 2012

We can read last record in CICS using Read Prev command by moving High-Values to the key. Move High-Values to Ws-Key ExEC CICS STARTBR FILE(LOGICAL FILE NAME) RIDFLD(WS...

chandra

• Oct 20th, 2011

First of all we have to do

MOVE HIGH-VALUES TO KEY-NAME
AFTER

READ NEXT RECORD
DISPLAY 'RECORD'

Answer Question  Select Best Answer

How do you read a ksds file in reverse order?

hemanth.pesce

 Profile Answers by hemanth.pesce Questions by hemanth.pesce

• Sep 29th, 2011

- Use STARTBR Command to point it to last record with by moving Keys to HIGH values .
-Then use READPREV to read records ...

Answer Question  Select Best Answer

How will you access the VSAM data sets?

rpg0247

 Profile Answers by rpg0247 Questions by rpg0247

• Jul 13th, 2011

After getting list of files just type below code before the vsam file

print ch ids(/)

siva9531

 Profile Answers by siva9531 Questions by siva9531

• Jun 17th, 2010

Print ch ids(/)

Answer Question  Select Best Answer

Jaypreeth

 Profile Answers by Jaypreeth Questions by Jaypreeth

• May 1st, 2011

All VSAM datasets are SMS managed. SMS managed datasets are cataloged. So while creating a vsam dataset using the IDCAMS utility the dataset is  cataloged.

Jaypreeth

 Profile Answers by Jaypreeth Questions by Jaypreeth

• May 1st, 2011

All VSAM datasets are SMS managed. So by the IDCAMS utility VSAM dataset is created which is cataloged..

Answer Question  Select Best Answer

nlarsensmith

 Profile Answers by nlarsensmith Questions by nlarsensmith

• Dec 1st, 2010

Best way is to choose small CI size for random access and large CI size for direct access. Without specifying CISZ the defaults will be 4096 for data and 1024 for index. Remember these sizes are obtai...

dhs01

 Profile Answers by dhs01 Questions by dhs01

• Apr 15th, 2009

1024 and 4096 are powers of 2. You could specify 1000 and 4000 but VSAM would actually use 1024 and 4096 although I'm not sure if the full 1024 would actually be available to you. Short answer is that since that is the number VSAM will use, 1000 or 4000 will not save you anything.  

Answer Question  Select Best Answer

nlarsensmith

 Profile Answers by nlarsensmith Questions by nlarsensmith

• Dec 1st, 2010

We can directly read a record from a flat file using Cobol READ command!If you want to load the flat file into a PS file use REPRO command in IDCAMS Util.If you want to load a flat file which was obta...

Shashank Gite

 Profile Answers by Shashank Gite Questions by Shashank Gite

• Jan 3rd, 2009

To retrieve record from flat file you can use IDCAMS utility with REPRO command and can copy the data into either a VSAM data set or another flat file

Answer Question  Select Best Answer

nlarsensmith

 Profile Answers by nlarsensmith Questions by nlarsensmith

• Dec 1st, 2010

These options are not corrolated!Spanned record : If a CI has not enough freespace to fit in a new record, then the record  is spanned to the next CI. If the next CI does not have enought freespa...

ambadiramesh

 Profile Answers by ambadiramesh Questions by ambadiramesh

• Feb 16th, 2010

It seems fine regarding CI split. CA split also occurs in the same as CI split. But remember these two concepts comes into the picture in case of KSDS only.Please let me know if you have any doubts.Regards,Ramesh.Ambadi.

Answer Question  Select Best Answer

nsk_sasi

 Profile Answers by nsk_sasi Questions by nsk_sasi

• Oct 19th, 2010

Friends, let me explain with an example:--EG:-Adding two numbersStep-1:- We need to compile that program and that compiled program(i.e Error free code) we need to keep in one Load Library (EG:-AB...

sunil

• May 21st, 2006

Prepare a RUNJCL and submit it.

Answer Question  Select Best Answer

How will you define a KSDS of avg length-100 and max length-150 and key length 10

Read Best Answer

Editorial / Best Answer

Yaswanth kodali  

 Profile Answers by Yaswanth kodali Questions by Yaswanth kodali

• Member Since Jul-2010 | Jul 12th, 2010

---

We can define the KSDS cluster by two ways by using the file-aid or by using the IDCAMS Utlity..

By using the IDCAMS utility we can define the record with average length 100 and maximum length 150 with keylength 10 starting at 0 as follows

//step01 EXEC pgm=IDCAMS
//SYSIN DD *

   DEFINE CLUSTER(NAME(userid.name.sample) -
                               VOLUMES(MVS801)              -
                               RECORDSIZE(100 150)        -
                               TRACKS(10 20)
                               KEYS(10 0)                          -
                               INDEXED  )                          -
                    DATA ( NAME(userid.name.sample.data))  -
                    INDEX( NAME(userid.name.sample.index)) -     
/*
// 

Yaswanth kodali

 Profile Answers by Yaswanth kodali Questions by Yaswanth kodali

• Jul 12th, 2010

We can define the KSDS cluster by two ways by using the file-aid or by using the IDCAMS Utlity..By using the IDCAMS utility we can define the record with average length 100 and maximum length 150 with...

Improve Answer