Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 290
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: 290
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 Extracting DDL for all list of intere... Ashishpanpaliya DB2 5 Mon May 21, 2018 4:08 pm
No new posts MXG - Processing Compressed DB2 SMF r... vasanthz All Other Mainframe Topics 2 Thu May 10, 2018 12:47 am
No new posts Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm
No new posts Searching a table for the field name? socker_dad COBOL Programming 8 Sat Mar 31, 2018 2:57 am
No new posts Merge 2 records sancraig16 SYNCSORT 19 Tue Mar 27, 2018 8:17 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us