Append Schema name to all queries & reports in a Infomaker 11 library

[c***@gmail.com]

We're taking over an Oracle DB from another company. The DB was set
up here without synonyms. How can I easily prepend the schema name to
the SQL statements for all queries and reports in a library

[M. Searer]

I don't think there is an 'easy' way.

The fastest way would be to generate the oracle synonyms for the infomaker users.

Post by c***@gmail.com
We're taking over an Oracle DB from another company. The DB was set
up here without synonyms. How can I easily prepend the schema name to
the SQL statements for all queries and reports in a library

[Terry Dykstra [TeamSybase]]

You might be able to do it with PBLPeeper: http://www.techno-kitten.com It
is a pretty versatile tool for looking at PB code. And it's free!
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

Post by M. Searer
I don't think there is an 'easy' way.
The fastest way would be to generate the oracle synonyms for the infomaker users.

Post by c***@gmail.com
We're taking over an Oracle DB from another company. The DB was set
up here without synonyms. How can I easily prepend the schema name to
the SQL statements for all queries and reports in a library