Editing DN URIs via SQL

[Gordon Ross]

I want to manipulate a directory number's URIs via SQL. I've found the table and understand the schema fine. My problem is the primary URI field.

According to the database schema docs, you can't change which URI is the primary one (the isprimary column is listed as "Not Modifiable")

If the isprimary column values can't be changed, how can you change the primary URI on a DN? Is the only way, to delete all the existing URIs and add them back, with the new primary one being the first one to be added back in?

GTG

[npetrele]

Why wouldn't you simply use the getLine and updateLine AXL APIs?  updateLine has a "isPrimary" tag:

         <directoryURIs>

            <!--Zero or more repetitions:-->

            <directoryUri>

               <isPrimary>?</isPrimary>

               <uri>?</uri>

               <partition uuid="?">?</partition>

               <!--Optional:-->

               <advertiseGloballyViaIls>true</advertiseGloballyViaIls>

            </directoryUri>

         </directoryURIs>