Skip to main content
Question

How do I set the isNullable (Allow NULL) property for an attribute when writing to a feature class in an Esri SDE database?

  • September 12, 2022
  • 3 replies
  • 153 views

In an Esri SDE database, fields (attributes) have a property setting of isNullable (Allow NULL). This property determines if the field allows null values or not. I want to be able to set this property in FME when I create a new feature class. Is there a way to set this property with the Esri Geodatabase SDE writer? See screenshot below to see how to set the setting in ArcGIS Pro.

Allow NULL property

3 replies

Forum|alt.badge.img+2
  • September 12, 2022

@ab_crd​ FME does not have an option to alter the Allow NULL setting on a feature class attribute. But by default all the attributes that FME creates will be Allow NULL


  • Author
  • September 12, 2022
markatsafe wrote:

@ab_crd​ FME does not have an option to alter the Allow NULL setting on a feature class attribute. But by default all the attributes that FME creates will be Allow NULL

@Mark Stoakes​  Thanks Mark, I'll figure out another way.


slingeman
Contributor
Forum|alt.badge.img+1
  • Contributor
  • January 22, 2024

This is kind of a big deal, at least for ArcGIS Indoors. Many of the attributes for Indoors does not allow Nullable. So if using FME to convert your CAD drawings and the output is all nullable, the featureclass doesn't work properly for indoors.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings