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

What is SDSF?

13 Answers   IBM,


can u give result for the fallowing example... 05 a pic 9(2) 05 b redifines a pic x(2). move 'xy' to b. display a,b.

10 Answers   IBM,


How can we pass data from cobol to JCl?

7 Answers   ADP, Amdocs, IBM,


I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?

0 Answers   HCL,


file status 00 is checked after opening the file or reading the file

4 Answers   John Deere,






what is the difference between Normal vaiable and comp variable.

5 Answers   DELL,


Can you please let me know the centre name of INS certification in Kolkata.

0 Answers  


Can you REWRITE a record in an ESDS file? Can you DELETE a record from it?

6 Answers   ABC, IBM, Mphasis, Wipro,


How to delete leading spaces/blank in COBOL ? Example:- 01 data-name-1 pic x(220) " English is a language". I would like to delete leading spaces.

7 Answers   Financial Services,


How to read records which is in sequential file in reverse order ? Exp. 1 2 3 4 5 . i want 5 4 3 2 1?please clear my doubt any one

10 Answers   IBM,


What is the difference between a subscript and an index in a table definition?

3 Answers   TCS,


what is index and how to use two tables using index?

1 Answers  


Categories