Providing Metadata

Tenup provides numerous options for specifying the metadata of a table once it is uploaded to 1010data. This section details how to specify metadata for columns and tables. As a note, ODBC compliant data sources do not have some of the kinds of table metadata that 1010data provides. For example, while ODBC compliant data sources are familiar with the idea of a column name, they do not have an equivalent to 1010data column headings. Use the options in this section to more precisely control the resultant table's metadata when it appears in 1010data.

Table Information

By default, if no additional information is provided to Tenup, the table name of the resultant table is the path to the table that was provided in the Tenup command. However, you can also provide a table title with the -t option:
$ tenup64 -u [USERNAME] -p [PASSWORD] -C [CONNSTR] [PATH_TO_NEW_TABLE] [QUERY] -t "My Table"
You can also provide both a short description and a long description for the table with the -n and -N options respectively:
In the 1010data web-based GUI, you can see the table information for a table by clicking Info > About this table:

Column Information

Much like the table metadata, you can also provide column metadata for each column of a table. By default, column names in the new 1010data table that is created will be the same as the column names in the original data source (only Tenup will force them into an all lower-case format). If you want to change the column names from those of the original data source, use the -h option:
Additionally, Tenup provides an option for creating column headings. By default, the column heading is the same as the column name. Specify new column headings with the -H option:
You can also provide a description for each column with the -E option:

Column Types and Formats

Column types are simplified in 1010data compared to the ODBC specification. During a normal extract and load process Tenup makes its best effort to translate both the column types and formats from the data source to 1010data equivalents. If you find that this translation isn't meeting the needs of the job, or would simply like to alter the way the system interprets the types and formats, Tenup provides options.

Change the type of the data in a given column using the -i option:

Valid values to pass to the -i option are: i for integer values, f for floating point numbers, and a for alphanumeric text.

Column formats in 1010data are controlled with the -f option. You may want to pay special attention to this setting if you have unusually wide or variable-width columns in the original data source:

To see the available options for column formats, see our User's Guide sections on data types and display formats.

Specifying Information in a File

If you only need to make small adjustments to your resultant table, providing the information in the command line makes sense. However, if you're performing a larger task, Tenup provides functionality for specifying a file that contains all the information about a table and its columns. To do this, simply provide the location of the file containing the information, specified in a 1010data Table Tree, in place of the location of the new table:

For more information on the 1010data table tree, see the API Reference Manual section on the Table Tree.