|
View previous topic :: View next topic
|
| Author |
Message |
ramankapoor
New User
Joined: 27 Feb 2006
Posts: 23
Location: delhi
|
|
|
|
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 |
|
 |
martin9
Active User
Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland
|
|
|
|
hy ramankapoor,
what kind of table do you mention?
can you provide some more details...
martin9 |
|
| Back to top |
|
|
ramankapoor
New User
Joined: 27 Feb 2006
Posts: 23
Location: delhi
|
|
|
|
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 |
|
|
martin9
Active User
Joined: 01 Mar 2006
Posts: 290
Location: Basel, Switzerland
|
|
|
|
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 |
|
|
ramankapoor
New User
Joined: 27 Feb 2006
Posts: 23
Location: delhi
|
|
|
|
| ok i will try with this option and let u know if i got any problem |
|
| Back to top |
|
|
|
|
