Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Inserting data in db2 table from a file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
santosh100678

New User


Joined: 21 Sep 2009
Posts: 55
Location: Kolkatta

PostPosted: Wed Nov 25, 2009 6:24 pm    Post subject: Inserting data in db2 table from a file
Reply with quote

Hi ,

I have requirement that insert data from flat file to db2 table where in flat file their is na number of column suppose 10 filed column but i don;ta know what is the name of each field column and if suppose details of column are name rollnumber qualification idetity number and so on ,
so my requirement is insert data in db2 table columna in specific manner but in flat file it is not field align.
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Nov 25, 2009 6:44 pm    Post subject:
Reply with quote

Hello Santosh,

PLease refer the manual for LOad utility. Let us know if you find any problem.
Back to top
View user's profile Send private message
santosh100678

New User


Joined: 21 Sep 2009
Posts: 55
Location: Kolkatta

PostPosted: Thu Nov 26, 2009 6:23 pm    Post subject: Reply to: Inserting data in db2 table from a file
Reply with quote

Hi,

I have to insert data throu cobol program not jcl could you please proide me example

for ex :
Input file structure is File1:

Satish B.E M.B.A. Mainframe 12345678 34567688 789099 India
aparna B.E M.C.A Mainframe 12345689 34567698 789079 India

I want to write throu cobol program where File is my input i want insert this data in db2 table by cobol program but i do;t kno the column name specificvation in my input file
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Thu Nov 26, 2009 7:02 pm    Post subject:
Reply with quote

Quote:
I want to write throu cobol program where File is my input i want insert this data in db2 table by cobol program but i do;t kno the column name specificvation in my input file


well, since you are obviously a novice coder and not a programmer,
you need to ask someone who knows something about computers
to give you a layout of the input file.
And remind him that you have no initiative, little or no logic ability and
don't really want to think about your tasks or do a little research.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2433
Location: Netherlands, Amstelveen

PostPosted: Thu Nov 26, 2009 7:11 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
Quote:
I want to write throu cobol program where File is my input i want insert this data in db2 table by cobol program but i do;t kno the column name specificvation in my input file


well, since you are obviously a novice coder and not a programmer,
you need to ask someone who knows something about computers
to give you a layout of the input file.
And remind him that you have no initiative, little or no logic ability and
don't really want to think about your tasks or do a little research.


Is that what a Senior software enginear is : a novice coder?

(enginear worded in his profile)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Nov 26, 2009 11:26 pm    Post subject: Reply to: Inserting data in db2 table from a file
Reply with quote

Hello,

Looks like another homework assignment. . .

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us