multiple table access in COBOL

[katbar]

This may be a silly, newby question but I am tasked with writing some COBOL code with which I am not very familiar with (fairly new to cobol and won't be on this team long!). The code I have to write entails updating the same SQL Server table for 2 different years and not sure how to write the code for this. I can't seem to find good examples. Do I have 2 seperate cursors open at the same time or am I forced to process them one entire cursor at a time? I basically want two copied of the same table
thanks!

 

[papadba]

Suggest you process one year at a time and not try to work with them concurrently in the code.

Possibly , i misunderstand what you want to do . . .

 

[katbar]

Yes, I understand that this is preferable but is it possible syntactically?
Thanks!

 

[delta403]

This can be done by two way:
1. Please check on the below link

http://mainframealldtime.wordpress.com/2012/05/01/positioned-update-in-db2/

or,
2. develop a store procedure or sub program and call the sub program with different year value.

Please let me know if you have any question.

 

[katbar]

If I am to interpret this correctly, if I declare 2 cursors (using alias) for the same table, different years and FETCH them into different working storage areas, I should be OK. They should keep separate references. Thanks for your time!

 

[papadba]

Yes, what you propose can be made to work . . .

If this is other than a one-time process, suggest you write the "main" part of the code to "drive" a subprogram or stored procedure to actually do the work.

This way there is no duplication of the code and it will be less work if there needs to be a third year one day.