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
 

 

Duplicates allowed in TSQ..???

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
nprathap4u

New User


Joined: 24 Apr 2007
Posts: 15
Location: India

PostPosted: Wed Nov 28, 2007 8:02 pm    Post subject: Duplicates allowed in TSQ..???
Reply with quote

Will TSQ allow duplicate value if so how to handle it..?
Back to top
View user's profile Send private message

Earl

Active User


Joined: 17 Jun 2007
Posts: 148
Location: oklahoma

PostPosted: Wed Nov 28, 2007 8:20 pm    Post subject:
Reply with quote

yes, you can write the same data to a TSQ mulitple times. there is no way to prevent it other than creating your own logic. You might conisder
writing your data to a vsam file, rather than using TSQ
Back to top
View user's profile Send private message
nprathap4u

New User


Joined: 24 Apr 2007
Posts: 15
Location: India

PostPosted: Wed Nov 28, 2007 8:32 pm    Post subject:
Reply with quote

Thanks for your quick reply.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Thu Nov 29, 2007 1:14 am    Post subject:
Reply with quote

It's all in the fine manual. Pay attention to the REWRITE option.

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

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts Duplicate component install allowed i... kratos86 CA Products 2 Fri Oct 03, 2014 12:08 am
No new posts SORT CARD to remove duplicates & ... mkk157 DFSORT/ICETOOL 17 Tue Jul 08, 2014 9:04 pm
No new posts Remove the duplicates without sorting... maki_psg JCL & VSAM 13 Tue May 13, 2014 10:32 pm


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