comparing formats adabas and other formats databases

, , , ,
1

I’m trying to put together a comparison table between formats adabas and other bank.
could this be?

Others DB / Adabas
CHAR

  • Format A, with/without LA/LB, with FI/NB
    VARCHAR
  • Format A, with/without LA/LB, with NC
    CLOB (DB2)
  • Format A, with LB
    INT
    -Format P/U
    SMALLINT
  • Format P/U
    DECIMAL / NUMERIC
  • Format P/U, (P/U do not have decimal).
    DATE/TIME
  • Format P/U.
2

Not quite

CLOB can also be a format B with the LA option

INT = F(4)
SMALLINT = F(2)

DATE/TIME does NOT map natively as the contents of a Natural Date / Time field,
stored as a format P in Adabas, is in an internal format

3

INT and SMALLINT would be represented as Fixed Point format (F).

Sorry about that. Timing issue.

4

Thanks.