DB2等同于SQL的GO？-DB2EquivalenttoSQL'sGO?

GO is something that is used in MSSQL Studio, I have my own app for running upates into live and use "GO" to break the statements apart.

GO是在MSSQL Studio中使用的东西,我有自己的应用程序用于运行upates到live并使用“GO”来破坏语句。

Does DB2 support the semi-colon (;)? This is a standard delimiter in many SQL implementations.

DB2是否支持分号(;)?这是许多SQL实现中的标准分隔符。

have you tried using just a semi-colon instead of "GO"?

你尝试过使用分号代替“GO”吗?

This link suggests that the semi-colon should work for DB2 - http://www.scribd.com/doc/16640/IBM-DB2

此链接表明分号应该适用于DB2 - http://www.scribd.com/doc/16640/IBM-DB2

I would try wrapping what you are looking to do in BEGIN and END to set the scope.

我会尝试在BEGIN和END中包装你想要做的事情以设置范围。

GO is not a SQL command, it's not even a TSQL command. It is an instruction for the parser. I don't know DB2, but I would imagine that GO is not neccessary.

GO不是SQL命令,它甚至不是TSQL命令。它是解析器的指令。我不知道DB2,但我认为GO不是必需的。

From Devx.com Tips

来自Devx.com提示

Although GO is not a T-SQL statement, it is often used in T-SQL code and unless you know what it is it can be a mystery. So what is its purpose? Well, it causes all statements from the beginning of the script or the last GO statement (whichever is closer) to be compiled into one execution plan and sent to the server independent of any other batches.

虽然GO不是T-SQL语句,但它通常用在T-SQL代码中,除非你知道它是什么,否则它可能是一个谜。那它的目的是什么?好吧,它会导致从脚本开头或最后一个GO语句(以较近者为准)的所有语句编译成一个执行计划,并独立于任何其他批次发送到服务器。