Creating an oa_types

/* 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 9. 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 10. 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 11. 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 12. 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 13. 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

Creating an oa_types_info object