IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Regarding DFSORT-TO AVOID A DUPLICATE KEY


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Fri Oct 08, 2004 1:10 pm
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
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Fri Oct 08, 2004 1:51 pm
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: 106
Location: Hyderabad

PostPosted: Tue Oct 12, 2004 12:41 pm
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

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Tue Oct 12, 2004 2:07 pm
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: 106
Location: Hyderabad

PostPosted: Thu Oct 14, 2004 6:52 pm
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Duplicate transid's declared using CEDA CICS 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
Search our Forums:

Back to Top