Show TOC

New Command: ra_get_table_columns Locate this document in the navigation structure

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
Example 1

Run the ra_get_table_columns command on the "jmt" model and the "ALL_DATATYPES" table:

ra_get_table_columns jmt, ALL_DATATYPES
go
The returned result is:
POSITION   NAME             TYPE       TYPE NAME    SIZE       PRECISION  
---------- ---------------- ---------- ------------ ---------- ---------- 
1          COL_ID           4          INTEGER      10         10         
2          COL_DATE         91         DATE         10         10         
3          COL_TIME         92         TIME         8          8          
4          COL_TIMESTAMP    93         TIMESTAMP    27         27         
5          COL_TINYINT      -6         TINYINT      3          3          
6          COL_SMALLINT     5          SMALLINT     5          5                                     
7          COL_INTEGER      4          INTEGER      10         10         
8          COL_BIGINT       -5         BIGINT       19         19                
9          COL_DECIMAL      3          DECIMAL      34         34                      
10         COL_REAL         7          REAL         7          7          
11         COL_DOUBLE       8          DOUBLE       15         15       
12         COL_CHAR         1          CHAR         10         10        
13         COL_VARCHAR      12         VARCHAR      20         20       
14         COL_SECONDDATE   93         SECONDDATE   19         19         
15         COL_SMALLDECIMAL 3000       SMALLDECIMAL 16         16        
16         COL_NCHAR        -8         NCHAR        10         10         
17         COL_NVARCHAR     -9         NVARCHAR     10         10         
18         COL_ALPHANUM     -9         ALPHANUM     1          1          
19         COL_VARBINARY    -3         VARBINARY    10         10        
20         COL_BLOB         -4         BLOB         2147483647 2147483647 
21         COL_CLOB         -1         CLOB         2147483647 2147483647 
22         COL_NCLOB        -10        NCLOB        2147483647 2147483647  
                                         
SCALE      PRIMARY KEY NULLABLE   SEARCHABLE LOB
---------- ----------- ---------- ---------- ----
0          Y           NOT NULL   Y
0                      NULL       Y
0                      NULL       Y
7                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL       Y
0                      NULL                  Y
0                      NULL                  Y
0                      NULL                  Y