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
 

 

How to eliminate the Duplicate Records In a Table?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
naveensri2005
Currently Banned

New User


Joined: 22 Mar 2005
Posts: 51
Location: chennai

PostPosted: Mon Oct 03, 2005 8:13 pm    Post subject: How to eliminate the Duplicate Records In a Table?
Reply with quote

hi floks,

1. How to eliminate teh Duplicated Recors In a Table?
2. How many cursors are support for a Application Program?
3. suppose cursor is open once again u open that one what error will comes?



regards,
naveen
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Mon Oct 03, 2005 10:47 pm    Post subject: Re: How to eliminate the Duplicate Records In a Table?
Reply with quote

Quote:
1. How to eliminate teh Duplicated Recors In a Table?

Didn't you find this in SEARCH or you didnt make it at all....
http://www.ibmmainframes.com/viewtopic.php?t=650
http://www.ibmmainframes.com/viewtopic.php?t=2311

Quote:
3. suppose cursor is open once again u open that one what error will comes?

SQL CODE: -502

Regards,

Priyesh.
Back to top
View user's profile Send private message
naveensrimf

New User


Joined: 04 Oct 2005
Posts: 31

PostPosted: Tue Oct 04, 2005 4:42 pm    Post subject: hi priya
Reply with quote

hi priyesh.agrawal,

Why u r ban my Account Naveensri2005. I am not a miss use . I did n't send any unwanted material. Why my id is banned?
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Tue Oct 04, 2005 5:30 pm    Post subject: Re: How to eliminate the Duplicate Records In a Table?
Reply with quote

Hi Naveen,

Out of your 8 posts on 10/03/2005, 4 posts were simply repetittive queries. Which are easily available in Forum, If made a SEARCH.

Despite being asked regularly to make a search before posting, you just posted queries without any SEARCH. Isn't It ????

As you already carried TWO Wrnings earlier.....This time your ID got Banned....

Regards,

Priyesh.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


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