How can I load data from a member in TSO to a DB2 table?
I would like to load the data saved in a member and using a JOB or other tool load this data into a DB2 table. Or may be using another method, the fact is that I want to load a large amount of data into a DB2 table.
This topic has been locked.
2 replies Latest Post - 2009-06-24T12:53:49Z by Taldgru
Pinned topic Load data to DB2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-06-24T12:53:49Z at 2009-06-24T12:53:49Z by Taldgru
SystemAdmin 110000D4XK101 PostsACCEPTED ANSWER
Re: Load data to DB22009-03-16T14:53:27Z in response to cabrerachaparroHello,
Unless I am missing something, all you need is the LOAD utility. You can specify the record layout of the source data and the corresponding table columns. The following link is for the v8.1 manual but LOAD has not changed much recently.
If the link doesn't work, just find a Utility Guide and Reference for the DB2 version that you are using and look for the chapter on LOAD.
I would try to give you some sample JCL but it can be fairly dependant on some local configuration of the proc library etc.
I know it's probably been so long that you no longer need the answer.
Taldgru 270002BY5E1 Post