The File Upload Wizard allows you to build a File Upload command and send it to a remote database server. You can build a File Upload command to create, replace, append data to, or update a table in a remote database.
This online help file describes two versions of the File Upload Wizard:
The remote database server must be running on an iSeries or AS/400, and an appropriate Java Database Connectivity (JDBC) driver must be present on the client workstation. The Host On-Demand client and the Database On-Demand client already include a JDBC driver from the AS/400 Toolbox for Java, which allows the Host On-Demand client or Database On-Demand client to access DB2/400 data on a properly configured iSeries or AS/400 (see the Database URL field on the Logon tab).
Database servers running on other host platforms are supported only if the appropriate JDBC driver is installed on the Host On-Demand or Database On-Demand client workstation (see the Database URL field on the Logon tab).
The File Upload Wizard can read data files in various file formats, including XML (see File below). You can save and reuse File Upload statements (see File below).
You can set default values for some of the fields in the File Upload Wizard:
A sequence of tabs guides you through the process of building and running a File Upload statement. These tabs are:
If the File Upload Wizard is launched from a 5250 Display session, then the File Upload Wizard initially displays in the Database URL field a default database URL containing the name of the current iSeries host.
For general information on using a JDBC driver, see Registering a JDBC driver.
COM
is different
from com
).
If you do not know the fully qualified class name,
contact the provider of the driver.
The driver must be installed on the workstation and must be accessible to the Host On-Demand client or Database On-Demand client (see Deploying a JDBC driver).
Type a comma-separated list of schema names, schema filters, table names, and table filters. This list specifies the schemas and tables that you want to appear in the List of available tables on the Table tab of the File Upload Wizard after you log on to the database.
This Table Filter field is one of several levels of filtering for the List of available tables (see Level 4. Value for the current SQL or File Upload statement).For information on creating a list of schemas and tables, see Specifying a list of available schemas and tables.
Disconnect
Click Disconnect to disconnect from the remote database server.
The contents of this list are determined by several levels of filtering (see Levels of filtering for schema names and table names).
For a Create operation, select one table to serve as the source for the field descriptions for the new table to be created in the remote database.
For a Replace, Append, or Update operation, select one table to become the target of the Replace, Append, or Update operation.
Move the name of the table that you want to use for the Create, Replace, Append, or Update operation from the list of Available tables to the Selected table field:
To remove a selected table name, click <.
The Key Columns tab is available only when the type of the File Upload statement is Update.
If the table that you selected already has key columns defined, Host On-Demand automatically moves the names of the key columns to the list of Selected Column(s).
If you select the wrong columns, then the File Upload statement can write the wrong type of data into the columns. |
Click the File tab to specify the source file that you want to use for the File Upload statement.
The File Upload Wizard does not validate the XML document against the DatabaseOnDemand DTD. (However, many XML editors do support validation. You can use one of these editors to validate the document, if the document still contains the DatabaseOnDemand DTD.)
The File Upload Wizard uses the NAME attribute of the COLUMN element
of the DTD to match a column in the XML file (for example, DESCRIPT
)
to the same-named column in the remote database.
You can use Windows NotePad or any standard XML editor to edit the contents of the DTD XML file (to add, remove, or change data), so long as: