RE: embedded SQL - how to insert with a GENERATED ALWAYS AS IDENTITYcolumn

Create a view without the IDENTITY column and perform an "Insert into"
that view?

Rich

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Gqcy
Sent: Monday, February 14, 2011 3:51 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: embedded SQL - how to insert with a GENERATED ALWAYS AS
IDENTITYcolumn

I have a table with a "GENERATED ALWAYS AS IDENTITY" column,
but I don't know how to get my INSERT to work with that column:
Is there some variable type that matches the identity column???

DDL:
CREATE TABLE PDATALIB/TKT001DPF (
TKTSYSID DECIMAL(3,0) DEFAULT 0,
TKTAEMAIL CHAR(64),
TKTREMAIL CHAR(64),
TKTTEMAIL CHAR(64),
TKTPRBNAM CHAR(64),
TKTPRIRTY DEC(2,0) DEFAULT 0,
TKTSTATUS CHAR(26),
TKTTKTTYP CHAR(16),
TKTSUBJEC CHAR(64),
TKTBODY CHAR(1024),
TKTNUMBER INTEGER,
TKTTIMSTMP TIMESTAMP,
TKTTKTDID INT NOT NULL GENERATED ALWAYS AS IDENTITY
)
RCDFMT TKT001DR;

code:
Exec SQL
Insert into pdatalib/TKT001DPF VALUES
( :P1_SysID , :P2_AEmail , :P3_REmail,
:P4_TEmail , :P5_PrbName , :P6_Priority,
:P7_Status , :P8_TktType, :P9_Subject,
:PA_Body , :TICKET# , :TIMSTAMP ) ;


above code generates SQL0117 Statement contains wrong number of values.