how to concatenate datasets
Answers were Sorted based on User's Feedback
Answer / pkb
It is possible to process more than one data set as a single data set by concatenating the DD statements.
//QSAM0080 DD DSN=SIMOTIME.DATA.FILE0001,DISP=SHR
// DD DSN=SIMOTIME.DATA.FILE0002,DISP=SHR
// DD DSN=SIMOTIME.DATA.FILE0003,DISP=SHR
The following is an example of a COBOL SELECT statement.
here the COBOL program will read QSAM0080 and the DD statements will map the three files (FILE0001, FILE0002 and FILE0003) as one file. The program's initial read will get the first record from FILE0001 and will not get an End-of-File condition until the last record of FILE0003 is processed.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / suputhru
concatenation is possible up to 16 pds or 255 ps
We can cancatinating diffent files by giving their DSN one after other, all the datasets must be same type.
rules: there should be logical record length must be same
and type recfm is also same
//jobcard
//step1 exec pgm=concat11
//ddname DD dsn=tst.punna.cobol,
// DD dsn=tst.punna.cobol1,
// DD dsn=tst.punna.cobol11,
// DD dsn=tst.punna.cobol211,
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chowdary
concatenation is possible up to 16 pds or 255 ps
rules: there should be logical record length must be same
and type recfm is also same
//jobcard
//joblib
//dd dsn=tst.punna.cobol,
dsn=tst.punna.cobol1,
like that we need to give up to our requirement
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / shankar
we can also concatenate through disp keyword parameter also..
use iebcopy utility and
sysut1 dd dsn=sample1.pds,disp=(old,pass)
sysut2 dd dsn=sample2.pds,disp=(shr)
sysin dd *
copy indd=sysut1 outdd=sysut2
/*
Is This Answer Correct ? | 3 Yes | 3 No |
How to exclude the duplicate records from two concateded flat files (records from both files must be removed)?
How many steps we can overide in the proc's?
Passing a variable parm from JCL to a cobol/db2 program
how to skip the steps in JCl
Can a temporary dataset be converted to permanent dataset and vice-versa in the middle of a job ?
can we modify the code in copy book? if it possible how to submit ofter the modification.
We are aware of eliminating the duplicate records from outyput fiel using sort utility. Can we get the duplicate records in to another file in the Same sort utility?
Where & How Do You Code Identifier In Jcl?
What is the difference between joblib and jcllib statements
what is a null indicator in db2?
What is a Proc ? why do we go for a Proc ? What are the types of procs?Can we have nesting in Procs ?
What is Uncatalog dataset? How can we access/use them?