Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ 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
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    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

anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

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: 106
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

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

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: 106
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Display ZEDLMSG without Pressing F1 &... anandgbe CLIST & REXX 8 Thu Dec 15, 2016 4:20 pm
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to get the remainder and quotient... vnktrrd DFSORT/ICETOOL 2 Mon Oct 31, 2016 10:59 am
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts DFSORT sorting only specific records akodakka DFSORT/ICETOOL 4 Thu Aug 04, 2016 11:24 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us