VALIDPROC could not be loaded. Why ?
Select messages from
# through # FAQ
[/[Print]\]

MVSFORUMS.com -> Database

#1: VALIDPROC could not be loaded. Why ? Author: Cogito-Ergo-SumLocation: Bengaluru, INDIA PostPosted: Tue Oct 11, 2005 10:48 am
    —
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 ?

#2:  Author: kolusuLocation: San Jose PostPosted: Tue Oct 11, 2005 11:02 am
    —
Cogito-Ergo-Sum,

what is the language used to code the validproc ?

Check this link which might help you

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAGH10/APPENDIX1.2.4?DT=20010212102121

Kolusu

#3:  Author: Cogito-Ergo-SumLocation: Bengaluru, INDIA PostPosted: Tue Oct 11, 2005 11:06 am
    —
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.



MVSFORUMS.com -> Database


output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1

Powered by phpBB © 2001, 2005 phpBB Group