Solved

Convert int, double to iDB2Numeric

Posted on 2008-10-01
1
491 Views
Last Modified: 2012-05-05
I need to convert an int and a double value to iDB2Numeric to be used in the call to the stored procedure in iDB2.

Does anyone know how to do this?  I'm using C#
0
Comment
Question by:weimha
1 Comment
 
LVL 5

Accepted Solution

by:
johnaryan earned 500 total points
ID: 22615208
This site explains the conversion of DB2 types to C, they should be similar to c#.
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.odbc/db2z_numsqc.htm
Once you find out how many bytes a DB2 Numeric value is you can then find out how many bytes an int or decimal uses by using
Console.WriteLine(sizeof(int))
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

856 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