A new column getting added to a table?

ajaypmenon · Posted: Tue Dec 16, 2008 6:58 pm

Hi,
I have an interview question which i am not able to try out. I would really appreciate if somebody can help me on this.
I have a cobol program in which i am fetching rows from a table. this program is currently running in production. someone added a new column to the table. But this program for some reason was missed out. It was not recompiled. Will this program abend the next time it runs?

thanks in advance,
ajay

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

It depends on your code :

1) Its always told to code all the column names in a select query instead of '*'. If you have used '*' in your query then you code wil surely abend as there will be no new host variable to hold the new column values.

2) If your code has nothing to do with your new column, then your code should work fine without being recompiled.

Do let me know, if I am missing anything.
Thanks,
-Kapil.

ajaypmenon · Posted: Tue Dec 16, 2008 7:16 pm

Hi Kapil,
This was exactly what i am looking for. I really appreciate it. Thanks a lot for the help.

Thanks,
Ajay