The following defines are associated with the sDatatype member of DP_FIELD_DEF structure
|
#define ODPPDATATYPE_CHAR 1 |
- Description:
Fixed size character data which is left justified and space padded. For this data type, it is mandatory to set #iSrcBufLen to the number of bytes of data in #pSrcBuf of the DP_FIELD_DATA_DEF structure.
#define ODPPDATATYPE_VARCHAR 2 |
- Description:
Character data starting with a short integer value which indicates the length, in bytes, of the character data to follow.
#define ODPPDATATYPE_VARCHAR_SZ 3 |
- Description:
Character data string which is terminated by a NULL character.
#define ODPPDATATYPE_WCHAR 4 |
- Description:
Fixed size wide character data which is left justified and space padded. For this data type, it is mandatory to set #iSrcBufLen to the number of bytes of data in #pSrcBuf of the DP_FIELD_DATA_DEF structure.
#define ODPPDATATYPE_WVARCHAR 5 |
- Description:
Wide character data starting with a short integer value which indicates the length, in bytes, of the wide character data to follow.
#define ODPPDATATYPE_WVARCHAR_SZ 6 |
- Description:
Wide character data string which is terminated by a NULL character.
#define ODPPDATATYPE_LONG_LONG 7 |
- Description:
8 byte signed numeric value.
- Range of Values:
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
#define ODPPDATATYPE_U_LONG_LONG 8 |
- Description:
8 byte unsigned numeric value.
- Range of Values:
0 to 18,446,744,073,709,551,615
#define ODPPDATATYPE_INTEGER 9 |
- Description:
4 byte signed integer value.
- Range of Values:
-2,147,483,648 to 2,147,483,647
#define ODPPDATATYPE_U_INTEGER 10 |
- Description:
4 byte unsigned integer value.
- Range of Values:
0 to 4,294,967,295
#define ODPPDATATYPE_DECIMAL_370 13 |
- Description:
Packed decimal encoded buffer.
#define ODPPDATATYPE_ODBC_DATE 14 |
- Description:
This data type is used when the source value is a ODPP_ODBC_DATE structure.
#define ODPPDATATYPE_ODBC_TIME 15 |
- Description:
This data type is used when the source value is a ODPP_ODBC_TIME structure.
#define ODPPDATATYPE_ODBC_TIMESTAMP 16 |
#define ODPPDATATYPE_DATETIME_SZ 17 |
- Description:
Source value is a character data string containing date-time values and is terminated by a NULL character. To format this data type value the caller must supply a format string using parameter ODPP_OPR_SOURCE_DATE_FORMAT.
Use any of the following valid format specifiers for formatting the date time strings to a date-time structure or vice-versa. All the specifiers start with a (%) sign.
Year | Month | Day | Time | Fraction of a second | AM/PM |
YYYY | MONTH | DD | HH | FFFFFF | PM |
YY | MMM | | MI | FFFFF | |
| MM | | SS | FFFF | |
| | | HH24 | FFF | |
| | | | FF | |
| | | | F | |
For example, to format a date string as 4 digit year, 3 character month, 2 digit date separated by a DASH (-), the format string will be "%YYYY-%MMM-%DD".
#define ODPPDATATYPE_DATETIME_WSZ 18 |
- Description:
Source value is a wide character data string containing date-time values and is terminated by a NULL character. To format this data type value the caller must supply a format string using parameter ODPP_OPR_SOURCE_DATE_FORMAT.
Use any of the following valid format specifiers for formatting the date time strings to a date-time structure or vice-versa. All the specifiers start with a (%) sign.
Year | Month | Day | Time | Fraction of a second | AM/PM |
YYYY | MONTH | DD | HH | FFFFFF | PM |
YY | MMM | | MI | FFFFF | |
| MM | | SS | FFFF | |
| | | HH24 | FFF | |
| | | | FF | |
| | | | F | |
For example, to format a date string as 4 digit year, 3 character month, 2 digit date separated by a DASH (-), the format string will be "%YYYY-%MMM-%DD".
#define ODPPDATATYPE_DOUBLE 19 |
- Description:
Double precision floating point number.
- Range of Values:
1.7E +/- 308 (15 digits)
#define ODPPDATATYPE_FLOAT 20 |
- Description:
Floating point number.
- Range of Values:
3.4E +/- 38 (7 digits)
#define ODPPDATATYPE_SMALLINT 21 |
- Description:
2 byte signed integer value.
- Range of Values:
-32,768 to 32,767
#define ODPPDATATYPE_USMALLINT 22 |
- Description:
2 byte unsigned integer value.
- Range of Values:
0 to 65,535
#define ODPPDATATYPE_TINYINT 23 |
- Description:
Single byte signed integer value.
- Range of Values:
-128 to 127
#define ODPPDATATYPE_UTINYINT 24 |
- Description:
Single byte unsigned integer value.
- Range of Values:
0 to 255
#define ODPPDATATYPE_DATETIME_CHAR 25 |
- Description:
Source value is a fixed size character data which is left justified and space padded and contains date-time values. For this data type, it is mandatory to set #iSrcBufLen to the number of bytes of data in #pSrcBuf of the DP_FIELD_DATA_DEF structure. To format this data type value the caller must supply a format string using parameter ODPP_OPR_SOURCE_DATE_FORMAT.
Use any of the following valid format specifiers for formatting the date time strings to a date-time structure or vice-versa. All the specifiers start with a (%) sign.
Year | Month | Day | Time | Fraction of a second | AM/PM |
YYYY | MONTH | DD | HH | FFFFFF | PM |
YY | MMM | | MI | FFFFF | |
| MM | | SS | FFFF | |
| | | HH24 | FFF | |
| | | | FF | |
| | | | F | |
For example, to format a date string as 4 digit year, 3 character month, 2 digit date separated by a DASH (-), the format string will be "%YYYY-%MMM-%DD".
#define ODPPDATATYPE_DATETIME_VARCHAR 26 |
- Description:
Source value is character data starting with a short integer value which indicates the length, in bytes, of the character data containing date-time values to follow. To format this data type value the caller must supply a format string using parameter ODPP_OPR_SOURCE_DATE_FORMAT.
Use any of the following valid format specifiers for formatting the date time strings to a date-time structure or vice-versa. All the specifiers start with a (%) sign.
Year | Month | Day | Time | Fraction of a second | AM/PM |
YYYY | MONTH | DD | HH | FFFFFF | PM |
YY | MMM | | MI | FFFFF | |
| MM | | SS | FFFF | |
| | | HH24 | FFF | |
| | | | FF | |
| | | | F | |
For example, to format a date string as 4 digit year, 3 character month, 2 digit date separated by a DASH (-), the format string will be "%YYYY-%MMM-%DD".
#define ODPPDATATYPE_DATETIME_WCHAR 27 |
- Description:
Source value is a fixed size wide character data which is left justified and space padded and contains date-time values. For this data type, it is mandatory to set #iSrcBufLen to the number of bytes of data in #pSrcBuf of the DP_FIELD_DATA_DEF structure. To format this data type value the caller must supply a format string using parameter ODPP_OPR_SOURCE_DATE_FORMAT.
Use any of the following valid format specifiers for formatting the date time strings to a date-time structure or vice-versa. All the specifiers start with a (%) sign.
Year | Month | Day | Time | Fraction of a second | AM/PM |
YYYY | MONTH | DD | HH | FFFFFF | PM |
YY | MMM | | MI | FFFFF | |
| MM | | SS | FFFF | |
| | | HH24 | FFF | |
| | | | FF | |
| | | | F | |
For example, to format a date string as 4 digit year, 3 character month, 2 digit date separated by a DASH (-), the format string will be "%YYYY-%MMM-%DD".
#define ODPPDATATYPE_DATETIME_WVARCHAR 28 |
- Description:
Source value is wide character data starting with a short integer value which indicates the length, in bytes, of the wide character data containing date-time values to follow. To format this data type value the caller must supply a format string using parameter ODPP_OPR_SOURCE_DATE_FORMAT.
Use any of the following valid format specifiers for formatting the date time strings to a date-time structure or vice-versa. All the specifiers start with a (%) sign.
Year | Month | Day | Time | Fraction of a second | AM/PM |
YYYY | MONTH | DD | HH | FFFFFF | PM |
YY | MMM | | MI | FFFFF | |
| MM | | SS | FFFF | |
| | | HH24 | FFF | |
| | | | FF | |
| | | | F | |
For example, to format a date string as 4 digit year, 3 character month, 2 digit date separated by a DASH (-), the format string will be "%YYYY-%MMM-%DD".
#define ODPPDATATYPE_ORA_VARNUM 101 |
- Description:
Oracle Varnum encoded buffer.
#define ODPPDATATYPE_GRAPHIC 111 |
- Range of Values:
[NOT USED]
#define ODPPDATATYPE_VARGRAPHIC 112 |
- Range of Values:
[NOT USED]