将DB2 V7迁移到V8 IN ibm z / os后获取SQLCODE -302 [英] Getting SQLCODE -302 after migrating DB2 V7 to V8 IN ibm z/os
问题描述
全部
我们的商店从V7迁移到DB2 V8。我们在IBM系统级别：
z / OS 1.6.1 @ RSU 0702.
处理器：IBM 2064-1C7（z / 900）＃1B89模式：64位
我的一个应用程序在DB2中测试代码/作业时面临问题
V8环境。细节是：作业在准备工作中出现SQLCODE -302 SQL
错误。许多
年没有代码修改。它在db2 V7环境中运行良好。该模块正在使用
动态sql准备语句。
它是一个cobol / db2模块。
EXEC SQL
PREPARE SQL_STM6 FROM：WS06-GET-DUPLICATE-CURSOR
END-EXEC。
如果SQLCODE = 0
那么
SET SW14-PREPARED TO TRUE
PERFORM 33110-DECLARE-GET-DUPL-USAGE
ELSE
PERFORM C9000-DB-ERROR
DISPLAY''PREPARE GET_DUPLICATE FAILED，SQL =''SQLCODE
END-IF。
我们有任何想法需要更改v8的代码或者是带有Db2 v8
迁移的问题。
谢谢
Ravi
All
Recenetly our shop migrated to DB2 V8 from V7. We are in IBM System Level:
z/OS 1.6.1 @ RSU 0702.
Processor : IBM 2064-1C7 (z/900) # 1B89 Mode: 64-bit
One of my application is facing problem while testing their code/Jobs in DB2
V8 environments. The Details are: Job is abending with SQLCODE -302 SQL
error on the prepare staement. There is no code modification made for many
years. It is working fine in db2 V7 enviornments. The module is using
dynamic sql prepare statement.
Its a cobol/db2 module.
EXEC SQL
PREPARE SQL_STM6 FROM :WS06-GET-DUPLICATE-CURSOR
END-EXEC.
IF SQLCODE = 0
THEN
SET SW14-PREPARED TO TRUE
PERFORM 33110-DECLARE-GET-DUPL-USAGE
ELSE
PERFORM C9000-DB-ERROR
DISPLAY ''PREPARE GET_DUPLICATE FAILED, SQL= '' SQLCODE
END-IF.
Any idea we need to change the code for v8 or is the probelm with Db2 v8
migration.
Thanks
Ravi
推荐答案
在我的商店里，由于测试数量众多，从DB2版本7转换为
版本8需要一年多的时间需要
并发支持的环境以及版本8中对Unicode的更改。当我回想起，PC和Unix机器上的几个系统需要更改
提交逻辑，因为他们的代码可以使用版本7，但不能使用
版本8.
但是我在应用程序端而且我不是DB2专家。你有没有和你的DBA或技术服务人员谈过这个问题？
他们可能会建议一个解决方案或协助你诊断
问题。
由于
安全风险和GLBA（Gramm-Leach-Bliley Act），我们不允许在我们的环境中使用动态SQL 。
http://en.wikipedia.org/wiki / Gramm-Leach-Bliley_Act
最亲切的问候，
Sri写道：
In my shop it took over a year to convert from DB2 version 7 to
Version 8, due to the large number of test environments requiring
concurrent support and the change to Unicode in version 8. As I
recall, several systems on PC''s and Unix boxes required changes to
commit logic because their code would work with version 7 but not with
version 8.
But I am on the applications side and I am no DB2 expert. Have you
talked with your DBA or technical services people about this problem?
They may be able to suggest a solution or assist you with diagnosing
the probleml.
We are not allowed to use dynamic SQL in our environment due to the
security risks and GLBA (Gramm-Leach-Bliley Act).
http://en.wikipedia.org/wiki/Gramm-Leach-Bliley_Act
With kindest regards,
Sri wrote:
全部
我们的商店从V7迁移到DB2 V8。我们在IBM系统级别：
z / OS 1.6.1 @ RSU 0702.
处理器：IBM 2064-1C7（z / 900）＃1B89模式：64位
我的一个应用程序在DB2中测试代码/作业时面临问题
V8环境。细节是：作业在准备工作中出现SQLCODE -302 SQL
错误。许多
年没有代码修改。它在db2 V7环境中运行良好。该模块正在使用
动态sql准备语句。
它是一个cobol / db2模块。
EXEC SQL
PREPARE SQL_STM6 FROM：WS06-GET-DUPLICATE-CURSOR
END-EXEC。
如果SQLCODE = 0
那么
SET SW14-PREPARED TO TRUE
PERFORM 33110-DECLARE-GET-DUPL-USAGE
ELSE
PERFORM C9000-DB-ERROR
DISPLAY''PREPARE GET_DUPLICATE FAILED，SQL =''SQLCODE
END-IF。
我们有任何想法需要更改v8的代码或者是带有Db2 v8
迁移的问题。
谢谢
Ravi
All
Recenetly our shop migrated to DB2 V8 from V7. We are in IBM System Level:
z/OS 1.6.1 @ RSU 0702.
Processor : IBM 2064-1C7 (z/900) # 1B89 Mode: 64-bit
One of my application is facing problem while testing their code/Jobs in DB2
V8 environments. The Details are: Job is abending with SQLCODE -302 SQL
error on the prepare staement. There is no code modification made for many
years. It is working fine in db2 V7 enviornments. The module is using
dynamic sql prepare statement.
Its a cobol/db2 module.
EXEC SQL
PREPARE SQL_STM6 FROM :WS06-GET-DUPLICATE-CURSOR
END-EXEC.
IF SQLCODE = 0
THEN
SET SW14-PREPARED TO TRUE
PERFORM 33110-DECLARE-GET-DUPL-USAGE
ELSE
PERFORM C9000-DB-ERROR
DISPLAY ''PREPARE GET_DUPLICATE FAILED, SQL= '' SQLCODE
END-IF.
Any idea we need to change the code for v8 or is the probelm with Db2 v8
migration.
Thanks
Ravi
-
http://arnold.trembley.home.att.net/
？
--
http://arnold.trembley.home.att.net/
Arnold Trembley写道：
Arnold Trembley wrote:
我们不允许在我们的环境中使用动态SQL
安全风险和GLBA（Gramm-Leach-Bliley法案）。
http://en.wikipedia.org/wiki/Gramm-Leach-Bliley_Act
这只是你组织的一步已经采取了遵守，或者我们是否实际上有关于禁止动态SQL的书籍的法律？
-
~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~
~ / \ /〜住在新墨西哥州阿尔伯克基！ 〜
~ / \ / o ~~
~ / / \\ - - | ~daniel @ thebelowdomain~
~ _____ / \ | 〜 http://www.djs-consulting.com/linux/blog〜
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ b~GEEKCODE 3.12 GCS / IT d s - ：+ a C ++ L ++ E --- W ++ N ++ o？ K- w
Is that just a step your organization has taken to comply, or do we
actually have a law on the books prohibiting Dynamic SQL?
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~
~ / \ / ~ Live from Albuquerque, NM! ~
~ / \/ o ~ ~
~ / /\ - | ~ daniel@thebelowdomain ~
~ _____ / \ | ~ http://www.djs-consulting.com/linux/blog ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w
〜
~！O M-- V PS + PE ++ Y？ ！PGP t + 5？ X + R * tv b + DI ++ D + G-e~
~h ---- r +++ z ++++〜
~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ br />
谁更不合理？一个相信上帝的人，他没有看到，或者是一个被一个他不相信的上帝冒犯的男人？ - Brad Stine
~
~ !O M-- V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e ~
~ h---- r+++ z++++ ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~
"Who is more irrational? A man who believes in a God he doesn''t see, or
a man who''s offended by a God he doesn''t believe in?" - Brad Stine
这篇关于将DB2 V7迁移到V8 IN ibm z / os后获取SQLCODE -302的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
