Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Regarding DFSORT-TO AVOID A DUPLICATE KEY

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 107
Location: Hyderabad

PostPosted: Fri Oct 08, 2004 1:10 pm    Post subject: Regarding DFSORT-TO AVOID A DUPLICATE KEY
Reply with quote

Hi

I have doubt regarding DFSORT,let me explain clearly

i have record which has 5columns and columns are

A(1-5) B(5-10) C(10-15) D(20-15) E(25-30)

MY doubt is how can i avoid duplicate record and copying column A,B,C IN

another dataset by sorting in said positions(forget about sorting i had done it).

please help me

Thanks
ashwin
Back to top
View user's profile Send private message
References
PostPosted: Fri Oct 08, 2004 1:10 pm    Post subject: Re: Regarding DFSORT-TO AVOID A DUPLICATE KEY Reply with quote

anuradha

Global Moderator


Joined: 06 Jan 2004
Posts: 257

PostPosted: Fri Oct 08, 2004 1:51 pm    Post subject:
Reply with quote

Hi Ashwin,

IF you need to avoid the duplicates the you can specify the control statement as SUM FIELDS=NONE.

And you can rearrange fields and add any constants by using OUTREC option.

Thanks,
Anu
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 107
Location: Hyderabad

PostPosted: Tue Oct 12, 2004 12:41 pm    Post subject: regarding compling cobol-db2
Reply with quote

Hai anu

thanks for your reply and i have a doubt right from when entered in mainframes

go.sysin dd dsn=name

what does . indicates

please reply

thank u

ashwin
Back to top
View user's profile Send private message
anuradha

Global Moderator


Joined: 06 Jan 2004
Posts: 257

PostPosted: Tue Oct 12, 2004 2:07 pm    Post subject:
Reply with quote

Hi Ashwin,

I couldn't get you correctly.

Is that you mean to ask what for . in GO.SYSIN ?????

If you give Go.Sysin in the job that mean to say you are pointing to that particular step(GO).

We can't say gosysin,right!!!!!. So just to point to that particular we will say Go.SYSIN

I am still in doubt whether i answered your question or not?

Thanks,
Anu
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 107
Location: Hyderabad

PostPosted: Thu Oct 14, 2004 6:52 pm    Post subject: Rgrading cofirmation
Reply with quote

Thanks Anu

I think you are right.But i used to think (.)dot is used to transfer control from non-procedural language to propcedural language.

Bye
ashwin
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1