Attributes
- url
- Required string. The database URL for the database server to
which the file upload command is sent, such as jdbc:as400://myISeries (see Database URL).
- driver
- Required string. The fully qualified package name of the driver
used to connect with the database server, such as COM.ibm.db2.jdbc.app.DB2DRIVER.
This package must be present on the client workstation (see Driver Identifier and Driver Class).
- userid
- Optional string. The user ID required to access the database,
if one is required (see User ID and Password).
- password
- Optional string. The password required to access the database,
if one is required (see User ID and Password).
- filename
- Required string. The complete path and name of the local file
containing the data to be added to the table in the host database
(see File Name and File Type).
- filetype
- Required integer. The type of the local file containing the
data to be added to the table in the host database (see File Name and File Type). Valid values are:
- 0 - ASCII text (*.txt)
- 1 - Comma Separated Values (*.csv)
- 3 - Microsoft Excel BIFF3 (*.xls)
- 4 - Microsoft Excel BIFF4 (*.xls)
- 5 - XML (*.xml)
- uploadtype
- Required string. The type of file upload operation to perform.
Valid values are:
- append - Append rows to an existing table in the host database
(see Append).
- create - Create a new table in the host database (see Create). When you use this upload type, you must also
specify the following attribute:
- replace - Replace the contents of an existing table in the host
database (see Replace).
- update - Selectively update part of an existing table (see Update). When you use this upload type, you must also
specify the following attribute:
- fielddesctable
- String (required when uploadtype is create).
The name of the table in the host database from which the database
server is to read the column names and column widths for the new table
(see Create).
- keycolumns
- String (required when uploadtype is update).
The name or names of the column or columns that you want to update
(see Update).