ca.portal.admin

Re:Debugging database procedures

Discussion created by ca.portal.admin on Mar 29, 2007
What techniques are available for debugging database procedures? I am
talking here about the kind that are tied to a record via the schema
description.

We are getting D003 errors when trying to use DEBUG. Is DEBUG supposed
to work with database procedures?

My personal favorite technique for debugging online programs is
""displaying"" to the log via the WTL command. But you are not supposed
to make DML calls from a database procedure.

Any suggestions would be most welcome.

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Debugging database procedures
"Oh wonderful. Then on entry to your assembler routine register 11 will
have addressability to a storage area into which you can write log info.
That's providing you sysgen an ISA with your program definition. It
doesn't matter whether it's running in system mode or not, as long as
the program is defined to IDMS, IDMS loaded it, inited it, and gives
control to it.

Lutz Petzold





-----------------------------------------
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Debugging database procedures
"Yes, it is written in assembler.

Outcomes