Hi, can any one tell about " How do u eliminate the duplicates "

Hi, can any one tell about " How do u eliminate the
duplicates "

Question Posted / pandu

2 Answers
6423 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi, can any one tell about " How do u eliminate the duplicates "..

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

Hi, can any one tell about " How do u eliminate the duplicates "..

Answer / rammateti

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

Post New Answer

More JCL Interview Questions

using cursor how can you fetch more than one record into a variable

3 Answers Syntel,

How to view the hexa decimal value thru file aid if copy book is not present for that particular data

1 Answers

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.

2 Answers Cap Gemini,

HOw to submit a job from other user id.? for exp some other job name like "t4622sdx".now i want to submit that job from my user id?(we don't know that location at all Just we know job name)

1 Answers MSN Pharma, UST,

Can we able insert data into a PS file Using IEBUPDTE utility??? If Yes can anyone describe it please..

1 Answers

I have a JCL with 10 steps, want to execute first 5 steps only, what are ways of doing it?is it possible to control through JOB card?

5 Answers iGate,

What are the difference between jcl and jes?

0 Answers

Can I share my data with other jobs? How?

0 Answers

What is the difference between specifying DISP=OLD and DISP=SHR for a dataset?

2 Answers

write a jcl to execute a job by 7:00 am on jan 20,1986?