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
Debugging database procedures
"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: Drawing for free CA WORLD 2007 registration
"Greetings from Brussels too.

For our European IDMS colleagues who have the intention to attend
CA-world. Please contact you regional user group chairman
We will forward your Email address in the drawing for the free
registration.

Best regards
Jan Rabaut
EIUA chair

Outcomes