is there any APIs available in WebFOCUS 8207 to create a syn...

[Gokulnathan Chandrasekaran]

is there any APIs available in WebFOCUS 8207 to create a synonym using an existing profile connection rather than user navigating to metadata page and creating the synonym. I am looking for an option to automate the synonym creation process.

[Alban Hertroys]

There is a CREATE SYNONYM command that you can use to, well, do just that. There are some useful posts on the topic on the old FocalPoint WebFOCUS forum.

[NYCBabak .]

Youll need to create a Procedure on the reporting server thatll use this syntax. Youll have to replace the generic stuff with Adapter specific words.

CREATE SYNONYM [app name]/[new synonym] FOR [target table] DBMS [dbms type i.e. SQLMSS] AT [adapter name]

END

Once you have this working, you can just automate it by calling this fex.

[Toby Mills]

We used to do this all the time. Write yourself a Focexec that asks you what app folder to drop your Masters in, and which data connection you want to use (I name my app folder the same as my connection name). Then use that information to build your CREATE SYNONYM commands and iterate your way through all the tables that exist on that connection.

[Nox Lee]

wep5622:

 

CREATE SYNONY

 

 

Sorry for interrupt this topic, when there is same synonyms name already located in same directory/path it prompt can not overwritten any idea how to use automate update/replace the synonym

[David Beagan]

Looking at some old code, I think you can add DROP at the end of the CREATE SYNONYM command to overwrite the old one.

Another thought, instead of using DROP. You might want to use an APP command to rename the synonyms master and access files, but before doing the rename you would use another APP command to delete the previous ones.