05-11-2006 3:28 PM
hi,
i have a doubt in table creation in SE11. there is a check box for identifying if a field is a key field.
beside that another checkbox 'Init.' is there. what for is it?
how can i make a field mandatory while creating a table?
thanks in advance
05-11-2006 3:31 PM
Indicator that NOT NULL is forced for this field
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.
<b>Please note that fields in the database for which the this flag is not set can also be filled with initial values.</b>
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.
Message was edited by: Amandeep Singh
05-11-2006 3:31 PM
Hi,
If the field is declared as KEY, that is mandatory.
The second box, when clicked is the NOT NULL field. So, the field will become obligatory.
Regards,
Ravi
05-11-2006 3:33 PM
<b> Indicator that NOT NULL is forced for this field</b>
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.
regards
vinod
01-17-2007 1:18 PM
key is used to define the primary key type.
& init is used to define initial values range..
just follow the path like :: element>dbl click>domain>dbl click>value range
there if u specify the range..that will lead u to init key..
hope it is clear..
bye--
Pradeepa