English 中文(简体)
结构
原标题:SQL7008 Error - Workaround?

I m using the JTOpen JDBC driver for a DB2 Universal database. I have very little experience with SQL beyond simple statements.

,问题,我认为,在试图“交易期间在非记名桌上添加/更新的字眼(SQL7008)时,就会出现错误。

根据该项目的牵头单位,我国的行文没有报到,很快会获胜(请允许我问我,为什么我不是德国银行)。 然而,Im公司在能够<条码>的项目中开展工作。 不管怎么说(无论何时要求执行),几乎都有必要(并非完全需要,而是解决道路上的许多问题)。

如果没有《日刊》授权,能否在罗尔卡7008周围工作?

最佳回答

在您的行文中,在不作授权的报到的情况下,唯一的出路是:

jdbc:as400://systemname;naming=sql;errors=full;transaction isolation=none;date format=iso

JDBC的全部财产清单见:rel=“noretinger”>。 IBM JDBC 特性的IBM工具箱文件。

问题回答

I have found that using WITH NONE at the end of the DB2 statement solve the problem, only if you use INSERT.

当我尝试使用<代码>时。 删除声明的编号COMMIT=*NONE,似乎绕过了什么地方,在试图使用<代码>时也发生了同样的情况。 NC或

To resolve this issue, do one of the following:

Enable journaling for the database table: Windows: Add a CLI Parameter TxnIsolation with the value 32 within your ODBC settings under "Administrative Tools". This option can be found under: "Data Source" -> "Advanced Settings" -> "Add" -> "TxnIsolation" as a radio button "No Commit".

AIX / Unix: Run the following DB2 command on your database: db2 update cli cfg for section using TXNIsolation 32 . Verify these settings with the following command: db2 get cli cfg

Alternate SQL workaround: (not OS-specific): Add WITH NONE to the end of your SQL UPDATE command.

More info...

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/rzala/rzalaml.htm rel=“nofollow”>here (do CTRL-F/5/7008)。 它希望你们能够从理性法典获得更多信息。 如果你重读第3条理据,那么,它就认为,除了授权发布外,别无选择。

如果你重新获得除理性第3条以外的东西,那么我就认为你有更多的选择。

希望会有所帮助。

如果在指挥中心工作的话。 下面的指挥解决了这一问题:

RUNSQLSTM SRCFILE(LIBNAME/SRCFILE) SRCMBR(MBRFILE) COMMIT(*NONE) NAMING(*SQL) 




相关问题
Spring Properties File

Hi have this j2ee web application developed using spring framework. I have a problem with rendering mnessages in nihongo characters from the properties file. I tried converting the file to ascii using ...

Logging a global ID in multiple components

I have a system which contains multiple applications connected together using JMS and Spring Integration. Messages get sent along a chain of applications. [App A] -> [App B] -> [App C] We set a ...

Java Library Size

If I m given two Java Libraries in Jar format, 1 having no bells and whistles, and the other having lots of them that will mostly go unused.... my question is: How will the larger, mostly unused ...

How to get the Array Class for a given Class in Java?

I have a Class variable that holds a certain type and I need to get a variable that holds the corresponding array class. The best I could come up with is this: Class arrayOfFooClass = java.lang....

SQLite , Derby vs file system

I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...

热门标签