Hi, can any one tell about " How do u eliminate the
duplicates "
- 2 Answers
- 5428 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhaskar reddy
//Sysin dd *
sort fields=(1,5,ch,A)
sum fields= none
/*
//
if u want all dupli.in one file u can use
//Sysin dd *
sort fields=(1,5,ch,A)
sum fields =none, xsum
/*
//
XSUM is the output file name. all duplicate records moved to
this file
| Is This Answer Correct ? | 8 Yes | 1 No |
By using DFSORT we can eliminate the duplicates
//Sysin dd *
sort fields=(1,5,ch,A)
sum fields=
/*
//
in the above dfsort we use sum fields= empty then it
eliminate the duplicates
if u want all dupli.in one file u can use
sum fields = xsum........
by (prathap)
| Is This Answer Correct ? | 2 Yes | 2 No |
How to submit multiple jobs. These jobs are members in PDS. The second job should run if the first job runs successfully and so on.
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above. 1 What is the maximum number of tables that can be stored on a Partitioned Table Space ? 1 what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names Accenture 5 Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code? 6 When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing? 2 how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE IBM 7 max number of columns in a db2 table? 6 What is package versioning? Please give an example. 1 What is the picture clause of the null indicator variable? 6 How do you filter out the rows retrieved from a Db2 table ? 1 What is DB2 (IBM Database 2)? 3 Can any one tell me about Restart logic in DB2.
SORT card to eliminate duplicity.
How to pass values in jcl to cobol?
what are the symbolic parameters? why do we use symbolic parameters ?
2 Answers IBM, TCS, UST, Xansa,
Explain about LMPUT-
how to have variable length record in outrec..i have the requmt as follows.. i/p file variable lenght record output file : i need to alter the input and write into outrec(another file) sort fields: copy from(dd1) using ctl1 ctl1cntl dd * outfil fnames=xxx, outrec=(1,131) here i outrec is bombing with error..how to overcome this defect...???
how to identify a vasam dataset by seeing in 3.4(browse)
Whats error code s222?
How is a type of file defined in the jcl that executes the cobol program?
how to convert fb to vb in jcl ?
Brief description of inline procedure of jcl.
COBOL 
