DDS to SQL

Field definitions are read — name, length, type, decimals — along with the record format and key fields. Type mapping is: A to CHAR, P to DECIMAL, S to NUMERIC, L to DATE, T to TIME, Z to TIMESTAMP, B to SMALLINT, INTEGER or BIGINT depending on length. A field with no explicit type is zoned when it has decimals and character when it does not, as DDS requires. Comments come out as --, and fields that cannot be translated come out commented in full, so the CREATE TABLE still runs and the column to fix by hand stays in sight. Two options change the result: NOT NULL on every field, and long names taken from the description — COLHDG first, then TEXT — with the DDS name kept as FOR COLUMN, the system name RPG programs go on reading the file with. Validation keywords, default values and fields defined by reference are left out, and flagged rather than guessed: the result is a starting point to read through, not something to run blind.