Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Tue Oct 11, 2005 10:48 am Post subject: VALIDPROC could not be loaded. Why ?
Hi,
I have coded a VALIDPROC, called V1. When this is not present in SDSNLOAD, I get a proper -904 message. When I put it in there and try to do an INSERT, I get this message in JESMSGLG:
Code:
DSN3201I @ ABNORMAL EOT IN PROGRESS FOR USER=XXXXYY
CONNECTION-ID=TSO CORRELATION-ID=XXXXYY JOBNAME=XXXXYY TCB=005A96A0
There is no specific message/SQLCODE that explains exactly what is the
problem.
Somewhere above in JESMSGLG, I also see
Code:
DSNI008I @ DATA BASE VALIDATION PROCEDURE V1 COULD NOT BE LOADED
What is failing? Where do I start my search from to fix this ? _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
Posted: Tue Oct 11, 2005 11:06 am Post subject:
Kolusu,
I was referring to the same link as posted by you. I have the PDF itself.
The manual is clear about the language being Assembler. So, it is in Assembler. But, since I am not good enough in Assembler, I am receiving the parameter list from DB2 and then simply passing the R1 to a PL/I program called via LINK macro. The PL/1 program does the real validation. _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum