By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,286 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,286 IT Pros & Developers. It's quick & easy.

DB2 function

P: 1
Hi


I have a db2 function which is mapped to cobol db2 sp mpdntes1.

This cobol db2 sp is returning sqlcode to my function.

When I execute this function using below query , get -805 error

SELECT CURRENT DATE , dB2TDEV.MPDNTES1(10,10) FROM SYSIBM.SYSDUMMY1;

------------------------------------------------------------------------------------

CREATE function DB2TDEV.MPDNTES1(INTEGER,INTEGER)

RETURNS int

EXTERNAL NAME 'MPDNTES1'

PARAMETER STYLE DB2SQL

WLM ENVIRONMENT DB2TSP
COLLID TGTT1

LANGUAGE COBOL;

-------------------------------------------

How do I solve this -805 error
Aug 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.