# comparing formats adabas and other formats databases

**URL:** <https://techcommunity.softwareag.com/t/comparing-formats-adabas-and-other-formats-databases/101284>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Basics-on-Linux-Unix-Windows, Adabas-on-Windows-UNIX, Adabas-on-Linux\
**Created:** [August 21, 2012, 5:42pm UTC](https://techcommunity.softwareag.com/t/comparing-formats-adabas-and-other-formats-databases/101284 "2012-08-21T17:42:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [August 21, 2012, 5:42pm UTC](https://techcommunity.softwareag.com/t/comparing-formats-adabas-and-other-formats-databases/101284/1 "2012-08-21T17:42:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [August 21, 2012, 6:04pm UTC](https://techcommunity.softwareag.com/t/comparing-formats-adabas-and-other-formats-databases/101284/2 "2012-08-21T18:04:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [August 21, 2012, 6:09pm UTC](https://techcommunity.softwareag.com/t/comparing-formats-adabas-and-other-formats-databases/101284/3 "2012-08-21T18:09:17Z")

</div>

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

Sorry about that. Timing issue.

---

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [August 21, 2012, 6:15pm UTC](https://techcommunity.softwareag.com/t/comparing-formats-adabas-and-other-formats-databases/101284/4 "2012-08-21T18:15:21Z")

</div>

Thanks.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:02pm UTC](https://techcommunity.softwareag.com/t/comparing-formats-adabas-and-other-formats-databases/101284/5 "2021-04-02T15:02:20Z")

</div>