Create Remote Database Table

Similar to creating physical files locally on the System i, you can create work files (tables) on defined and available remote database servers.

Views and Tabling Views

From the Explorer object list press the Actions button and select Save Results\Remote Database Table,  

Actions Button

or right-click a view or tabling view and select Save Results\Remote Database Table.

Actions Drop-down Menu

You can also press Save Results\Remote Database Table in the results display for views or tables).

Results Display

All of these options display the Create Remote Database Results screen. Choose a server, a schema, and give the file a name. Press OK to create the file.

Options

Server - Use the drop-down menu to choose a remote database server.

Schema - Use the drop-down list to select a schema to save the new table.

Table Name - Give the new table a name. The default is based on the starting view or table name.

OK - Press OK to create the table.