Size of a column has been changed in DB2 table (Suppose it
was of 5 characters and later changed to 4 characters) and
forgot to change the DCLGEN in COBOL program, what will
happen during the execution of code? If the program Abends
then what will be the error? If it doesn't abend then hpw
the error can be catched?

Answers were Sorted based on User's Feedback



Size of a column has been changed in DB2 table (Suppose it was of 5 characters and later changed t..

Answer / chitra

The program will get abended and the error will data
exception error.

Is This Answer Correct ?    1 Yes 0 No

Size of a column has been changed in DB2 table (Suppose it was of 5 characters and later changed t..

Answer / srikanth doki

The error will not be catched at that time. Dclgen will not
check the database tables and the dbrm will check the
database if it is not matched then the data exception error
will be raised at that time.

Is This Answer Correct ?    0 Yes 0 No

Size of a column has been changed in DB2 table (Suppose it was of 5 characters and later changed t..

Answer / suresh

The program will get abended and the error will data
exception error.

Is This Answer Correct ?    0 Yes 0 No

Size of a column has been changed in DB2 table (Suppose it was of 5 characters and later changed t..

Answer / ankit

it will work normally until the data fetched is of 4 bytes
but if it will be fetching a data of 5 bytes, then a
exception will occur and program will abend with abend code
SOC7.

Is This Answer Correct ?    0 Yes 1 No

Size of a column has been changed in DB2 table (Suppose it was of 5 characters and later changed t..

Answer / mohit

Nothing critical will happen.. I will make understand with
example below:

Consider some 2 bytes as * are before that variable as $
and then rest copybook as & , so after changing table
layout will look like:

**$$$$&&&&&& and program will layout as
**$$$$$&&&&&&. So, now what happens table always passes
something as 4 bytes to 5 bytes which easily is compatible
with a bigger space. So, you will see a space actually
which might disturb your output.

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More COBOL Interview Questions

can we use the two 01 level in file discription ?

6 Answers  


What happens in the background of spool when we submit a job for compilation and execution... This is a recent question in ibm...Kindly help me.....

3 Answers   IBM,


Consider the following COBOL entries: 05 X PIC 99 VALUE 10. SUBTRACT 20 FROM X. The resultant value of X wil be

7 Answers   TCS,


write a program to eliminate duplicate records in a input file and send them to output file.THIS IS IGATE RECENT QUESTIONN.....JUST 1 WEEK BACKKKK...

5 Answers   iGate,


What is the difference between structured cobol programming and object alternativelyiented cobol programming?

0 Answers  






In CICS/VSAM every file that is accessed should be defined in FCT. we have CICS READ, WRITE, BROWSE commands for VSAM files. How does it work with DB2 tables. It know it has to do with the plan. Please expain with examples.

1 Answers  


How do you set a return code to the JCL from a COBOL program?

4 Answers  


hw to create 3 dimensional array & hw to access it?

1 Answers  


after udatingg first 110 rows, my job abends. now how do i change my cobol program so that when i restart the Job it will start updating from 111th row ( i.e in next run I di=ont want to update those 110 rows which are already been updated in the first run before job abend)

7 Answers   Allianz, Wipro,


At the minimum, which division of COBOL is enough to be coded?

3 Answers   CTS,


How many divisions we have in Cobol ?

4 Answers   Wipro,


whn do i get soc7 abend while moving alphanumeric to numeric or while moving numeric to aplhanumeric please reply ASAP?

9 Answers  


Categories