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
 

 

Can I Split The records from one table to other through JCL

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

New User


Joined: 27 Feb 2006
Posts: 23
Location: delhi

PostPosted: Tue Mar 14, 2006 3:30 pm    Post subject: Can I Split The records from one table to other through JCL
Reply with quote

I have one table with some data in it. i want to split that data into different tables on the basis of certain conditions ,Through Cobol Program it can be easily done.

Can I Do this just with the help of JCL.

Please Suggest ?
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Tue Mar 14, 2006 4:29 pm    Post subject:
Reply with quote

hy ramankapoor,

what kind of table do you mention?
can you provide some more details...

martin9
Back to top
View user's profile Send private message
ramankapoor

New User


Joined: 27 Feb 2006
Posts: 23
Location: delhi

PostPosted: Tue Mar 14, 2006 4:35 pm    Post subject:
Reply with quote

Its a DB2 Table . I have the records in DB2 Table like Table A.

What my requirement is : to get some records from Table A and put it In Table B and Table C on the basis of any condition through JCL.

If It can be done ,How can I put the condition In the JCL ?
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Tue Mar 14, 2006 4:44 pm    Post subject:
Reply with quote

hy ramankapoor,

you can make a db2 query in batch thru DSNTIAUL, for example.
make a query which inserts tableB upon specific data from tableA,
you will need a proper where clause on tableA.
now you can do the same with tableC.

i think this is easier than making this dependable on any
condition code given thru jcl, because in the query
you define the needed conditions already (where clause).

martin9
Back to top
View user's profile Send private message
ramankapoor

New User


Joined: 27 Feb 2006
Posts: 23
Location: delhi

PostPosted: Tue Mar 14, 2006 4:54 pm    Post subject:
Reply with quote

ok i will try with this option and let u know if i got any problem
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