Re: isql script calling other script

On Wed, 20 Jun 2007 08:04:05 -0700, Keith wrote:


Is there, by chance, a #define equivalent? Could you do something
like:

#define TARGDB prod
...
insert into TARGDB.dbo.myTable ....

We use that type of capability too, and although the cpp solution is
more portable

If you use sqsh you can use:

\set TARGDB=prod
insert into $TARGDB.dbo...

See http://www.sqsh.org for more information.

Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler@xxxxxxxxxxx - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html

.