We can also choose to commit or roll back the uncommitted transactions during SQL or OS errors using commit or ROLLBACK options.
我们还可以选择使用COMMIT或ROLLBACK选项在SQL或OS错误期间提交或回滚未提交的事务。
The script host.sql contains SQL statements that use federation to establish the connection to a remote DB2 for z/OS subsystem and to access three remote tables with spatial data through nicknames.
脚本host.sql包含一些 SQL语句,这些语句使用联邦建立到一个远程DB2for z/OS子系统的连接,并通过昵称访问三个含空间数据的远程表。
This is not necessary (and not even supported) for Sybase, Microsoft SQL Server, DB2(LUW, z/OS, iSeries) procedures.
对于Sybase过程,这是不必要的(也不支持)。
The Development Center provides a utility, the DB2Build utility, that executes on the client side, and that can be used to deploy SQL stored procedures to another target DB2 for z/OS server.
DevelopmentCenter提供了一个 DB2Build实用程序,该实用程序在客户端执行,可用于将SQL存储过程部署到另一个目标DB2for z/OS 服务器上。
Supports binary deploy of native SQL stored procedures in DB2 for z/OS.
支持DB2for z/OS中的本地SQL存储过程的二进制部署。
This article describes differences between implementation of DB2 stored procedures written in SQL Procedural Language between distributed platform (Linux, UNIX, Windows) and z/OS.
本文描述了在分布式平台(Linux、UNIX、Windows 等)和z/OS 上使用SQL过程语言实现DB2存储过程的区别。
The second example shows a DB2 SQL stored procedure for z/OS.
第二个例子展示了一个用于z/OS 的DB2SQL存储过程。
The second example shows a DB2 SQL stored procedure for z/OS.
第二个例子展示了一个用于z/OS 的DB2SQL存储过程。
应用推荐