The transaction should fail and an SQL error should occur.
事务应该会失败,并且出现一个SQL错误。
If an error is detected, the SQL Errors view is displayed with information about the error.
如果检测到错误,就会显示SQL Errors视图,由它来显示关于错误的信息。
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错误。
If there is an error in an SQL statement, fix it and possibly rerun the application multiple times to catch and fix additional SQL errors.
如果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 character is replaced by a substitution character before parsing takes place, and results in the element tag name throwing a SQL error code "16110 XML Syntax error.
在解析之前,该字符被一个替换字符替代,导致元素标记名称抛出一个SQL错误代码 "16110XMLSyntax error.
This variable contains the error string from the last failed SQL statement.
该变量包含最后一个失败的sql语句的错误字符串。
This variable contains the error code of the latest SQL statement executed.
该变量包含最近执行的一条 SQL语句的错误代码。
SQLERROR of the last cursor is returned, and the error string of the latest failed SQL statement is stored into variable SQLERRSTR.
最后一个游标的SQLERROR被返回,而最后一个失败的sql语句的错误字符串将被存储到变量SQLERRSTR中。
If the user specifies these options, and there is a conflict with the option value at the data source, an error is returned (SQL 1255n).
如果用户指定了这些选项,但是与数据源上的选项值有冲突,那么返回一个错误(SQL 1255n)。
On DB2, the error string of the latest failed SQL statement can be retrieved using the GET DIAGNOSTICS statement, as shown in Table 4.
在DB 2中,最后一个失败的sql语句的错误字符串可以通过使用GETDIAGNOSTICS语句检索,参见表4。
IF it has MODIFIES SQL DATA, it is blocked in triggers, dynamic compound statements, SQL-bodied functions, or when a save point has been created, and error SQL30090 with reason code 22 is returned.
如果访问级别是MODIFIESSQLDATA,那么它在触发器、动态合成语句、sql体函数中或在创建保存点时会阻塞,并返回原因码为22的错误SQL 30090。
Additionally, the first SQL code is provided to give insight into the error encountered.
另外,第一条SQL代码可以用来深入了解遇到的错误。
If the tables don't exist (which is the case if the database was just created), an error message is displayed; but as the preceding SQL comments indicate, you can safely ignore those messages.
如果表不存在(当数据库刚创建时就会出现这种情况),将显示一条错误消息;但前面的SQL注释指明,您可以安全地忽略这些消息。
In the case of the DB2 example in the left column of Table 3, if a particular SQL statement fails and generates an error, control is passed to the condition handler.
对于表3左侧列的DB 2示例,如果某条sql语句失败并生成一个错误,那么控制将被传递给条件处理程序。
Note that proper exception handling in SQL PL dictates that each procedure has an error handler that could easily enough have told us the failing procedure.
注意,SQLPL中适当的异常处理要求每个过程有一个错误处理程序,这个错误处理程序应该可以很容易地告诉我们出错的过程。
On the client side, the SQL-55555E is intercepted and a connection is established to the optimal server that contains the data — the client doesn't need to do anything to handle the error.
在客户端,SQL- 55555e被拦截,并建立到包含数据的最佳服务器的连接——客户机不需要多任何事情来处理错误。
If this is not possible, an error SQL0142N is returned to indicate that this SQL statement cannot be supported.
如果这样不可行,则会返回错误SQL 0142n,表明该sql语句不受支持。
In practice, however, it appears that the error code is -1 for a successful execution of the SQL command.
不过,实际上,如果SQL命令成功执行,错误代码将是- 1。
Error handling: the new stored procedure now returns SQLCA with proper SQLCODE and SQLSTATE that is more inline with the error handling framework when using SQL.
错误处理:新的存储过程现在返回带有适当SQLCODE和SQLSTATE的SQLCA,在使用SQL时与错误处理框架更加内联。
For both databases you can declare error handlers that will determine what action are taken if an SQL statement fails with a particular error code (SQLCODE or SQLSTATE).
对于这两种平台上的数据库,您都可以声明错误处理程序,如果带有特殊的错误代码(SQLCODE或SQLSTATE)的sql语句失败,那么该处理程序将判定应采取哪些措施。
There is really a lot going on inside the DataAccess subsystem: generation of SQL statements, error handling, result set management, etc.
在DataAccess子系统内部实际上已经有了很多东西:SQL语句生成,错误处理,结果集管理,等等。
Note in SQL Server 2005, the user may receive the following error message.
注意:在SQLServer 2005中,用户可能会收到以下错误消息。
Developers may encounter an SQL Exception error when trying to access the Customer Service utility after having accessed the Derby database from Geronimo's console, or vice versa.
开发人员可能会在通过Geronimo的控制台访问了Derby数据后再尝试访问CustomerService实用程序时遇到SQLException错误,反之亦然。
Besides certain string values and SQL codes, db2pdcfg also accepts internal db2 error codes.
除了一些字符串值和SQL代码之外,db2pdcfg还接受内部db 2错误码。
Enhanced error handling through the use of SQL handlers.
通过使用SQL处理程序增强了错误处理能力。
If the SQL server login does not exist on the new server, and the user tries to log on, the user may receive the following error message.
如果新服务器上不存在SQLServer登录,而用户尝试登录,该用户可能会收到以下错误消息。
应用推荐