We are replacing all our DDS Physical Files with Tables created using DDL (SQL Create Table statments). One of the requirements is that the new Table must have the same Format Level ID, which we have been able to satisfy in almost all cases, except when the DDS source has a VARLEN field.
We are using VARCHAR in the Create Table statement to emulate the behavior of the VARLEN, but we get different Level IDs.
Any ideas on how to modernize this physical files without changing the Level IDs?
PF using VARLEN:
Level ID = 2F38E6069DA98
A R TABLEONE
A KKEY 3A
A KCOLUMN1 100A VARLEN
Create Statement Using VARCHAR
Level ID 2F38E6069E2A0
CREATE TABLE TABLEONE (
KKEY CHAR(3) NOT NULL DEFAULT '' ,
KCOLUMN1 VARCHAR(100) DEFAULT NULL );