Unanswered: DB2 mainframe external stored procedure help
I am using DB2 Mainframe V8 (z/OS).
I have an external stored procedure written in C. I have already compiled the C program and have obtained the binaries corresponding to the SQL part and the C part. Currently I copy the binaries as members of the DSN810.DBRMLIB.DATA and DSN810.RUNLIB.LOAD datasets respectively and then run the JCL for invoking them.
Can I copy the binaries to some other location and still run it correctly (i.e. still make sure the correct libraries are used etc.)? If yes, what are the changes I need to make to the JCL? This is the JCL I am using currently (ABC.ABC0 is the stored procedure and ABC0 is the C source file). Any input will be really appreciated. Thanks!!
IN VARCHAR(4096) CCSID EBCDIC,
OUT VARCHAR(880) CCSID EBCDIC )
MODIFIES SQL DATA
EXTERNAL NAME ABC0
PARAMETER STYLE GENERAL WITH NULLS
WLM ENVIRONMENT DB8GENV1
ASUTIME LIMIT 50
STAY RESIDENT NO
PROGRAM TYPE MAIN
RESULT SET 1
COMMIT ON RETURN NO;