Here's one using ROWID and a date column:
CREATE TABLE STEO01/TEMPTEST (
GRPID SMALLINT GENERATED ALWAYS AS IDENTITY (
START WITH 1 INCREMENT BY 1
NO MINVALUE NO MAXVALUE
NO CYCLE NO ORDER
CACHE 20 )
GRPNAME CHAR(25) CCSID 278 NOT NULL DEFAULT '' ,
CUSER CHAR(10) CCSID 278 NOT NULL DEFAULT '' ,
CDATE DATE NOT NULL DEFAULT CURRENT_DATE )
And here's how I'd code it in RPG (the formatting will be off, sorry):
ftemptest uf a e disk rename(temptest: rtemptest)
*inlr = '1';
grpname = 'xyz';
cuser = 'someone';
I specify writing to two columns and DB2 puts in values for the other two
(identity column and date).
Is this behaviour possible to imitate?
> Can you post the DDL and an SQL CREATE and an SQL INSERT ?
> From: Erik Olsson <erik.eo.olsson@xxxxxxxxx>
> To: mi400@xxxxxxxxxxxx
> Date: 09/16/2010 08:49 AM
> Subject: [MI400] Write to db containing values defined by DB2
> Sent by: mi400-bounces@xxxxxxxxxxxx
> Posted this on the C list but was adviced to try out here as well.
> If I have DDL defined tables with columns holding DB2 generated values such
> as ROWID, defaults as CURRENT_TIMESTAMP etc - how do I code a write to
> columns like that using (the C runtime) _Rwrite (I don't know what one
> use in MI)?
> That is, is there a way to emulate how an RPG write opcode handles the same
> Best wishes,