Running scripts in both SQL Query Analyzer and Sybase InfoMaker

[sjh]

Hi,
I am writing a script that contains CREATE TABLE, ALTER TABLE, CREATE VIEW, CREATE TRIGGER along with SELECT/INSERT/UPDATE statements.

I would like to run this script in both Query Analyzer and in Sybase's InfoMaker. The InfoMaker doesn't seem to like the keyword "GO". And it wants the statements to be terminated with a semicolon.

Is there a way to get around this issue? Or do I have to create two versions of the script for each database type?

Thanks for your help!
Susie

 

[SQLSister]

I can run a select statement ending in the ; in Query analyzer with no go statement. Have you tried your sripts without the go and with the semicolon?


Questions about posting. See faq183-874

 

[sjh]

With statements like CREATE TRIGGER and CREATE VIEW, they must be the first statement in the batch, or otherwise it will throw an error.