Skip to Content
0
Oct 14, 2022 at 11:40 AM

SDE schema and Object ID (ArcGIS)

282 Views Last edit Dec 22, 2022 at 02:04 AM 3 rev

currently using the sequence.nextval to generate the next object id but it is not working properly. Example: insert into TABLE_NAME (objectid, name) values (“SDE”.R444.nextval, ‘test’)

The sequence is incrementing by 20. where it should be one

Per ESRI documentation, the correct way is to use the GDB_UTILS.NEXT_ROWID, but this procedure was not found in SAP HANA SDE SCHEMA.

which function on SAP Hana that will give the correct sequence once the application insert the data