Specifying KDB key columns to be non-null ...

Community Support
1

Hi,How can I specify a KDB table’s DDL so that its key columns are NOTNULL?E.g.s) CREATE TABLE Security_Px ( securityId VARCHAR(*) primary key, //NOT NULL? pxSource VARCHAR(*) primary key, //NOT NULL? securityIdType VARCHAR(*), quoteConvention VARCHAR(*), productType VARCHAR(*), bidPx float, offerPx float, bidSpread float, offerSpread float, bidYield float, offerYield float, benchmarkId varchar(*), benchmarkIdType varchar(*), ownerId varchar(*), soeOwnerId varchar(*), account varchar(*), status varchar(*) );

2

no. and you should not need that as you can validate the insertions beforeh=
and.

2010/12/21 ben.cotton@citigroup.com <ben.cotton>:
> Hi,
>
> How can I specify a KDB table’s DDL so that =A0its key columns are NOT
> NULL?
>
> E.g.
>
> s) CREATE TABLE Security_Px
> =A0(
> =A0 =A0 =A0 =A0securityId =A0 =A0 =A0 =A0 =A0VARCHAR() primary key, //NO=
T NULL?
> =A0 =A0 =A0 =A0pxSource =A0 =A0 =A0 =A0 =A0 =A0VARCHAR() primary key, //=
NOT NULL?
> =A0 =A0 =A0 =A0securityIdType =A0 =A0 =A0VARCHAR(),
> =A0 =A0 =A0 =A0quoteConvention =A0 =A0 VARCHAR(),
> =A0 =A0 =A0 =A0productType =A0 =A0 =A0 =A0 VARCHAR(),
> =A0 =A0 =A0 =A0bidPx =A0 =A0 =A0 =A0 =A0 =A0 =A0 float,
> =A0 =A0 =A0 =A0offerPx =A0 =A0 =A0 =A0 =A0 =A0 float,
> =A0 =A0 =A0 =A0bidSpread =A0 =A0 =A0 =A0 =A0 float,
> =A0 =A0 =A0 =A0offerSpread =A0 =A0 =A0 =A0 float,
> =A0 =A0 =A0 =A0bidYield =A0 =A0 =A0 =A0 =A0 =A0float,
> =A0 =A0 =A0 =A0offerYield =A0 =A0 =A0 =A0 =A0float,
> =A0 =A0 =A0 benchmarkId =A0 =A0 =A0 =A0 varchar(),
> =A0 =A0 =A0 benchmarkIdType =A0 =A0 varchar(),
> =A0 =A0 =A0 ownerId =A0 =A0 =A0 =A0 =A0 =A0 varchar(),
> =A0 =A0 =A0 soeOwnerId =A0 =A0 =A0 =A0 =A0varchar(),
> =A0 =A0 =A0account =A0 =A0 =A0 =A0 =A0 =A0 varchar(),
> =A0 =A0 =A0status =A0 =A0 =A0 =A0 =A0 =A0 =A0varchar(*)
> =A0 =A0 );
>
> –
>

Submitted via Google Groups</ben.cotton>