Table field attribute - nullable

[Former Member]

Hi gurus!!

We have a problem with an attribute of a table field.

When we create a table field, depending on the data type we specifiy (CHAR, RAW, NUMC...) the system indicates the nullable attribute to YES or NO.

We don't know if the nullable attribute depends of the data type and if we can change the value of this attribute from SAP.

We see the nullable attribute value directly from DB2 console.

We would like to change this value from SAP, we don't know if we must do something when we create the table field...

Thank you very much in advanced,

Edorta

[Former Member]

The initial value cannot be set for fields of data types LCHR, LRAW, and RAW; for all others types switch on/off the column 'Initial Value' when maintaining the table definition (transaction SE11).

Regards,

John.

[Former Member]

Hi Edorta.

I suggest, This issue needs to be taken great interest and research.

To initiate, I suggest.

We must must not include any default values as they may lead to nullablility.

By Java, maybe Webdypro integration this problem can be tackled.

I am still researching on this problem you are facing.

Regards Harsh

[Former Member]

The finally found a solution to this issue,

When you enter in change mode to se11 to create a new field, you must insert into ok-code the null value.

This action allows a new flag in the properties of the field wich assign the null value to the fields.

Unfortunatelly, this option is only valid for new fields, no valid for already created fields.

I hope this helps somebody.

Edorta.