I got this error:
unsupported VAR construction in DECLARE SECTION:
On this code:
EXEC SQL DECLARE D63_A999 TABLE
( VAR1 CHAR(17) NOT NULL,
VAR2 DECIMAL(13, 0) NOT NULL,
VAR3 DATE NOT NULL,
VAR4 DECIMAL(7, 0) NOT NULL,
VAR5 CHAR(1) NOT NULL,
VAR6 CHAR(1) NOT NULL,
VAR7 DECIMAL(11, 0) NOT NULL,
VAR8 DECIMAL(7, 0) NOT NULL,
VAR9 CHAR(9) NOT NULL,
VAR10 DECIMAL(15, 2) NOT NULL,
VAR11 CHAR(2) NOT NULL,
VAR12 DATE NOT NULL,
VAR13 DECIMAL(9, 0) NOT NULL,
VAR14 DECIMAL(3, 0) NOT NULL,
VAR15 CHAR(1) NOT NULL,
VAR16 CHAR(1),
VAR17 DECIMAL(7, 0),
VAR18 DECIMAL(7, 0),
VAR19 CHAR(1) NOT NULL,
VAR20 CHAR(35) NOT NULL,
VAR21 CHAR(35) NOT NULL,
VAR22 CHAR(35) NOT NULL,
VAR23 CHAR(35) NOT NULL,
VAR24 CHAR(35) NOT NULL,
VAR25 CHAR(35) NOT NULL,
VAR26 CHAR(35) NOT NULL,
VAR27 CHAR(1) NOT NULL,
VAR28 CHAR(1) NOT NULL,
VAR29 CHAR(1) NOT NULL,
VAR30 CHAR(40) NOT NULL
) END-EXEC.
What is wrong with that code.
Original code is from DB2 and the target is postgres.