Solved

about db2 store procedure

Posted on 2004-08-15
1
346 Views
Last Modified: 2013-11-20
i create a store procedure  in db2 ,it have two parameter :one is input ,the other is output,i dont know how to call this store procedure in visual c++!who can give some information ?thanks
0
Comment
Question by:fyf7262284
1 Comment
 
LVL 39

Accepted Solution

by:
itsmeandnobodyelse earned 40 total points
ID: 11815315
Look at this sample of MSDN:

SQLUINTEGER PartID;
SQLINTEGER  PartIDInd = 0;

// Bind the parameter.
SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER, 0, 0,
       &PartID, 0, PartIDInd);

// Place the department number in PartID.
PartID = 544;

// Execute the statement.
SQLExecDirect(hstmt, "{call PARTS_IN_ORDERS(?)}", SQL_NTS);

SQL_PARAM_INPUT_OUTPUT defines an argument that is input and output, while SQL_PARAM_OUTPUT defines the return value that must be declared like that:

   {?=call GetNextEmpID}

You may either use SQLPrepare + SQLExecute or SQLExecDirect to invoke Stored Procedures after defining the parametres by SQLBindParameter.

Regards, Alex
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: Displaying information on the statusbar.   Continuing from the third article about sudoku.   Open the project in visual studio. Status bar – let’s display the timestamp there.  We need to get the timestamp from the document s…
Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question