Data Dictionary-Primary keys

[Former Member]

Hi All,

I have a question regarding creating primary keys in Ztables.

When I designate a field as Primary Key, It is accepting NULLs as inputs.Which is contradicting Primary key constraint. How should I enforce primary key constraint.

[Former Member]

Please check the both check boxex in that field.

that is KEY and INITIAL check boxes.

[Former Member]

Even though the Key And Intitial coumn has been set, while entering values in table the field is still accepting Null values.

for eg- Num (char10/Or any DE attached),

Name (Char 20). If enter records like

(<blank>, krishna),

(10, chaiyanya).

the PK field is also accepting blank values r if not entered anything also its accepting.

But this is not the case in any RDBMS. PK (Not Null and unique) is maintained.

How to go about it.

[Former Member]

Select the Key column if the field should be part of the table key

[Former Member]

Even though the Key And Intitial coumn has been set, while entering values in table the field is still accepting Null values.

for eg- Num (char10/Or any DE attached),

Name (Char 20). If enter records like

(<blank>, krishna),

(10, chaiyanya).

the PK field is also accepting blank values r if not entered anything also its accepting.

But this is not the case in any RDBMS. PK (Not Null and unique) is maintained.

How to go about it.