# tVectorWiseInput Standard properties These properties are used to configure tVectorWiseInput running in the Standard Job framework. The Standard tVectorWiseInput component belongs to the Databases family. The component in this framework is available in all Talend products. Information noteNote: This component is a specific version of a dynamic database connector. The properties related to database settings vary depending on your database type selection. For more information about dynamic database connectors, see [Dynamic database components](https://help.qlik.com/talend/r/en-US/7.3/components/db-generic/dynamic-database-components). ## Basic settings | Database | Select a type of database from the list and click
Apply. | | --- | --- | | Property type | Either Built-in or
Repository
. | | | Built-in: No property data stored
centrally. | | | Repository: Select the repository
file where Properties are stored. The fields that follow are
completed automatically using the data retrieved. | | ![](https://help.qlik.com/talend/en-US/components/7.3/Resources/images/Save_Icon.png) | Click this icon to open a database connection wizard and store the
database connection parameters you set in the component Basic settings view.

For more information about setting up and storing database
connection parameters, see *Talend Studio User Guide*. | | Use an existing connection | Select this check box and in the Component
List drop-down list, select the desired connection component to
reuse the connection details you already defined.

Information noteNote: When a Job contains the parent Job and the child Job, if you
need to share an existing connection between the two levels, for example, to share the
connection created by the parent Job with the child Job, you have to:

  1. In the parent level, register the database connection to be shared in the Basic settings view of the connection component which creates that very database connection.

  2. In the child level, use a dedicated connection component to read that registered database connection.



For an example about how to share a database connection
across Job levels, see *Talend Studio
User Guide*. | | Server | Database server IP address. | | Port | Listening port number of the DB server. | | Database | Name of the database. | | Username and
Password | Authentication information of the database user.

To enter the password, click the [...] button next to the
password field, and then in the pop-up dialog box enter the password between double quotes
and click OK to save the settings. | | Schema and Edit
Schema | A schema is a row description. It defines the number of fields
(columns) to be processed and passed on to the next component. When you create a Spark
Job, avoid the reserved word line when naming the
fields.

This
component offers the advantage of the dynamic schema feature. This allows you to
retrieve unknown columns from source files or to copy batches of columns from a source
without mapping each column individually. For further information about dynamic schemas,
see *Talend Studio*
*User Guide*.

This
dynamic schema feature is designed for the purpose of retrieving unknown columns of a
table and is recommended to be used for this purpose only; it is not recommended for the
use of creating tables. | | | Built-In: You create and store the schema locally for this component
only. | | | Repository: You have already created the schema and stored it in the
Repository. You can reuse it in various projects and Job designs. | | | Click Edit
schema to make changes to the schema. If the current schema is of the Repository type, three options are available:

| | Table name | Name of the table to be read. | | Query type and
Query | Enter your DB query, ensuring that the field order matches the
order in the schema.


*If using the dynamic schema feature, the SELECT
query must include the \*
wildcard, to retrieve all of the columns from the table
selected.* | | Guess Query | Click this button to generate a query that corresponds to your
table schema in the Query
field. | | Guess schema | Click this button to retrieve the schema from the table. | ## Advanced settings | Additional JDBC Parameters | Specify additional JDBC parameters for the
database connection created.

This property is not available when the Use an existing connection
check box in the Basic settings view is selected. | | --- | --- | | Trim all the String/Char columns | Select this check box to remove leading and trailing whitespace
from all the String/Char columns. | | Trim column | Define columns from which to remove leading and trailing
whitespace. | | tStat
Catcher Statistics | Select this check box to collect log data at the component
level. | ## Global Variables | Global Variables | NB\_LINE:
the number of rows processed. This is an After variable and it returns an integer.


QUERY: the query statement
being processed. This is a Flow variable and it returns a string.


ERROR\_MESSAGE: the error message generated by the component when an
error occurs. This is an After variable and it returns a string. This variable functions
only if the Die on error check box
is cleared, if the component has this check
box.

A Flow variable functions during the execution of a component
while an After variable functions after the execution of the component.

To fill up a field or expression with a
variable, press Ctrl + Space to
access the variable list and choose the variable to use from it.

For further information about variables, see *Talend Studio*
*User Guide*. | | --- | --- | ## Usage | **Usage rule** | This component covers all possibile SQL queries forVertica
databases. | | --- | --- | | Limitation | Due to license incompatibility, one or more JARs required to use
this component are not provided. You can install the missing JARs for this particular
component by clicking the Install button
on the Component tab view. You can also
find out and add all missing JARs easily on the Modules tab in the
Integration
perspective of your studio. For
details, see *Installing external modules*.
You can find more details about how to install external modules in
Talend Help Center ([https://help.talend.com](https://help.talend.com/)). |