The transaction should fail and an SQL error should occur.
事务应该会失败,并且出现一个SQL错误。
Attempting a DML operation on a table that is in alter mode results in SQL error code -19992.
如果尝试对alter模式下的表执行dml操作,则会产生sql错误码- 19992。
The following example demonstrates the usage of the exit option during a SQL error to exit the CLPPlus application.
以下示例展示了出现SQL错误期间如何使用EXIT选项退出CLPPlus应用程序。
With the property set this way, any SQL statements from the application that are not bound to the database will result in an SQL error.
采用这种方式设置该属性,应用程序中任何未绑定到数据库的sql语句都将产生SQL错误。
For example, if the column has a type of VARCHAR (256), results that are longer than 256 characters result in a failed flow and an SQL error.
例如,如果列的类型为VARCHAR(256),大于256个字符的结果将导致失败的流和SQL错误。
The stored procedures return 0 (zero) when they run successfully and SQL error codes if it finds any issues with the parameters or policy file content.
如果成功运行,则存储过程将返回0(零),如果发现任何参数或策略文件内容问题,则返回SQL错误代码。
The stored procedures return 0 (zero) when they run successfully and SQL error codes if it finds any issues with the parameters or policy file content.
如果成功运行,则存储过程将返回0(零),如果发现任何参数或策略文件内容问题,则返回SQL错误代码。
应用推荐