Solved

Convert int, double to iDB2Numeric

Posted on 2008-10-01
1
483 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Windows Service to Receive TCP Packets 4 118
Office.Interop.Word Document - Detect Macros not working 16 36
Syntax error 9 45
Web Form VB.Net  import CSV 4 21
Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

919 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now