Oracle® Database Gateway for VSAM User's Guide 11g Release 2 (11.2) Part Number E1207301 


View PDF 
This appendix contains the following section:
The gateway converts atomic data types in the advanced data dictionary (ADD) to Oracle data types as described in Table A1.
ADD Data Type  Oracle Data Type  Details 



Date packed into a 4character string. Format: DMYY Example: 23Jul1998 is represented by four bytes: 19, 98, 7, and 23. 


ADD datetime format. 


Single bit within a byte. Size: 1 byte. Format:
Where n specifies which bit (within a byte) the field uses. If more than one bit is defined, then the additional bits may be defined sequentially within the same byte (or bytes, if the number of bits requires this much space). 


A signed number of bits within a byte. Size: 1 bit to 1 byte Format: Where n specifies which bit (within a byte) to start from and m is the number of bits. If n is not specified then n defaults to 1 for the first occurrence of the field and is contiguous thereafter. The maximum number of bits you can map is 32. 


A nullterminated string of alphanumeric characters; maximum length must be specified. An extra byte is required for the null flag. 


CorVision datetime format. 


Date format. 


Date in a string having the form YYMMDD 


Date in a string having the form YYYYMMDD 


Double floatingpoint number ( Size: 8 bytes Range: 0.29E38 to 1.7E38 Precision: 16 digits. 

RAW 
Allocation for future use, string type; length must be specified. 


A fixed nullterminated string of numeric characters; length must be specified. An extra byte is required for the null flag. 


Signed byte integer. Size: 1 byte Range: 128 to +127 


Signed word integer. Size: 1 byte Range: 32768 to +32767 


Signed integer Size: 3 bytes 


Signed long integer. Size: 4 bytes Range: 2147483648 to +2147483647 


Signed integer Size: 6 bytes 


Date in a fourbyte integer having the form YYMMDD or YYYYMMDD. Example, 23Jul1998 has the form: 980723 or 19980723. 


Julian date Size: 2 bytes Bits 06: (noncentury) year Bits 715: day of the year 


Signed long integer Values: 1 for 

DATE 
z/OS date format. 


z/OS datetime format. 


z/OS time format. 


Padded date format, not nullterminated. 


Padded date format, not nullterminated. 


Padded date format, not nullterminated. 


Size: 2 bytes Bits 06: (noncentury) year Bits 710: number of month Bits 1115: day of month 


Single floatingpoint number (F_FLOAT). Size: 4 bytes Range: 0.29E38 to 1.7E38 Precision: 6 digits 


Atomic date string Size: 10 characters Format: YYYYMMDD 


Atomic datetime string. Size: 19 characters Format: YYYYMMDD HH:MM:SS 


Atomic date string Size: 8 characters Format: HH:MM:SS 


String of alphanumeric characters; length must be specified. 


Time format. 


Datetime format. 


An unsigned number of bits within a byte. Size: 1 bit to 1 byte Format: Where n specifies which bit (within a byte) to start from and m is the number of bits. If n is not specified, then n defaults to1 for the first occurrence of the field and its contiguous thereafter. The maximum number of bits you can map is 31. 


Unsigned byte integer. Size: 1 byte Range: 0 to +254 


Unsigned word integer. Size: 2 bytes Range: 0 to+65534 


Signed long integer Size: 4 bytes Range: 0 to +4,294,967,294 


Unsigned integer. Size: 6 bytes 


A nullterminated alphanumeric unicode string. Maximum length must be specified. 


16bit count, followed by a string. 


32bit count, followed by a string. 
The gateway converts nonatomic data types to Oracle data types as described in Table A2.
The gateway converts decimal data types to Oracle data types as described in Table A3.
ADD Data Type  Oracle Data Type  Details 



Packed decimal Maximum number of digits: 31 Maximum fractions: 11 Length = int (number of digits/2) + 1 bytes 


A nullterminated string of numeric characters; maximum length must be specified. An extra byte is required for the null flag. 


Signed numeric string. Sign is the first character of the string. Maximum number of digits: 31 Maximum fractions: 11 Note: the number of fractions includes the decimal point. 


Signed numeric string. A left overpunched sign is implemented. Maximum number of digits: 31 Maximum fractions: 11 


Signed numeric string. Sign is the first character of the string. Maximum number of digits: 31 Maximum fractions: 11 


Signed numeric string. Sign is the last character of the string. Maximum number of digits: 31 Maximum fractions: 11 


Signed numeric string. A right overpunched sign is implemented. Maximum number of digits: 31 Maximum fractions: 11 The number must be rightjustified (for example, "1234N" is 12345). The number can be leftpadded by either spaces or zeros. If a scale is provided, it is a fixed positional scale. No decimal point is provided in the data (for example, a value of "1234E" with scale 2 is interpreted as "123.45"). 


Unsigned numeric string. Maximum number of digits: 31 Maximum fractions: 11 


Signed numeric string Maximum number of digits: 31 Maximum fractions: 11 
The gateway converts scaled data types to Oracle data types as described in Table A4.
ADD Data Type  Oracle Data Type  Details 



Signed byte integer. Size: 1 byte Range: 128 to +127 Maximum: 3 


Single word integer. Size: 2 bytes Range: 32768 to +32767 Maximum: 5 


Signed integer. Size: 3 bytes 


Signed long integer. Size: 4 bytes Range: 2147483648 to +2147483647 Maximum: 10 


Signed integer Size: 6 bytes 


Signed quadword. Size: 4 bytes Range: 2147483648 to +2147483647 Maximum: 10 


Unsigned byte integer. Size: 1 byte Range: 0 to +254 Maximum: 3 


Unsigned word integer. Size: 2 bytes Range: 0 to +65534 Maximum: 5 


Unsigned long integer Size: 4 bytes Range: 0 to +4,294,967,294 Maximum: 10 