Click here to Skip to main content
14,833,054 members
Home / Discussions / Database
   

Database

 
AnswerRe: Inner Query in mysql Pin
Simon_Whale8-Aug-11 2:49
professionalSimon_Whale8-Aug-11 2:49 
AnswerRe: Inner Query in mysql Pin
DaveAuld8-Aug-11 12:44
professionalDaveAuld8-Aug-11 12:44 
GeneralRe: Inner Query in mysql Pin
Rakesh Meel8-Aug-11 19:38
professionalRakesh Meel8-Aug-11 19:38 
GeneralRe: Inner Query in mysql Pin
GuyThiebaut13-Aug-11 1:35
professionalGuyThiebaut13-Aug-11 1:35 
GeneralRe: Inner Query in mysql Pin
Rakesh Meel15-Aug-11 19:00
professionalRakesh Meel15-Aug-11 19:00 
Questionargument data type ntext is invalid for argument 1 of rtrim function Pin
md_refay7-Aug-11 22:09
Membermd_refay7-Aug-11 22:09 
AnswerRe: argument data type ntext is invalid for argument 1 of rtrim function [modified] Pin
Shameel8-Aug-11 5:35
professionalShameel8-Aug-11 5:35 
QuestionDB2: Create primary key on partition table? Pin
cuong-nm7-Aug-11 21:02
Membercuong-nm7-Aug-11 21:02 
Hi all !

In DB2, I want to create primary key on partition table. How can I do it?

Example:

Create table TEMP1:

CREATE TABLE TEMP1 (
ID INTEGER NOT NULL,
DATEREPORT VARCHAR(8) NOT NULL,
NUMBERREPORT VARCHAR(20),
TITLE VARCHAR,
YEAR INTEGER,
IDCOM INTEGER,
IDTEN INTEGER DEFAULT 0 NOT NULL
)DISTRIBUTE BY HASH (IDTEN, YEAR);

After that, I want to create primary key on ID column but not yet. How can I do?

Thanks !
MCP.NET, MCAD.NET, MCSD.NET

AnswerRe: DB2: Create primary key on partition table? Pin
Herman<T>.Instance9-Aug-11 2:29
MemberHerman<T>.Instance9-Aug-11 2:29 
GeneralRe: DB2: Create primary key on partition table? Pin
cuong-nm9-Aug-11 16:30
Membercuong-nm9-Aug-11 16:30 
AnswerRe: DB2: Create primary key on partition table? Pin
Wendelius12-Aug-11 7:01
mveWendelius12-Aug-11 7:01 
GeneralRe: DB2: Create primary key on partition table? Pin
cuong-nm14-Aug-11 17:19
Membercuong-nm14-Aug-11 17:19 
QuestionCube processing confirmation? Pin
current19996-Aug-11 1:01
Membercurrent19996-Aug-11 1:01 
AnswerRe: Cube processing confirmation? Pin
Mycroft Holmes6-Aug-11 2:52
professionalMycroft Holmes6-Aug-11 2:52 
AnswerRe: Cube processing confirmation? Pin
S Douglas11-Aug-11 9:20
professionalS Douglas11-Aug-11 9:20 
QuestionDisplaying SSRS Reports Pin
Aptiva Dave4-Aug-11 6:28
MemberAptiva Dave4-Aug-11 6:28 
AnswerRe: Displaying SSRS Reports Pin
Mycroft Holmes4-Aug-11 14:38
professionalMycroft Holmes4-Aug-11 14:38 
AnswerRe: Displaying SSRS Reports Pin
Pradeep Shukla8-Aug-11 8:33
professionalPradeep Shukla8-Aug-11 8:33 
GeneralRe: Displaying SSRS Reports Pin
Aptiva Dave8-Aug-11 8:50
MemberAptiva Dave8-Aug-11 8:50 
GeneralRe: Displaying SSRS Reports Pin
Pradeep Shukla8-Aug-11 9:25
professionalPradeep Shukla8-Aug-11 9:25 
GeneralRe: Displaying SSRS Reports Pin
Aptiva Dave8-Aug-11 9:26
MemberAptiva Dave8-Aug-11 9:26 
GeneralRe: Displaying SSRS Reports [modified] Pin
Pradeep Shukla8-Aug-11 9:50
professionalPradeep Shukla8-Aug-11 9:50 
GeneralRe: Displaying SSRS Reports Pin
Pradeep Shukla8-Aug-11 10:01
professionalPradeep Shukla8-Aug-11 10:01 
GeneralRe: Displaying SSRS Reports Pin
Chris Meech8-Aug-11 10:07
MemberChris Meech8-Aug-11 10:07 
GeneralRe: Displaying SSRS Reports Pin
Pradeep Shukla8-Aug-11 10:29
professionalPradeep Shukla8-Aug-11 10:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.