On DB2 UDB Version 7

1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #64,185 by gdaustin 11/20/02 10:11:37 PM Reply	On DB2 UDB Version 7 CREATE TABLE DEPT ( DEPTNO INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 500, INCREMENT BY 1), DEPTNAME VARCHAR (36) NOT NULL, MGRNO CHAR(6), ADMRDEPT SMALLINT NOT NULL, LOCATION CHAR(30) ) That's the syntax for UDB. I suspect it would be the same for DB2/400. Try it, either it works or it doesn't.
Post #64,290 by mmoffitt 11/21/02 1:31:52 PM Reply	It doesn't. But thanks. The DB2/400 is a different product completely and lacks many (most?) of the features of DB2 UDB v7.x.

Any DB2/400 Goobs out there? - (mmoffitt) - (7) - Nov. 19, 2002, 02:47:01 PM EST

If no AutoIncrement, use a Sequence + a Pre-Insert Trigger? -NT - (CRConrad) - (3) - Nov. 20, 2002, 04:33:48 AM EST

Write before insert trigger in C. - (mmoffitt) - (2) - Nov. 20, 2002, 11:59:44 AM EST

What, no sequences? Or, uh... It can't do triggers in SQL?!? -NT - (CRConrad) - (1) - Nov. 20, 2002, 06:00:14 PM EST

I don't know this platform much, but... - (mmoffitt) - Nov. 20, 2002, 06:56:13 PM EST

Solution (for anyone who is interested). - (mmoffitt) - Nov. 20, 2002, 01:51:21 PM EST

On DB2 UDB Version 7 - (gdaustin) - (1) - Nov. 20, 2002, 10:11:37 PM EST

It doesn't. - (mmoffitt) - Nov. 21, 2002, 01:31:52 PM EST

Before such superhuman attainments of sustained triviality one stands in something like awe.
55 ms