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

How to run stored procedure in Command Line Processor

P: 3
I need to run a stored procedure in db2 Command Line Processor with two inputs and a CLOB output. I don't know how to call them via CLP to get the CLOB output.

The version of DB2 we use is 8.1.14

If you could provide me with sample code, I'd really appreciate you. I need this ASAP..
Sep 10 '07 #1
Share this Question
Share on Google+
2 Replies


P: 5
I need to run a stored procedure in db2 Command Line Processor with two inputs and a CLOB output. I don't know how to call them via CLP to get the CLOB output.

The version of DB2 we use is 8.1.14

If you could provide me with sample code, I'd really appreciate you. I need this ASAP..

Hiya,

try command
CALL <stored_proc name>(i/p,i/p,?)

You will have to leave the output parameter as ?. The command line processor with give you the o/p.

Regards,
Harish
Sep 11 '07 #2

P: 3
Thanks Harish, I tried that but it is throwing this error.

DB21103E The data type of parameter 3 is not supported by the CALL command in CLP.

The parameter 3 is CLOB output. Any Clue??
Sep 11 '07 #3

Post your reply

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