Read a flat file and update DB2 table

Blackjarvis · New User Joined: 12 Jul 2022 Posts: 1 Location: Italy

Hi
I'm new to this 'world' and I'm trying to learn something about Mainframes in general.
I'm looking for an 'how to' guide to Read a flat file and then make a query with the data i just Read.

In example

01929,0000,00000,000
.
.

Is a single row given by the input file.
I have multiple rows in it.

Now, i know i have to Read the file once rows at a time, but how to repeat the query n-Times where n-Times is the number of rows, and each time with different input?

Thanks

sergeyken · Posted: Mon Jul 18, 2022 12:22 am

There are 1000+ different tools available to perform this task.
The only exceptions from that list are: JCL, and VSAM.

How do you plan to work with your DB2?

Rohit Umarjikar · Posted: Mon Jul 18, 2022 5:13 am

Write a cobol Db2 program