Load the PS data into DB2 tables

[kimi]

Hi ppl,
The requirement is to load a table from a dataset which
has data in comma separated format.The data in the PS file looks
something like this...

A001,"KARNATAKA ",908345,"ALPHA"
B001,"ANDHRA PRADESH",903784,"BETA"
The platform on which i am using is IBM mainframe Z/OS V1R.
The DB2 version is 7.1
Can anyone provide me with the JCL which can do this loading ...
Pls mention where i have to make changes and to what in order to run
the JCL

[dotyet]

I don't know how you do it in JCL but on DB2 UDB (LUW).... you can do
something like:

db2 promptload from <datafile>.txt of del modified by coldel,
modified by chardel" insert into <tablename;

maybe you can find some information on the db2 information center
website.

http://publib.boulder.ibm.com/infoce...help/index.jsp

regards,
dotyet

On Jun 12, 5:58 am, kimi <[e-mail]:

Hi ppl,
The requirement is to load a table from a dataset which
has data in comma separated format.The data in the PS file looks
something like this...

A001,"KARNATAKA ",908345,"ALPHA"
B001,"ANDHRA PRADESH",903784,"BETA"

The platform on which i am using is IBM mainframe Z/OS V1R.
The DB2 version is 7.1

Can anyone provide me with the JCL which can do this loading ...
Pls mention where i have to make changes and to what in order to run
the JCL