在错误消息中存储Proc'Offending Line Number？ [英] Stored Proc' Offending Line Number in error message?

问题描述

大家好，


当我们运行存储过程并导致未处理的错误时，db2 udb返​​回的

错误消息不包含

导致错误的行号。这使得调试这些过程非常困难。


Oracle消息中始终存在行号。当我用Google搜索

时，我看到有些人在其中显示带有

行号的DB2 Stored Proc错误消息（如LINE NUMBER = 1285），这让我相信

应该有某种选项来包含行

数字。


我该怎么做？


DB21085I实例" dbidev02"使用64和64。位和DB2代码发布

" SQL08021"

，级别标识符为03020106。

信息标记为DB2 v8.1.1 .80"，" special_13823"，

" U800400_13823"和

FixPak" 8"。


谢谢为你的帮助

Bogdan

Hi guys,

when we run a stored proc and it results into an unhandled error, the
error message returned by db2 udb does not contain a line number that
caused an error. This makes it pretty difficult to debug those procs.

Line number have always been there in Oracle messages. When I Googled
on this, I saw some people showing DB2 Stored Proc error messages with
line numbers in them (like LINE NUMBER=1285), which makes me believe
that there should be some sort of option to turn inclusion of line
numbers on.

How do I do that?

DB21085I Instance "dbidev02" uses "64" bits and DB2 code release
"SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.1.80", "special_13823",
"U800400_13823", and
FixPak "8".

Thanks for your help
Bogdan

推荐答案

存储的PROCEDURE可以用调试信息编译然后运行<调试模式下的
。 DB2 Tools包括开发中心，它可以为您处理这个问题。


B.

A stored PROCEDURE can be compiled with debug information and then run
in debug mode. The DB2 Tools includes Development Center which can
handle this for you.

B.

谢谢Brian。是否有某种API我可以用来切换到

调试模式并以编程方式返回？

Thank you Brian. Is there an API of some sort I could use to switch to
debug mode and back programmatically?

我不知道。文档应用程序开发指南：

编程服务器应用程序在第2章开发例程中，

部分调试例程说使用开发中心。


虽然看中心的代码，但肯定是在做什么。也许其他人可以对这个过程有所了解。


B.

I have no idea. The documentation "Application Development Guide:
Programming Server Applications" in Chapter 2 "Developing Routines",
Section "Debugging Routines" says to use the development center.

Watching the code in the center though, it is definitely doing
something. Perhaps someone else can shed some light on the process.

B.

这篇关于在错误消息中存储Proc'Offending Line Number？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！