Hi,

I found this syntax for creating synonym for sql..

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

Is there any batch command like this for creating synonym for xml adapter.

If could specify the document link to see through..it would be helpful

Thanks in Advance...

wf 7.6.8/winXP

This message has been edited. Last edited by: Kerry,

XML requires a lot more information to create synonyms than a relational adapter so that syntax would not probaley do what you need.

An option when faced with something like this is to turn on the traces, create a synonym via the interface
and then look at the trace to see exactly what was done.

Does not always give the required answer but often does.

Thanks JG for the response...

My target is creating the synonym by running a fex file and i think trace cant help me in that.

Allen,
The idea is that you look at the trace to get the syntax that the server uses to create the synonym.

You can then cut and paste that into your focexec and substitute with parameters where you need.

I'm not able to see the traces.
I done this steps..is it correct.
workspace->configuration-> Configuration Files ->Server Profiles -> trace profile and changed the Traceuser = default
to

SET TRACEOFF = ALL
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACEUSER = ON
but i'm able to see the traces..could you help me getting the traces..

Thanking you

Allen, Those are client traces and will not show you what you need.

You need to turn the traces on, on the server and look at them there.

As an alternative if you have dev studio installed with a local server environment you could do it there.

Hi JG..
Could you provide me with step to on client traces.

close
go to the webfocus admin console
(not the server console)
http: //localhost:8080/ibi_apps/console/webfocusconsole.jsp
then Diagnostics
then Traces
If you pick WFServlet trace, for example, you'll see in the window the exact location where the trace file will be. they'll be in
/ibi/WebFOCUS76/logs directory.
Once you turn a trace on, and do your work, REMEMBER TO TURN THEM OFF eventually. duh.

Thanks susannah for the response..

I did the steps you told to turn on the traces which i throught will provide me with the code to creating synonym for XML file from fex..but i am not able to find anything related to that..

Is there any other way so that i can create a synonym for XML file from fex...

JG told you to turn on server traces. That is Workspace -> Configuration -> Diagnostics -> Traces. The traces can be viewed from there. They are stored in edatemp.

Run your test, then turn off the traces. Make sure to delete them when you are done looking at them.

ah
so that's different from WFServlet traces??
thanks for the clarif for me.

Yes. Servlet traces are client traces.