Table Create Question

[spanky1968]

OK, I have an easy one for somebody out there. I am creating a table and I would like to assign one of the fields as the primary key.

Table create example:

db2 -v "create table temp_table(ID varchar(6), date timestamp(30), acct_total decimal(9), cust_total decimal(9), txn_total decimal(9))"

I would like to assign the date field as the primary key but I am unsure how to do this, can you help?

Thanks in advance.

[sakumar9]

You can try this command:

CREATE TABLE TEMP_TABLE 
  ( ID VARCHAR (10) ,
  DATE TIMESTAMP  NOT NULL , 
  ACCT_TOTAL DECIMAL (5, 0) , 
  CST_TOTAL DECIMAL (5, 0) , 
  TXN_TOTAL DECIMAL (5, 0), 
  CONSTRAINT CC1203569699406 PRIMARY KEY ( DATE)  ) ;
 

Regards
-- Sanjay

[ricka49]

Create Table Gwc.cl_clm_fil_catg_type
(fil_catg_typcd Char(4) For Sbcs Data Not Null,
Fil_catg_type_desc Char(50) For Sbcs Data Not Null,
Last_chng_userid Char(8) For Sbcs Data Not Null,
Last_chng_timstm Timestamp Not Null,
Constraint Xpkclaim_filing_category_type
Primary Key (fil_catg_typcd))
In Cl.clcattyp
Audit None
Data Capture None
Ccsid Ebcdic
Not Volatile;

[spanky1968]

Thank you it worked great.