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

How to eliminate the Duplicate Records In a Table?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 1448
Location: Chicago, IL

PostPosted: Mon Oct 03, 2005 10:47 pm
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: 34

PostPosted: Tue Oct 04, 2005 4:42 pm
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: 1448
Location: Chicago, IL

PostPosted: Tue Oct 04, 2005 5:30 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Duplicate transid's declared using CEDA CICS 3
No new posts Compare only first records of the fil... SYNCSORT 7
Search our Forums:

Back to Top