Reading a file and inserting data into a table

This is a Mainframe COBOL forum - you can post your queries on Mainframe COBOL, VS COBOL II, COBOL/370 , Enterprise COBOL

Moderators: dbzTHEdinosauer, Moderator Group

Post Reply
Salman
Member
Posts: 6
Joined: Sun Sep 08, 2013 2:20 pm

Reading a file and inserting data into a table

Post by Salman » Sun Sep 08, 2013 2:42 pm

Hi Team,
It would be very grateful of you if help me out in fixing the my below query.
Requirement : Reading a PS file and inserting all the records into a DB2 table.
My table structure :

08 Stu-Record occurrs 15 times
10 stu-name pic x(10)
10 stu address pic x(20)
.
.
.
Here am fine with opening,reading a input file and loading the first record.

But where am stuck is to read the record line by line till end and inserting everytime.
And my difficulty is my copy book has occurs clause.,
For example :

Say, i need to insert a record into a address fileld
10 Address PIc x(20)
and i have address as

st.anns street
halifax
hx1 2rg
UK
.
.
.
.
.

I believe we need to use a PERFORM- Varying.

I googled but couldn't find my solution.
As am beginner, I request to provide a code for this Logic.

Thanks in Advance.

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Sun Sep 08, 2013 3:37 pm

Look up READ/AT END in the language reference. Get yourelf almost any book on COBOL which will show how to read through a file and write records.
Regards
Nic

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Tue Sep 10, 2013 12:18 am

Your DB2 table doesn't really have an occurrs - does it?
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others