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 Split files upto certain limit based ... bubbu75 DFSORT/ICETOOL 5 Tue Nov 14, 2017 11:11 pm
No new posts Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm
No new posts Matching and unmatched records!! Vignesh Sid SYNCSORT 3 Thu Nov 09, 2017 11:22 am
No new posts Formatting multiple records to a sing... Vignesh Sid SYNCSORT 3 Tue Nov 07, 2017 12:22 pm
No new posts Format Last Record differently from r... Learncoholic DFSORT/ICETOOL 5 Tue Oct 24, 2017 12:01 pm

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