harimca,
I understand what you are saying that you will no longer get a value from the online screen so you wanted to comment that field.
Few things needs to be decided as which approach we are gonna take
to prevent the abend/SQL error.
1.But still the column in DB2 table is going to be there right , are you
planning to delete the cloumn too from the Table.
2. I do not think you are planning to delete the table , so best possible
thing to address the situation is have the field in your insert query
with deault value of spaces/zero initaised into that field, it should
prenvent the SQL ERROR.
What i was saying earlier is that if the column of table is defined
such that it should be NOT-NULL then there is no way that you
can have the column without any value.
So while defining the TABLE they also can DEFAULT a value
for NOT-NULL columns in the declaration itself i mean the DDL.
By DEFAULT i mean if no value is inserted thru the QUERY then
the column by default will get the DEFAULT value as declared
while creating the TABLE , so reg this i said you can check with
DBA if there is possibilty to re-visit the DDL and default the value
of the column and if that is done then you can comment the field
in your query.
But the best possible thing is i would suggest you to have the field
as part of query with SPACES/ZEROS as value for it.
I blive Dave is also suggesting the same.
I wish this clears you query. And sorry for a big description
P.S : And please i would request to post back your replies as what you
have decided and finally how it worked , this wil will help other
users if they come across same problem.
Thanks,
Veera.