Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

initial value ?

Former Member
0 Kudos

hello friends..

in se11, while creating a table,in particularly while creating the fields..

there are 2 check buttons

1. key --this is to specify the primary key fields

2. initial value -- whats it purpose ?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

The initial value check box is an Indicator to ensure that NOT NULL is forced for this field .

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Regards,

Sowmya.

7 REPLIES 7

former_member181962
Active Contributor
0 Kudos

HI Selva,

Press F1 on that field. It is nicely explained.

Regards,

Ravi

Former Member
0 Kudos

Hi, Go through this Doc:

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Please note that fields in the database for which the this flag is not set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT NULL and filled with an initial value. The same applies when converting the table. Only when new fields are added or inserted, are these filled with initial values. An exception is key fields. These are always filled automatically with initial values.

Restrictions and notes:

The initial value cannot be set for fields of data types LCHR, LRAW, and RAW. If the field length is greater than 32, the initial flag cannot be set for fields of data type NUMC.

If a new field is inserted in the table and the initial flag is set, the complete table is scanned on activation and an UPDATE is made to the new field. This can be very time-consuming.

If the initial flag is set for an included structure, this means that the attributes from the structure are transferred. That is, exactly those fields which are marked as initial in the definition have this attribute in the table as well.

Regards,

Anji

former_member583013
Active Contributor
0 Kudos

> 2. initial value -- whats it purpose ?

It's use to have a value in the table when you create new entries.

Greetings,

Blag.

Former Member
0 Kudos

Hi,

Initial value means, lets say you have 3 Primary keys and you selected this check box(Initial value) for those 3 values, if enter only 2 Primary key values and save the row, then the third onw will be filled with Default value (If it is a Charecter then it will be filled by Zero's, if it Numc then Zero's if it is date then it will be filled by 00000000)

Regards

Sudheer

Former Member
0 Kudos

Hi,

The initial value check box is an Indicator to ensure that NOT NULL is forced for this field .

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Regards,

Sowmya.

0 Kudos

thanx sowmya mam

Former Member
0 Kudos

hi

good

key-If you select this indicator the field is flagged as a key field.

The key fields of a table must be located together at the beginning of the table, that is, no non-key fields are allowed between two key fields.

Initial Value->

Use

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Please note that fields in the database for which the this flag is not set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT NULL and filled with an initial value. The same applies when converting the table. Only when new fields are added or inserted, are these filled with initial values. An exception is key fields. These are always filled automatically with initial values.

Restrictions and notes:

The initial value cannot be set for fields of data types LCHR, LRAW, and RAW. If the field length is greater than 32, the initial flag cannot be set for fields of data type NUMC.

If a new field is inserted in the table and the initial flag is set, the complete table is scanned on activation and an UPDATE is made to the new field. This can be very time-consuming.

If the initial flag is set for an included structure, this means that the attributes from the structure are transferred. That is, exactly those fields which are marked as initial in the definition have this attribute in the table as well.

thanks

mrutyun^