specifies the SAP HANA user name (also called the user ID) that is used to connect to the database.
specifies the password that is associated with your SAP HANA user ID.
Tip | Use only PASSWORD=, PASS=, or PW= for the password argument. PWD= is not supported and causes an error. |
specifies the SAP HANA server name or the IP address of the server host.
Interaction | You can use the DATABASE= argument in the %INDHN_CREATE_MODELTABLE, %INDHN_PUBLISH_MODEL, or %INDHN_RUN_MODEL macro instead of specifying the SERVER= argument. |
specifies the port number.
Interactions | Specify either the PORT= argument or the INSTANCE= argument. |
You can use the DATABASE= argument in the %INDHN_CREATE_MODELTABLE, %INDHN_PUBLISH_MODEL, or %INDHN_RUN_MODEL macro instead of specifying the PORT= argument. |
specifies the instance number.
Interactions | Specify either the PORT= argument or the INSTANCE= argument. |
You can use the DATABASE= argument in the %INDHN_CREATE_MODELTABLE, %INDHN_PUBLISH_MODEL, or %INDHN_RUN_MODEL macro instead of specifying the INSTANCE= argument. |
specifies the SAP HANA schema that contains the tables and views that you want to access.
Default | If you do not specify a value for the SCHEMA argument, the default schema is used. |
preserves spaces, special characters, and case sensitivity in SAP HANA table names.
specifies that table names are read from and passed to the SAP HANA with special characters, and the exact, case-sensitive spelling of the name is preserved.
specifies that when you create SAP HANA tables or refer to an existing table, the table names are derived from SAS member names by using SAS member name normalization. However, SAP HANA applies its own normalization rules to the SAS member names. Therefore, the table names are created or referenced in the database following the SAP HANA normalization rules.
Default | NO |
preserves spaces, special characters, and case sensitivity in SAP HANA column names when you create SAP HANA tables.
specifies that column names that are used in table creation are passed to the DBMS with special characters and the exact, case-sensitive spelling of the name is preserved.
specifies that column names that are used to create SAP HANA tables are derived from SAS variable names (VALIDVARNAME= system option) by using the SAS variable name normalization rules. However, SAP HANA applies its own normalization rules to the SAS variable names when creating the SAP HANA column names.
Default | NO |