Optim Data Privacy Providers  11.3.0
 All Data Structures Files Functions Variables Macros Groups Pages
ODPP Data Types

The following defines are associated with the sDatatype member of DP_FIELD_DEF structure

#define ODPPDATATYPE_CHAR   1
 
#define ODPPDATATYPE_VARCHAR   2
 
#define ODPPDATATYPE_VARCHAR_SZ   3
 
#define ODPPDATATYPE_WCHAR   4
 
#define ODPPDATATYPE_WVARCHAR   5
 
#define ODPPDATATYPE_WVARCHAR_SZ   6
 
#define ODPPDATATYPE_LONG_LONG   7
 
#define ODPPDATATYPE_U_LONG_LONG   8
 
#define ODPPDATATYPE_INTEGER   9
 
#define ODPPDATATYPE_U_INTEGER   10
 
#define ODPPDATATYPE_DECIMAL_370   13
 
#define ODPPDATATYPE_ODBC_DATE   14
 
#define ODPPDATATYPE_ODBC_TIME   15
 
#define ODPPDATATYPE_ODBC_TIMESTAMP   16
 
#define ODPPDATATYPE_DATETIME_SZ   17
 
#define ODPPDATATYPE_DATETIME_WSZ   18
 
#define ODPPDATATYPE_DOUBLE   19
 
#define ODPPDATATYPE_FLOAT   20
 
#define ODPPDATATYPE_SMALLINT   21
 
#define ODPPDATATYPE_USMALLINT   22
 
#define ODPPDATATYPE_TINYINT   23
 
#define ODPPDATATYPE_UTINYINT   24
 
#define ODPPDATATYPE_DATETIME_CHAR   25
 
#define ODPPDATATYPE_DATETIME_VARCHAR   26
 
#define ODPPDATATYPE_DATETIME_WCHAR   27
 
#define ODPPDATATYPE_DATETIME_WVARCHAR   28
 
#define ODPPDATATYPE_ORA_VARNUM   101
 
#define ODPPDATATYPE_GRAPHIC   111
 
#define ODPPDATATYPE_VARGRAPHIC   112
 

Detailed Description

Macro Definition Documentation

#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.
  • Range of Values:
    N/A
#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.
  • Range of Values:
    N/A
#define ODPPDATATYPE_VARCHAR_SZ   3
  • Description:
    Character data string which is terminated by a NULL character.
  • Range of Values:
    N/A
#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.
  • Range of Values:
    N/A
#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.
  • Range of Values:
    N/A
#define ODPPDATATYPE_WVARCHAR_SZ   6
  • Description:
    Wide character data string which is terminated by a NULL character.
  • Range of Values:
    N/A
#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.
  • Range of Values:
    N/A
#define ODPPDATATYPE_ODBC_DATE   14
  • Description:
    This data type is used when the source value is a ODPP_ODBC_DATE structure.
  • Range of Values:
    N/A
#define ODPPDATATYPE_ODBC_TIME   15
  • Description:
    This data type is used when the source value is a ODPP_ODBC_TIME structure.
  • Range of Values:
    N/A
#define ODPPDATATYPE_ODBC_TIMESTAMP   16
  • Description:
    This data type is used when the source value is a ODPP_ODBC_TIMESTAMP structure.
  • Range of Values:
    N/A
#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.

    YearMonthDayTimeFraction of a secondAM/PM
    YYYYMONTHDDHHFFFFFFPM
    YYMMMMIFFFFF
    MMSSFFFF
    HH24FFF
    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".
  • Range of Values:
    N/A
#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.

    YearMonthDayTimeFraction of a secondAM/PM
    YYYYMONTHDDHHFFFFFFPM
    YYMMMMIFFFFF
    MMSSFFFF
    HH24FFF
    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".
  • Range of Values:
    N/A
#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.

    YearMonthDayTimeFraction of a secondAM/PM
    YYYYMONTHDDHHFFFFFFPM
    YYMMMMIFFFFF
    MMSSFFFF
    HH24FFF
    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".
  • Range of Values:
    N/A
#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.

    YearMonthDayTimeFraction of a secondAM/PM
    YYYYMONTHDDHHFFFFFFPM
    YYMMMMIFFFFF
    MMSSFFFF
    HH24FFF
    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".
  • Range of Values:
    N/A
#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.

    YearMonthDayTimeFraction of a secondAM/PM
    YYYYMONTHDDHHFFFFFFPM
    YYMMMMIFFFFF
    MMSSFFFF
    HH24FFF
    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".
  • Range of Values:
    N/A
#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.

    YearMonthDayTimeFraction of a secondAM/PM
    YYYYMONTHDDHHFFFFFFPM
    YYMMMMIFFFFF
    MMSSFFFF
    HH24FFF
    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".
  • Range of Values:
    N/A
#define ODPPDATATYPE_ORA_VARNUM   101
  • Description:
    Oracle Varnum encoded buffer.
  • Range of Values:
    N/A
#define ODPPDATATYPE_GRAPHIC   111
  • Description:
    [NOT USED]
  • Range of Values:
    [NOT USED]
#define ODPPDATATYPE_VARGRAPHIC   112
  • Description:
    [NOT USED]
  • Range of Values:
    [NOT USED]