!关于decimal数据类型的问题？？请指教！

sxf2000

在安装的DB2中，怎么没找到decmail.h头文件？
如何定义DECIMAI类型的宿主变量？

Law

不用定义，他和c有对应的数据类型
SQL Column Type(TNTA1)  C/C++ Data Type  SQL Column Type Description  

SMALLINT
(500 or 501)


short
short int
sqlint16

16-bit signed integer  

INTEGER
(496 or 497)


long
long int
sqlint32(TNTA1A)

32-bit signed integer  

BIGINT
(492 or 493)


long long
long
__int64
sqlint64(TNTA1B)

64-bit signed integer  

REAL(TNTA2)
(480 or 481)

float  Single-precision floating point  

DOUBLE(TNTA3)
(480 or 481)

double  Double-precision floating point  

DECIMAL(p,s)
(484 or 485)

No exact equivalent; use double  Packed decimal
(Consider using the CHAR and DECIMAL functions to manipulate packed decimal fields as character data.)


CHAR(1)
(452 or 453)

char  Single character  

CHAR(n)
(452 or 453)

No exact equivalent; use char[n+1] where n is large enough to hold the data
1<=n<=254
Fixed-length character string  

VARCHAR(n)
(448 or 449)


struct tag {
short int;
char[n]
}
  
1<=n<=32 672

Non null-terminated varying character string with 2-byte string length indicator  
Alternately use char[n+1] where n is large enough to hold the data
1<=n<=32 672
null-terminated variable-length character string Note: Assigned an SQL type of 460/461.  


LONG VARCHAR
(456 or 457)


struct tag {
short int;
char[n]
}
  
32 673<=n<=32 700

Non null-terminated varying character string with 2-byte string length indicator  

CLOB(n)
(408 or 409)


sql type is
clob(n)
  
1<=n<=2 147 483 647

Non null-terminated varying character string with 4-byte string length indicator  

CLOB locator variable(TNTA4)
(964 or 965)


sql type is
clob_locator

Identifies CLOB entities residing on the server  

CLOB file reference variable(TNTA4)
(920 or 921)


sql type is
clob_file

Descriptor for file containing CLOB data  

BLOB(n)
(404 or 405)


sql type is
blob(n)
  
1<=n<=2 147 483 647

Non null-terminated varying binary string with 4-byte string length indicator  

BLOB locator variable(TNTA4)
(960 or 961)


sql type is
blob_locator

Identifies BLOB entities on the server  

BLOB file reference variable(TNTA4)
(916 or 917)


sql type is
blob_file

Descriptor for the file containing BLOB data  

DATE
(384 or 385)

null-terminated character form  Allow at least 11 characters to accommodate the null-terminator.  
VARCHAR structured form  Allow at least 10 characters.  

TIME
(388 or 389)

null-terminated character form  Allow at least 9 characters to accommodate the null-terminator.  
VARCHAR structured form  Allow at least 8 characters.  

TIMESTAMP
(392 or 393)

null-terminated character form  Allow at least 27 characters to accommodate the null-terminator.  
VARCHAR structured form  Allow at least 26 characters.  
Note: The following data types are only available in the DBCS or EUC environment when precompiled with the WCHARTYPE NOCONVERT option.  


GRAPHIC(1)
(468 or 469)

sqldbchar  Single double-byte character  

GRAPHIC(n)
(468 or 469)

No exact equivalent; use sqldbchar[n+1] where n is large enough to hold the data
1<=n<=127
Fixed-length double-byte character string  

VARGRAPHIC(n)
(464 or 465)


struct tag {
short int;
sqldbchar[n]
}
  
1<=n<=16 336

Non null-terminated varying double-byte character string with 2-byte string length indicator  
Alternately use sqldbchar[n+1] where n is large enough to hold the data
1<=n<=16 336
null-terminated variable-length double-byte character string Note: Assigned an SQL type of 400/401.  


LONG VARGRAPHIC
(472 or 473)


struct tag {
short int;
sqldbchar[n]
}
  
16 337<=n<=16 350

Non null-terminated varying double-byte character string with 2-byte string length indicator  
Note: The following data types are only available in the DBCS or EUC environment when precompiled with the WCHARTYPE CONVERT option.  


GRAPHIC(1)
(468 or 469)

wchar_t  Single wide character (for C-type)
Single double-byte character (for column type)



GRAPHIC(n)
(468 or 469)

No exact equivalent; use wchar_t [n+1] where n is large enough to hold the data
1<=n<=127
Fixed-length double-byte character string  

VARGRAPHIC(n)
(464 or 465)


struct tag {
short int;
wchar_t [n]
}

1<=n<=16 336

Non null-terminated varying double-byte character string with 2-byte string length indicator  
Alternately use char[n+1] where n is large enough to hold the data
1<=n<=16 336
null-terminated variable-length double-byte character string Note: Assigned an SQL type of 400/401.  


LONG VARGRAPHIC
(472 or 473)


struct tag {
short int;
wchar_t [n]
}
  
16 337<=n<=16 350

Non null-terminated varying double-byte character string with 2-byte string length indicator  
Note: The following data types are only available in the DBCS or EUC environment.  


DBCLOB(n)
(412 or 413)


sql type is
dbclob(n)
  
1<=n<=1 073 741 823

Non null-terminated varying double-byte character string with 4-byte string length indicator  

DBCLOB locator variable(TNTA4)
(968 or 969)


sql type is
dbclob_locator

Identifies DBCLOB entities residing on the server  

DBCLOB file reference
variable(TNTA4)
(924 or 925)


sql type is
dbclob_file

Descriptor for file containing DBCLOB data


我没有排版，你自己排吧，，

你可以在信息中心里面搜索到，，
关键字：
Supported SQL Data Types in C and C++