Truncate, User, Truncate url user – HP Neoview Release 2.4 Software User Manual
Page 60
number_of_seconds
can be zero or a positive integer.
truncate
truncate = "true" | "false"
The default is “false” (do not delete data from the target).
This option specifies whether Transporter should truncate target tables (for a load operation) or
target data files (for an extract operation) before job processing begins.
true
means Transporter will delete all data from the target table or file before job processing
begins.
false
means Transporter will not delete data from the target before job processing begins.
For a load operation where the
is “insert”, if the
option is set to true then truncate must also be set to true otherwise an error is returned.
url
url = "urlname"
This option specifies an access point for:
•
JDBC connections to the Neoview system
•
JMS sources
There is no default value.
The Transporter Java client uses this URL for its internal database connections.
A JDBC connection URL must be of the form of:jdbc:hpt4jdbc://hostname:port/.
See the Neoview JDBC Type 4 Driver Programmer’s Reference for complete details on JDBC connection
URLs.
Example: a JDBC connection URL for a Neoview system name neo0101.domain.com:
jdbc:hpt4jdbc://neo0101.domain.com:18650/
This option is not applicable to file or named pipe data sources.
This option is required for the Java client.
user
user = "username" | ${referencename} | $E{referencename}
This option is required. It specifies the username to use when connecting to a data source:
•
username
specifies a plain-text password.
•
${referencename}
refers to a plain-text user name defined in the plain property file.
Transporter automatically substitutes the corresponding user name when it processes the
control file.
•
$E{referencename}
refers to an encrypted user name in the encrypted property file.
Transporter automatically substitutes the corresponding decrypted user name when it
processes the control file.
60
Control File Options