Querying remote systems using DB2^® UDB for iSeries query management function

 

The DB2 Universal Database™ for iSeries™ query management function provides almost the same support as interactive SQL for querying a remote system and returning the results in an output file to the local system.

Both interactive SQL and the query management function can perform data manipulation operations, such as INSERT, DELETE, and SELECT, for files or tables without the requirement that the table (or file) already exist in a collection (it can exist in a library). Also, query management uses SQL CREATE TABLE statements to provide a data definition when a new table is created on the system as a result of the query. Tables created from a query management function follow the same guidelines and restrictions that apply to a table created using SQL.

However, the query management function does not allow you to specify a member when you want to add the results to a file or table. The results of a query function are placed in the first file member unless you use the Override with Database File (OVRDBF) command to specify a different member before starting the query management function.

 

Parent topic:

Moving data from one system to another

 

Related concepts

Query Management Programming PDF

 

Related reference

Override with Database File (OVRDBF) command