this may not b exactly in db2.
juz i need a logic in COBOL.
My screen displays 2 columns. I wanted to display another column inbetween 2 colums. this is a kind of report which is displayed on he screen, by fetching from Db2.
Pls help me on a gud logic, as how i need to adjust the columns.
Anyway... it depends where the output is going exactly... If it is generating an output dataset, then you need to adjust the length of O/p file with fetching of new column and writing along with old fields.
If the output is going to On-Line Screens... Then it'll involve changes to On-line section too, as it'ld change appearance of the screen too.