New Command: ra_get_table_columns 
After deploying the SAP HANA Container, the ra_get_table_columns command shows what column properties are obtained by the container when table metadata is obtained from the database. SAP HANA Container gets the table column information during model deployment so that tables do not need to be added to the model for this command to work.
Syntax
ra_get_table_columns <modelName>, <tableName>
Parameters
- modelName
- Specifies the name of the replication model.
- tableName
- Specifies the name of the table.
Examples
Run the ra_get_table_columns command on the "jmt" model and the "ALL_DATATYPES" table:
1> ra_get_table_columns jmt, ALL_DATATYPES 2> go
The returned result is:POSITION NAME TYPE TYPE NAME SIZE PRECISION SCALE PRIMARY KEY NULLABLE SEARCHABLE LOB ---------- ---------------- ---------- ------------ ---------- ---------- ---------- ----------- ---------- ---------- ---- 1 COL_ID 4 INTEGER 10 10 0 Y NOT NULL Y 2 COL_DATE 91 DATE 10 10 0 NULL Y 3 COL_TIME 92 TIME 8 8 0 NULL Y 4 COL_TIMESTAMP 93 TIMESTAMP 27 27 7 NULL Y 5 COL_TINYINT -6 TINYINT 3 3 0 NULL Y 6 COL_SMALLINT 5 SMALLINT 5 5 0 NULL Y 7 COL_INTEGER 4 INTEGER 10 10 0 NULL Y 8 COL_BIGINT -5 BIGINT 19 19 0 NULL Y 9 COL_DECIMAL 3 DECIMAL 34 34 0 NULL Y 10 COL_REAL 7 REAL 7 7 0 NULL Y 11 COL_DOUBLE 8 DOUBLE 15 15 0 NULL Y 12 COL_CHAR 1 CHAR 10 10 0 NULL Y 13 COL_VARCHAR 12 VARCHAR 20 20 0 NULL Y 14 COL_SECONDDATE 93 SECONDDATE 19 19 0 NULL Y 15 COL_SMALLDECIMAL 3000 SMALLDECIMAL 16 16 0 NULL Y 16 COL_NCHAR -8 NCHAR 10 10 0 NULL Y 17 COL_NVARCHAR -9 NVARCHAR 10 10 0 NULL Y 18 COL_ALPHANUM -9 ALPHANUM 1 1 0 NULL Y 19 COL_VARBINARY -3 VARBINARY 10 10 0 NULL Y 20 COL_BLOB -4 BLOB 2147483647 2147483647 0 NULL Y 21 COL_CLOB -1 CLOB 2147483647 2147483647 0 NULL Y 22 COL_NCLOB -10 NCLOB 2147483647 2147483647 0 NULL Y