# What does N@ and L@ mean in an oracle DDM of natural adabas

**URL:** <https://techcommunity.softwareag.com/t/what-does-n-and-l-mean-in-an-oracle-ddm-of-natural-adabas/310938>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Natural, NaturalONE\
**Created:** [July 16, 2025, 9:52am UTC](https://techcommunity.softwareag.com/t/what-does-n-and-l-mean-in-an-oracle-ddm-of-natural-adabas/310938 "2025-07-16T09:52:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tagan\_Anto](https://avatars.discourse-cdn.com/v4/letter/t/2acd7d/32.png) [@Tagan\_Anto](https://techcommunity.softwareag.com/u/Tagan_Anto)\
**Post date:** [July 16, 2025, 9:52am UTC](https://techcommunity.softwareag.com/t/what-does-n-and-l-mean-in-an-oracle-ddm-of-natural-adabas/310938/1 "2025-07-16T09:52:02Z")

</div>

hello everyone.  
in an oracle ddm, N@filed and L@fields are created .  
What are they used for and how are they used?

#### I use Natual One

---

<div class="post-metadata">

**Author:** ![wolfgang.winter](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/wolfgang.winter/32/17954_2.png) [@wolfgang.winter](https://techcommunity.softwareag.com/u/wolfgang.winter)\
**Post date:** [July 16, 2025, 10:11am UTC](https://techcommunity.softwareag.com/t/what-does-n-and-l-mean-in-an-oracle-ddm-of-natural-adabas/310938/2 "2025-07-16T10:11:41Z")

</div>

N@ is a NULL indicator  
L@ is a length indicator

See the [DDM documentation](https://documentation.softwareag.com/natmf/9.2.3/en/webhelp/natmf-webhelp/dbms/ndb-ddm.htm#ndb-ddm)

---

<div class="post-metadata">

**Author:** ![Eugene.Miklovich](https://avatars.discourse-cdn.com/v4/letter/e/ce73a5/32.png) [@Eugene.Miklovich](https://techcommunity.softwareag.com/u/Eugene.Miklovich)\
**Post date:** [July 16, 2025, 12:32pm UTC](https://techcommunity.softwareag.com/t/what-does-n-and-l-mean-in-an-oracle-ddm-of-natural-adabas/310938/3 "2025-07-16T12:32:59Z")

</div>

For clarity: “N@” is for emulating SQL “NULL” not ADABAS “Null Suppressed”.

Meaning the value in the field is undefined, i.e. field has not been assigned a value.

With ADABAS we know that there is always a default value (blank or zero).

“L@” is giving the current length or a variable length string.

This can be useful in many situations,

e.g. doing an EXAMINE replace

Eugene (Gene) Miklovich

ADABAS/NATURAL Systems Support and DBA

Cell: 916-202-7047

Normal Hours: 8am-4pm E.T.

Please call or text if assistance needed outside these hours.

Out of Office Notice:

Fri July 4th thru Sun July 13

---

<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:** [January 12, 2026, 12:33pm UTC](https://techcommunity.softwareag.com/t/what-does-n-and-l-mean-in-an-oracle-ddm-of-natural-adabas/310938/4 "2026-01-12T12:33:02Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.
