topic Re: Data Dictionary-Primary keys in Application Development and Automation Discussions

Data Dictionary-Primary keys

Former Member — Wed, 06 Feb 2008 14:13:31 GMT

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.

Re: Data Dictionary-Primary keys

Former Member — Wed, 06 Feb 2008 14:18:52 GMT

Please check the both check boxex in that field.

that is KEY and INITIAL check boxes.

Re: Data Dictionary-Primary keys

Former Member — Wed, 06 Feb 2008 14:21:42 GMT

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

Re: Data Dictionary-Primary keys

Former Member — Wed, 06 Feb 2008 15:38:54 GMT

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.

Re: Data Dictionary-Primary keys

Former Member — Wed, 06 Feb 2008 15:39:28 GMT

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.