Progress/400
Product Guide
Accessing Data from Multiple Members
An additional advantage of the QCMD command is that it allows you to change dynamically the physical file member against which you are working. To switch dynamically between file members, use the OS/400 Override Database File (OVRDBF) command. To execute this command remotely from a Progress client, use QCMD.
For example, assume that the Progress PRODEMO database STATE file has two members: one named STATE, the other EUROPE. The member named STATE contains the U.S. state information, and the EUROPE member holds similar information for European countries.
Suppose, for example, that you start a session as normal and execute this procedure:
The output lists all of the U.S. states in the database file STATE, member STATE. To then run the same procedure but get a list of the European states, follow these steps:
- Enter this QCMD command to close the STATE file immediately:
- Enter this QCMD command to access the data in the STATE, file EUROPE member:
- Rerun the original Progress procedure:
The output will be the data from the EUROPE member. Use this technique to access data from multiple members.
NOTE: Members must have the same data format.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |