db2 - COBOL program, JCL job, or both? -

I have to complete 3 tasks:
insert, delete, and write one

I'm sure Not that what is the best way to do this: My mainframe program design skills are not very tight, so I was looking for advice

Would I refrain from doing a COBOL program for this?
The way I see it, I just need JCL which executes the SQL statement. If I prepare my statements correctly, then they should be able to prepare 1 and 2 tasks in such a way. But I'm thinking that I might need to do a COBOL program to write in the file?

I will observe my thinking process for 3 tasks. Every task looks similar, but they ask for different results, so the SQL statements are very different. But they are all working in the same table.

Task 1:
-Serify the SF query - Enter a new row based on the query that raises the question for each line -

Task 2: - Query the SF query - For each row that raises the question - Delete the record

Task 3:
- Execute the SQL query - For each line that raises the question
- Write to that record

Not only with JCL, JCL (mostly) just causes the programs to execute. To be perfectly precise, JES demonstrates these actions because it explains JCL.

Now, you can avoid writing using an existing utility or set of utilities.

SyncSort, for example, can execute a selection statement and write results in a file.

DSNTEP4, for example, can execute the SQL statement in the batch that contains the daily, updates, and INSERT statements.

You can do it without > without executing a program , a cobol (or assembler, or PL / I, or C / C ++, Or rex etc.)