skip to main content
Interface Provider class : IP methods reference : ipGetTypesInfo : Creating an oa_types_info object
 

Creating an oa_types_info object

An object of oa_types_info[] can be created using the new keyword. For example, oa_types_info[] xxxx = new oa_types_info[n].
where:
‘xxxx’ is the variable name and ‘n’ is an integer value.
The following code snippet illustrates how to create an oa_types_info object.
/* Overloaded Constructor*/
oa_types_info(String Typename, int Datatype, long OaPrecision,
String LiteralPrefix, String LiteralSuffix, String CreateParams,
int OaNullable, int OaCaseSensitive, int OaSearchable,
int UnsignedAttrib, int OaMoney, int AutoIncrement,
int MinimumScale, int MaximumScale, String LocaltypeName) */
oa_types_info[] typesInfo = new oa_types_info[22];
typesInfo[0] = new oa_types_info("CHAR", 1, 4096, "'", "'", "length", 1, 1, 3, 0, 0, 0, DAMOBJ_NOTSET, DAMOBJ_NOTSET, "CHAR");
…
typesInfo[21] = new oa_types_info("WLONGVARCHAR", -10, 2147483647, "N'", "'", "max length", 1, 1, 3, 0, 0, 0, DAMOBJ_NOTSET, DAMOBJ_NOTSET, "WLONGVARCHAR");
The following table contains different parameter values of the overloaded oa_types_info constructor that can be used to customize the information type.
 
Table 19: Parameter Values for the overloaded constructor of oa_types_info 
Parameters
Values
Typename
WLONGVARCHAR
WVARCHAR
WCHAR
BIT
Datatype
-10
-9
-8
-7
OaPrecision
2147483647
4096
4096
1
LiteralPrefix
N'
N'
N'
<Null>
LiteralSuffix
'
'
 
<Null>
CreateParams
max length
max length
 
length
<Null>
OaNullable
1
1
1
1
OaCaseSensitive
1
1
1
0
OaSearchable
3
3
3
2
UnsignedSttrib
<Null>
<Null>
<Null>
 
<Null>
OaMoney
0
0
0
0
AutoIncrement
<Null>
<Null>
<Null>
<Null>
MinimumScale
<Null>
<Null>
<Null>
0
maximumScale
<Null>
<Null>
<Null>
0
LocaltypeName
WLONGVARCHAR
WVARCHAR
WCHAR
BIT
 
Table 20: Parameter Values for the overloaded constructor of oa_types_info 
Parameters
Values
Typename
TINYINT
BIGINT
LONGVARBINARY
VARBINARY
Datatype
-6
-5
-4
-3
OaPrecision
3
19
2147483647
4096
LiteralPrefix
<Null>
<Null>
0x
0x
LiteralSuffix
<Null>
<Null>
<Null>
<Null>
CreateParams
<Null>
<Null>
max length
max length
OaNullable
1
1
1
1
OaCaseSensitive
0
0
0
0
OaSearchable
2
2
0
0
UnsignedSttrib
1
0
<Null>
<Null>
OaMoney
0
0
0
0
AutoIncrement
0
0
<Null>
<Null>
MinimumScale
0
0
<Null>
<Null>
maximumScale
0
0
<Null>
<Null>
LocaltypeName
TINYINT
BIGINT
LONGVARBINARY
VARBINARY
 
Table 21: Parameter Values for the overloaded constructor of oa_types_info
Parameters
Values
Typename
BINARY
LONGVARCHAR
NULL
CHAR
Datatype
-2
-1
0
1
OaPrecision
4096
2147483647
1
4096
LiteralPrefix
0x
'
<Null>
 
LiteralSuffix
<Null>
'
<Null>
'
CreateParams
length
max length
 
<Null>
length
OaNullable
1
1
1
1
OaCaseSensitive
0
1
0
1
OaSearchable
0
3
2
3
UnsignedSttrib
<Null>
<Null>
<Null>
 
<Null>
OaMoney
0
0
0
0
AutoIncrement
<Null>
<Null>
<Null>
<Null>
MinimumScale
<Null>
<Null>
<Null>
<Null>
maximumScale
<Null>
<Null>
<Null>
<Null>
LocaltypeName
BINARY
LONGVARCHAR
NULL
CHAR
 
Table 22: Parameter values for the overloaded constructor of oa_types_info 
Parameters
Values
Typename
NUMERIC
INTEGER
SMALLINT
REAL
Datatype
2
4
5
7
OaPrecision
40
10
5
24
LiteralPrefix
<Null>
<Null>
<Null>
<Null>
LiteralSuffix
<Null>
<Null>
<Null>
<Null>
CreateParams
precisionscale
<Null>
<Null>
<Null>
OaNullable
1
1
1
1
OaCaseSensitive
0
0
0
0
OaSearchable
2
2
2
2
UnsignedSttrib
0
0
0
0
OaMoney
0
0
0
0
AutoIncrement
0
0
0
0
MinimumScale
0
0
0
<Null>
maximumScale
32
0
0
<Null>
LocaltypeName
NUMERIC
INTEGER
SMALLINT
REAL
 
Table 23: Parameter values for the overloaded constructor of oa_types_info
Parameters
Values
Typename
DOUBLE
VARCHAR
DATE
TIME
TIMESTAMP
Datatype
8
12
91
92
93
OaPrecision
53
4096
10
8
19
LiteralPrefix
<Null>
 
'
'
'
LiteralSuffix
<Null>
'
 
'
 
CreateParams
<Null>
max length
 
<Null>
<Null>
<Null>
OaNullable
1
1
1
1
1
OaCaseSensitive
0
1
0
0
0
OaSearchable
2
3
2
2
2
UnsignedSttrib
0
<Null>
<Null>
 
<Null>
<Null>
OaMoney
0
0
0
0
0
AutoIncrement
0
<Null>
<Null>
<Null>
<Null>
MinimumScale
<Null>
<Null>
<Null>
<Null>
0
maximumScale
<Null>
<Null>
<Null>
<Null>
0
LocaltypeName
DOUBLE
VARCHAR
DATE
TIME
TIMESTAMP