Load data from a flat file to db2 tables

sree reddy · New User Joined: 20 Jul 2007 Posts: 20 Location: bangalore

Hi,

I have file which has data with decimal points , i want to load it to db2 tables, can any one send me the jcl to work out with this.

Thanks

dick scherrer · Posted: Fri Jun 27, 2008 12:29 am Post subject:

Hello,

To know the correct way to do this on your system, you should ask some one who already loads db2 data from qsam files. You might also talk with your db2 support people.

There should be a standard way to load tables and your new process should use that standard.

If you are interested in seeing how others have done this, there are multiple topics on loading data in the forum.

debajyoti2040 · New User Joined: 25 May 2007 Posts: 5 Location: Bangalore

Hi,

The best way to load a DB2 table is using a LOAD utility.
Just add the following to the LOad utility JCl

//DSNUPROC.SYSIN DD *
LOAD DATA INDDN(SYSREC) RESUME YES
INTO TABLE userid.Tablename(
column1 POSITION (1) datatype(datasize),
column2 POSITION (n) datatype(datasize)
)
/*
//DSNUPROC.SYSREC DD DSN=<source dataset name>,Disp=SHR

Work this out definitely this will work

Regards,
Deb

RAHUL_PIONEER · New User Joined: 02 Jul 2008 Posts: 3 Location: hyderabad

Hi,
What is the difference between loading from flat file to table and loading
from sequential file to table in jcl.
Can anyone throw some light

PeD · Posted: Thu Jul 03, 2008 12:13 pm Post subject:

No difference.
"Flat file" is not a technical term.

dick scherrer · Posted: Thu Jul 03, 2008 7:22 pm Post subject:

Hello,

Said slightly differently, a sequential file is a flat file.

"Flat file" is just slang that caught on. . .