GBase 8s ESQL/C 编程指南
南大通用数据技术股份有限公司
- 763 -
ifx_int8soint() 函数将 int8 类型数值转换为 C int 类型数值。
语法
mint ifx_int8soint(int8_val, int_val)
ifx_int8_t *int8_val;
mint *int_val;
int8_val
指向 ifx_int8soint() 将其值转换为 mint 类型值的 int8 结构的指针。
int_val
指向 ifx_int8soint() 放置转换的结果处的 mint 值的指针。
用法
ifx_int8soint() 库函数将 int8 值转换为 C 整数。C 整数的大小依赖于您正在使用的
计算机的硬件和操作系统。因此,ifx_int8soint() 函数将整数值与 SQL SMALLINT 数据类
型同等看待。SMALLINT 的有效范围在 32767 与 -32767 之间。要将较大的 int8 值转换
为较大的整数,请使用 ifx_int8solong() 库函数。
返回代码
0
转换成功。
<0
转换失败。
示例
demo 目录中的文件 int8soint.ec 包含下列样例程序。
/*
* ifx_int8soint.ec *
The following program converts three strings to INT8 types and
converts the INT8 type values to C integer type values.
Then the values are displayed.
*/
GBase 8s ESQL/C 编程指南
南大通用数据技术股份有限公司
- 764 -
#include
EXEC SQL include "int8.h";
char string1[] = "-12,555";
char string2[] = "480";
char string3[] = "5.2";
main()
{
mint x;
mint i =0;
ifx_int8_t num1, num2, num3;
printf("IFX_INT8sOINT 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("\nConverting INT8 to integer\n");
if (x= ifx_int8soint(&num1, &i))
{
GBase 8s ESQL/C 编程指南
南大通用数据技术股份有限公司
- 765 -
printf("\tError %d in converting INT8 to integer\n", x);
exit(1);
}
else
{
printf("String 1= %s\n", string1);
printf("INT8 value is = %d\n", i);
}
printf("\nConverting second INT8 to integer\n");
if (x= ifx_int8soint(&num2, &i))
{
printf("\tError %d in converting INT8 to integer\n", x);
exit(1);
}
else
{
printf("String2 = %s\n", string2);
printf("INT8 value is = %d\n", i);
}
printf("\nConverting third INT8 to integer\n");
/* note that the decimal will be truncated */
if (x= ifx_int8soint(&num3, &i))
{
printf("\tError %d in converting INT8 to integer\n", x);
exit(1);
}
else
{
printf("String3 = %s\n", string3);
printf("INT8 value is = %d\n",i);
}
GBase 8s ESQL/C 编程指南
南大通用数据技术股份有限公司
- 766 -
printf("\nIFX_INT8sOINT Sample Program over.\n\n");
exit(0);
}
输出
IFX_INT8sOINT Sample ESQL Program running.
Converting INT8 to integer
Executing: ifx_int8soint(&num1,&i)
String 1= -12,555
The value of the first integer is = -12555
Converting second INT8 to integer
Executing: ifx_int8soint(&num2, &i)
String2 = 480
The value of the second integer is = 480
Converting third INT8 to integer
Executing: ifx_int8soint(&num3, &i)
String3 = 5.2
The value of the third integer is = 5
IFX_INT8sOINT Sample Program over.