Unix Technical Forum

DB2 Command Question

This is a discussion on DB2 Command Question within the DB2 forums, part of the Database Server Software category; --> I am trying to call a stored procedure using DB2 connect 7.2, first from the the command line then, ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-26-2008, 06:02 PM
Rich Villanova
 
Posts: n/a
Default DB2 Command Question

I am trying to call a stored procedure using DB2 connect 7.2, first
from the the command line then, from within SQL Server. However,
whenever I call a stored procedure with an output parameter it bombs
with a SQL0104N error. Has anyone seen this before or has anyone ever
call a stored procedure with an output parameter.

Thanks,
Richard Villanova
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-26-2008, 06:03 PM
Amit
 
Posts: n/a
Default Re: DB2 Command Question

use ? as a placeholder for each output parameter.


e.g. call db2admin.fooproc( 3,2,?,? );
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:16 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com