on 10-31-2018 9:01 AM
Hi,
We have defined a table with a boolean column using the create table statement, but we have the whole database definition in our project using hdbtable files.
Is there any way to define a boolean column using a hdbtable? We havent found anything in the documentation.
Thanks.
Jorge
I assume you mean the old repository hdbtable. If so it is not supported and I would highly doubt it would ever be added. The repository is deprecated and its development artifacts receive no further enhancements. However this data type is supported in HDI. It works in both the new DDL syntax based hdbtable and it works in hdbcds.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It seems that BOOLEAN data type is not supported in hdbtable. Here is the list of data types supported by hdb tables:
The following configuration schema illustrates the data types you can specify with the sqlType keyword:
enum SqlDataType
{
DATE; TIME; TIMESTAMP; SECONDDATE; INTEGER; TINYINT;
SMALLINT; BIGINT; REAL; DOUBLE; FLOAT; SMALLDECIMAL;
DECIMAL; VARCHAR; NVARCHAR; CLOB; NCLOB;
ALPHANUM; TEXT; SHORTTEXT; BLOB; VARBINARY;
};
And here is the reference (Page 36, SQL Data Type section)
You can use VARCHAR(1) or TINYINT instead.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.