|
View previous topic :: View next topic
|
| Author |
Message |
manikumar_711
Currently Banned
New User
Joined: 11 Sep 2007
Posts: 7
Location: Chennai
|
|
|
|
Hi,
If anyone can explain how to load record from sequential file to DB2 database ? give me some solutions. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello manikumar_711 and welcome to the forums,
To do this you use a "load utility" or write code to insert the records.
If you talk with your peers or with your dba, they can tell you the proper way to do this on your system and they can provide the standard jcl to use on your system.
If you look in the forum, you will find some examples, but you should use what is standard for your system if you intend to actually run a load. |
|
| Back to top |
|
|
debajyoti2040
Currently Banned
New User
Joined: 25 May 2007
Posts: 4
Location: Bangalore
|
|
|
|
Hi,
If you are a COBOl programmer it's very easy , just Read from an Input File and Insert using dynamic SQL in your database table.
Else you can use an LOAD utility as well.
//DSNUPROC.SYSIN DD *
LOAD DATA INDDN(SYSREC) RESUME YES
INTO TABLE userid.tablename(
fieldname POSITION (1) datatype(datasize)
.................................................................
.................................................................
)
/*
//DSNUPROC.SYSREC DD DSN=<Input dataset name>,DISP=SHR |
|
| Back to top |
|
|
Richa Jain
New User
Joined: 18 Mar 2008
Posts: 35
Location: Gurgaon
|
|
|
|
Hi,
you can use FILD option 3.7.2 to load record from sequential file to DB2 database. |
|
| Back to top |
|
|
vicky11121982
New User
Joined: 21 Jun 2007
Posts: 9
Location: gurgaon
|
|
|
|
| U can alwaz do by BMC load/unload utility and if that is not there in your shop a simple easytrieve program will work |
|
| Back to top |
|
|
manikumar_711
Currently Banned
New User
Joined: 11 Sep 2007
Posts: 7
Location: Chennai
|
|
|
|
Hi Richa jain / dick sherrer
your answers is very nice. i have lot of questions. pls answer me.. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
As i mentioned before about loading a table:
| Quote: |
To do this you use a "load utility" or write code to insert the records.
If you talk with your peers or with your dba, they can tell you the proper way to do this on your system and they can provide the standard jcl to use on your system.
If you look in the forum, you will find some examples, but you should use what is standard for your system if you intend to actually run a load.
|
| Quote: |
your answers is very nice. i have lot of questions. pls answer me..
|
What are these questions? If they are new questions, each should begin a new topic. |
|
| Back to top |
|
|
|
|
