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.
SystemAdmin 110000D4XK101 Posts
Re: Load data to DB22009-03-16T14:53:27ZThis is the accepted answer. This is the accepted answer.Hello,
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
Re: Load data to DB22009-06-24T12:53:49ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
There are plenty of connectors between DB2 and ETL tools. That could be a possibility even though this post IS old!