Argument | Description |
|---|
--meta-repo | If specified, this connection will be considered the metadata repository connection |
--notes arg | Arbitrary notes associated with this connection |
--default-load-type arg | The default load that will be used for load tables created with this connection |
--default-load-script-connection arg | The default script connection that will be used for load tables created with this connection |
--default-load-script-template arg | The default template that will be used for load table scripts created with this connection |
--def-update-script-con arg | The default script connection that will be used for update scripts created with this connection |
--def-table-create-ddl-tem arg | The default template that will be used to create tables created that use this connection |
--def-win-action-tem arg | The default template that will be used to create the Windows Action Script for objects that use this connection |
--def-unix-action-tem arg | The default template that will be used to create the Linux Action Script for objects that use this connection |
--def-table-alter-ddl-tem arg | The default template that will be used to create views created that use this connection |
--def-view-create-ddl-tem arg | The default template that will be used to create views created that use this connection |
--def-index-create-ddl-tem arg | The default template that will be used to create indexes created that use this connection |
--def-index-drop-ddl-tem arg | The default template that will be used to drop indexes created that use this connection |
--def-index-validate-block-tem arg | The default template that will be used to validate indexes created that use this connection |
--def-pre-load-action arg | The default action to execute before loading data into a load table |
--display-data-sql arg | The generic syntax of a Display Data SQL statement which should use RED placeholder parameters (e.g. $OBJECT$) |
--row-count-sql arg | The generic syntax of a Row Count SQL statement which should use RED placeholder parameters (e.g. $OBJECT$) |
--row-count-sql-bulk arg | The SQL statement to return the table name, schema name and row count of all tables for the connection. Variable $DATABASE$ may be used. |
--table-exists-sql arg | The syntax to check if a table exists which accepts RED placeholder parameters. Default: SELECT 1 FROM $OBJECT$ WHERE 1=0 |
--drop-table-sql arg | The generic syntax of a Drop Table SQL statement which should use RED placeholder parameters (e.g. $OBJECT$) |
--drop-procedure-sql arg | The syntax to use for Drop Procedure SQL statements which accepts RED placeholder parameters. Example: DROP $PROC_TYPE$ $SCHEMA$.$PROC_NAME$; |
--drop-view-sql arg | The generic syntax of a Drop View SQL statement which should use RED placeholder parameters (e.g. $OBJECT$) |
--truncate-sql arg | The generic syntax of a Truncate Table SQL statement which should use RED placeholder parameters (e.g. $OBJECT$) |
--db-server arg | Database Host/Server that's used in the GPLoad specification, or in sqlcmd command lines |
--db-port arg | Database Port that's used in the GPLoad specification, or in sqlcmd command lines |
--function-set arg | Function Set that is selected by default in the Transformation dialogs |
--load-host-id arg | IP address or host name(s) that identifies the Loaders for unix connections |
--load-port-start arg | Port Range start for Loaders on unix connections |
--load-port-end arg | Port Range end for Loaders on unix connections |
--ssis-staging-db arg | The staging database to be used by either Microsoft SQL Server Integration Services (SSIS) or PDW file loads |
--ssis-use-col-name | Determines whether to use column names or column titles for SSIS loads. Teradata OLEDB driver by default returns titles |
--def-browser-schema arg | Default schema to use for browsing in RED's browser pane |
--script-shell arg | Path to the POSIX-compliant UNIX/Linux shell to use for generated scripts. Typically this will be /bin/ksh for UNIX hosts and /bin/sh for Linux hosts |
--tpt-hadoop-host arg | IP address or host name (and optional port number) that identifies the Hadoop host to a TPT load routine |
--tpt-odbc-source arg | The Teradata TPT compliant ODBC Data Source Name (DSN) that is to be used in the TPT Read Operator for TPT ODBC Loads |
--tpt-odbc-source-arch arg | The architecture of the Teradata TPT DSN. Valid values are 32 and 64. Defaults to 32 if not specified. |
--msas-db-client-version arg | Microsoft Analysis Services client version available for connecting to the SSAS database |
--create-indexes | If specified, RED will create indexes when creating new objects on this connection |
--con-info-proc arg | The SQL Block Procedure used to query Table/Column information; should use RED placeholder parameters (e.g. $DATABASE$, $SCHEMA$, $OBJECT$) |
--def-pre-load-sql arg | The default Pre-Load Action to use for Load Tables created on targets of this connection. |