INFORMIX-ESQL/C Programmer's Manual ESQL/C Function Library

The ifx_int8todec() function converts an int8 type number into a decimal type number.

mint ifx_int8todec(int8_val,  dec_val)

	ifx_int8_t  *int8_val;

	dec_t    *dec_val;

 



int8_val  

is a pointer to an int8 structure whose value ifx_int8todec() converts to a decimal type value. 


dec_val

is a pointer to a decimal structure in which ifx_int8todec() places the result of the conversion. 

The file int8todec.ec in the demo directory contains the following sample program.

/*
* ifx_int8todec.ec *

The following program converts three strings to INT8 types and
converts the INT8 type values to decimal type values.
Then the values are displayed.

*/

#include <stdio.h>

EXEC SQL include "int8.h";
#define END sizeof(result)

char string1[] = "-12,555,444,333,786,456";
char string2[] = "480";
char string3[] = "5.2";
char result [40];

main()
{
mint x;
dec_t d;
ifx_int8_t num1, num2, num3;

printf("IFX_INT8TODEC Sample ESQL Program running.\n\n");

if (x = ifx_int8cvasc(string1, strlen(string1), &num1))
{
printf("Error %d in converting string1 to INT8\n", x);
exit(1);
}
if (x = ifx_int8cvasc(string2, strlen(string2), &num2))
{
printf("Error %d in converting string2 to INT8\n", x);
exit(1);
}
if (x = ifx_int8cvasc(string3, strlen(string3), &num3))
{
printf("Error %d in converting string3 to INT8\n", x);
exit(1);
}

printf("\n***Converting INT8 to decimal\n");
printf("\nString 1= %s\n", string1);
printf(" \nExecuting: ifx_int8todec(&num1,&d)");
if (x= ifx_int8todec(&num1, &d))
{
printf("\tError %d in converting INT8 to decimal\n", x);
exit(1);
}
else
{
printf("\nConverting Decimal to ASCII for display\n");
printf("Executing: dectoasc(&d, result, END, -1)\n");
if (x = dectoasc(&d, result, END, -1))
printf("\tError %d in converting DECIMAL1 to string\n", x);
else
{
result[END - 1] = '\0'; /* null terminate */
printf("Result = %s\n", result);
}
}
printf("\n***Converting second INT8 to decimal\n");
printf("\nString2 = %s\n", string2);
printf(" \nExecuting: ifx_int8todec(&num2, &d)");
if (x= ifx_int8todec(&num2, &d))
{
printf("\tError %d in converting INT8 to decimal\n", x);
exit(1);
}
else
{
printf("\nConverting Decimal to ASCII for display\n");
printf("Executing: dectoasc(&d, result, END, -1)\n");
if (x = dectoasc(&d, result, END, -1))
printf("\tError %d in converting DECIMAL2 to string\n", x);

else
{
result[END - 1] = '\0'; /* null terminate */
printf("Result = %s\n", result);
}
}
printf("\n***Converting third INT8 to decimal\n");
printf("\nString3 = %s\n", string3);
printf(" \nExecuting: ifx_int8todec(&num3, &d)");
if (x= ifx_int8todec(&num3, &d))
{
printf("\tError %d in converting INT8 to decimal\n", x);
exit(1);
}
else
{
printf("\nConverting Decimal to ASCII for display\n");
printf("Executing: dectoasc(&d, result, END, -1)\n");

/* note that the decimal is truncated */

if (x = dectoasc(&d, result, END, -1))
printf("\tError %d in converting DECIMAL3 to string\n", x);
else
{
result[END - 1] = '\0'; /* null terminate */
printf("Result = %s\n", result);
}
}
printf("\nIFX_INT8TODEC Sample Program over.\n\n");
exit(0);
}

IFX_INT8TODEC Sample ESQL Program running.





***Converting INT8 to decimal



String 1= -12,555,444,333,786,456

 

Executing: ifx_int8todec(&num1,&d)

Converting Decimal to ASCII for display

Executing: dectoasc(&d, result, END, -1)

Result = -12555444333786456.0



***Converting second INT8 to decimal



String2 = 480

 

Executing: ifx_int8todec(&num2, &d)

Converting Decimal to ASCII for display

Executing: dectoasc(&d, result, END, -1)

Result = 480.0



***Converting third INT8 to decimal



String3 = 5.2

 

Executing: ifx_int8todec(&num3, &d)

Converting Decimal to ASCII for display

Executing: dectoasc(&d, result, END, -1)

Result = 5.0



IFX_INT8TODEC Sample Program over.