+11Hi,
I am creating a table in Oracle SDE with FME. Is there to uncheck the Allow NULL property of a field via FME Desktop? Or even a way to uncheck it after the table is created with FME within ArcGIS Pro Catalog? See screenshot below.
Thanks,
Annette
I have the impression this isn't possible using FME.
A possible workaround is to let FME create the table for you and then execute the necessary ALTER TABLE statements, for example:
ALTER TABLE your_table
ADD CONSTRAINT your_constraint_name CHECK(your_column_name IS NOT NULL)You will have to execute this statement once for each column in your table.
+11I have the impression this isn't possible using FME.
A possible workaround is to let FME create the table for you and then execute the necessary ALTER TABLE statements, for example:
ALTER TABLE your_table
ADD CONSTRAINT your_constraint_name CHECK(your_column_name IS NOT NULL)You will have to execute this statement once for each column in your table.
It seems there is something in the SDE tables that govern the allow null option. I also tried deleting all the records and via Pro setting it on the empty table but that didn't work. I am going to open a ticket with esri.
https://community.esri.com/thread/25627
Another option would be to create the table via the Oracle spatial writer and then register it with SDE afterwards...but I have a nice workspace that applies domains etc so I won't try this just yet.
+11I have the impression this isn't possible using FME.
A possible workaround is to let FME create the table for you and then execute the necessary ALTER TABLE statements, for example:
ALTER TABLE your_table
ADD CONSTRAINT your_constraint_name CHECK(your_column_name IS NOT NULL)You will have to execute this statement once for each column in your table.
PS thank you for the answer.
+9I have the impression this isn't possible using FME.
A possible workaround is to let FME create the table for you and then execute the necessary ALTER TABLE statements, for example:
ALTER TABLE your_table
ADD CONSTRAINT your_constraint_name CHECK(your_column_name IS NOT NULL)You will have to execute this statement once for each column in your table.
Understand that it's not possible 4 years ago, any chance is it possible now? 🤞