Our iPad application uses UDB in iOS and Mobilink as middleware.
We used to have 4 publications. We modified it to 3 publications to improve Sync performance.
From iOS end, we upgrade UDB schema using sql file by executing below statement
ALTER DATABASE SCHEMA FROM FILE UDBSchema_v2.sql
As we removed a publication in Mobilink server, We have to drop publication at client side too. So, we added below 2 lines to drop publication and synchronization profile
DROP PUBLICATION [ IF EXISTS ] "pub_name"
DROP SYNCHRONIZATION PROFILE [ IF EXISTS ] "sync_profile"
But these are not working and it's throwing an error -131 (Syntax error)
It works If we remove IF EXISTS clause from the statements. We would like to add IF EXISTS in the query to make sure no error throws eventhough DROP statement executes if publication does not exist in UDB.
Please let me know if we are doing wrong here. Please suggest us the correct way.