createconnection
                           
-s <connection_subtype>

-n <connection_name>

[{-u <user_name>

[{-p <password> |

-P <password_environment_variable>

[-w (use parameter in password)]}]}]|

-K <connection_to_the_Kerberos_server>]

[-c <connect_string> (required for Oracle, Informix, DB2, Microsoft SQL Server, ODBC, and NetezzaRelational)]

[-l <code_page>]

[-r <rollback_segment> (valid for Oracle connection only)]

[-e <connection_environment_SQL>]

[-f <transaction_environment_SQL>]

[-z <packet_size> (valid for Sybase ASE and MS SQL Server connection)]

[-b <database_name> (valid for Sybase ASE, Teradata and MS SQL Server connection)]

[-v <server_name> (valid for Sybase ASE and MS SQL Server connection)]

[-d <domain_name> (valid for MS SQL Server connection only)]

[-t (enable trusted connection, valid for MS SQL Server connection only)]

[-a <data_source_name> (valid for Teradata connection only)]

[-x (enable advanced security, lets users give Read, Write and Execute permissions only for themselves.)]

[-k <connection_attributes> (attributes have the format name=value;name=value; and so on)]

[-y (Provider Type (1 for ODBC and 2 for OLEDB), valid for MS SQL Server connection only)]

[-m (UseDSN, valid for MS SQL Server connection only)]

[-S <odbc_subtype> (valid for ODBC connection only, default is None)]