Re: nullable primary key index column?

2016-02-02 Thread Suresh Subbiah
Hi, Hope I did not misunderstand the question. A table can have more than one column in its key to be nullable, as long as the cqd Anoop gave is set. All columns in the key can be nullable too. If the first column is nullable and there are other key columns that are either nullable or

RE: nullable primary key index column?

2016-02-02 Thread Eric Owhadi
Birdsall [mailto:dave.birds...@esgyn.com] *Sent:* Tuesday, February 2, 2016 1:51 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: nullable primary key index column? Hi Eric, Just curious: What is your use case? Why do you need a nullable primary key column? Dave *From:* Eric Owhadi

RE: nullable primary key index column?

2016-02-02 Thread Dave Birdsall
Hi Eric, Just curious: What is your use case? Why do you need a nullable primary key column? Dave *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 11:43 AM *To:* user@trafodion.incubator.apache.org *Subject:* RE: nullable primary key index column

RE: nullable primary key index column?

2016-02-02 Thread Eric Owhadi
@trafodion.incubator.apache.org *Subject:* RE: nullable primary key index column? cqd ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT ‘ON’; then create table with nullable pkey col. only one null value is allowed. *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 11

RE: nullable primary key index column?

2016-02-02 Thread Eric Owhadi
2, 2016 2:14 PM *To:* user@trafodion.incubator.apache.org *Subject:* Re: nullable primary key index column? Hi, Hope I did not misunderstand the question. A table can have more than one column in its key to be nullable, as long as the cqd Anoop gave is set. All columns in the key can

Re: nullable primary key index column?

2016-02-02 Thread Suresh Subbiah
com] > *Sent:* Tuesday, February 2, 2016 2:14 PM > *To:* user@trafodion.incubator.apache.org > *Subject:* Re: nullable primary key index column? > > > > Hi, > > > > Hope I did not misunderstand the question. > > > > A table can have more than on