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:
    • fielddesctable
  • 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:
    • keycolumns
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).