15.10 - Impact of Object Name Length on PM/API Requests - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Object names contain 128 Unicode characters; however, to use object names of 128 characters, applications must use monitor software version 10 or later.

 

If your custom application uses monitor software version ...

The object field in the input area can be ...

8 or earlier

CHAR(30). A fixed parcel field size of 30 bytes. The names must be padded with spaces.

For more information on monitor software version 8 or earlier, see previous releases of Workload Management API: PM/API and Open API, which is available from www.info.teradata.com.

9

VARCHAR(120). A parcel field size of up to 120 bytes in variable length.

For more information on monitor software version 9, see Application Programming Reference: Workload Management (B035-1090-111A), which is available from www.info.teradata.com.

10 or later

VARCHAR(512). A parcel field size of up to 512 bytes in variable length in host character set format.

Depending on the version of your custom application, some of the PM/API request output fields for object names may be truncated. For example, if the output field is an object name of 100 bytes in length when converted to host character set format, and you are using a PM/API request with monitor software version 8 or earlier, the database name will be truncated to fit the fixed parcel field size of 30 bytes.