While writing a request on the local storage DB, auto replace features (may it be defined for Oracle, Sybase, MySQL, SQL Server…) do not seem to work.
Auto replace features are set per SQL language / DB editor.
I can not find the correct one for the local storage DB.
Thank you for your help !
Regards,
Alexandre DOLIQUE.
For an auto replace statement, use this:
update REGION set REGION_NAME = replace(REGION_NAME,‘ORIGINAL’,‘REPLACEMENT’)
Alternatively, you can use the find/replace function in Data Cleansing or Data Browser.
Also, any MySQL function should work in the local storage DB.
Good morning,
Thank you for your help.
I guess I didn’t make myself clear though.
What I meant by “auto replace” is not a SQL replace function syntax I am looking for, but in the editor options, have the ability to add a template for auto replacement.
For instance, while typing “s*” it would auto expand into “select * from”.
These templates are defined against a particular SQL language (Oracle, MySQL…). I have defined it for almost all, but it does not work.
Thank you again very much.
Regards,
Alexandre DOLIQUE.
Hello,
I appologize for misunderstanding the question. You are right, the local DB does not seem to draw from any of the language definitions for auto replace. I will create an enhancement CR for the that would either create one for the Local DB, or at least have the MySQL definitions apply to the local DB, since it is based off of MySQL.