I am just getting started with Valence. I've only had it for a couple of days, but i'm trying to create an AUTOCODE FileMaintenance program. I'm trying to use a file that is created by DDL and uses Identity column as the key, but autocode says its not keyed and can only create an inquiry program.
Any idea why this is happening and how to resolve it?
Thanks
Mike
DDL is
CREATE TABLE TAPEINV00
(TIID INT GENERATED ALWAYS AS IDENTITY
(START WITH 1 INCREMENT BY 1) PRIMARY KEY,
TISYSTEM CHAR ( 10) CCSID 37 WITH DEFAULT NUL
TILABEL CHAR (10 ) NOT NULL WITH DEFAULT,
TISEQ DEC( 2, 0) NOT NULL WITH DEFAULT,
TILOCATE CHAR (10 ) NOT NULL WITH DEFAULT,
TITAPEDATE DEC (8 , 0) NOT NULL WITH DEFAULT,
TISTATUS CHAR (10) NOT NULL WITH DEFAULT,
TINOTES CHAR (50) NOT NULL WITH DEFAULT,
TIPONUM DEC (7,0) NOT NULL WITH DEFAULT,
TISERIAL CHAR (20 ) NOT NULL WITH DEFAULT,
TIINSRVDTE DEC (8,0 ) NOT NULL WITH DEFAULT,
TITRNDATE DEC (8,0 ) NOT NULL WITH DEFAULT,
TIEXPDATE DEC (8,0 ) NOT NULL WITH DEFAULT,
TISCRPDATE DEC (8,0 ) NOT NULL WITH DEFAULT,
TILBLWGHT DEC (2,0) NOT NULL WITH DEFAULT);
Any idea why this is happening and how to resolve it?
Thanks
Mike
DDL is
CREATE TABLE TAPEINV00
(TIID INT GENERATED ALWAYS AS IDENTITY
(START WITH 1 INCREMENT BY 1) PRIMARY KEY,
TISYSTEM CHAR ( 10) CCSID 37 WITH DEFAULT NUL
TILABEL CHAR (10 ) NOT NULL WITH DEFAULT,
TISEQ DEC( 2, 0) NOT NULL WITH DEFAULT,
TILOCATE CHAR (10 ) NOT NULL WITH DEFAULT,
TITAPEDATE DEC (8 , 0) NOT NULL WITH DEFAULT,
TISTATUS CHAR (10) NOT NULL WITH DEFAULT,
TINOTES CHAR (50) NOT NULL WITH DEFAULT,
TIPONUM DEC (7,0) NOT NULL WITH DEFAULT,
TISERIAL CHAR (20 ) NOT NULL WITH DEFAULT,
TIINSRVDTE DEC (8,0 ) NOT NULL WITH DEFAULT,
TITRNDATE DEC (8,0 ) NOT NULL WITH DEFAULT,
TIEXPDATE DEC (8,0 ) NOT NULL WITH DEFAULT,
TISCRPDATE DEC (8,0 ) NOT NULL WITH DEFAULT,
TILBLWGHT DEC (2,0) NOT NULL WITH DEFAULT);
Comment