Oracle SQL开发人员查询错误DB2 SQL错误：SQLCODE = -109，SQLSTATE = 42601，SQLERRMC =带有隔离和保留，驱动程序= 3.69.56

发布于 2025-02-07 21:18:41 字数 856 浏览 1 评论 0原文

我正在尝试在Oracle SQL开发人员编辑器中运行查询批次，并获取以下错误消息：

DB2 SQL错误：SQLCODE = -109，SQLSTATE = 42601，SQLERRMC =带有隔离使用和保留，并保留，驱动程序= 3.69.56

它托管在Windows上Oracle SQL Developer是版本17，

我无法与UR一起使用，因为查询正在Oracle SQL Developer中运行。

请查看查询的示例，有关如何解决错误的任何想法

SELECT 'test' AS Data_Item, 'RC322' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableA ) AS VALUE FROM SYSIBM.SYSDUMMY1
union all SELECT 'test' AS Data_Item, 'RC323' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableB ) AS VALUE FROM SYSIBM.SYSDUMMY1
union all SELECT 'test' AS Data_Item, 'RC324' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableC ) AS VALUE FROM SYSIBM.SYSDUMMY1
union all SELECT 'test' AS Data_Item, 'RC325' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableD ) AS VALUE FROM SYSIBM.SYSDUMMY1

原文

I am trying to run queries batches in oracle sql developer editor and get the following error message:

DB2 SQL Error: SQLCODE=-109, SQLSTATE=42601, SQLERRMC=WITH ISOLATION USE AND KEEP, DRIVER=3.69.56

it is hosted on windows and the oracle sql developer is version 17

I cannot use with ur as the queries are being run in oracle sql developer.

Please see examples of queries run, any ideas on how to get round the error

SELECT 'test' AS Data_Item, 'RC322' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableA ) AS VALUE FROM SYSIBM.SYSDUMMY1
union all SELECT 'test' AS Data_Item, 'RC323' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableB ) AS VALUE FROM SYSIBM.SYSDUMMY1
union all SELECT 'test' AS Data_Item, 'RC324' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableC ) AS VALUE FROM SYSIBM.SYSDUMMY1
union all SELECT 'test' AS Data_Item, 'RC325' AS Test, 'dc' AS Source_Table, (SELECT COUNT() FROM schema.tableD ) AS VALUE FROM SYSIBM.SYSDUMMY1

分享到QQ

分享到微博