METHOD 2: QUERY ON LOCAL SYSTEM

The second method is similar to Method 1 except QUERY is run on the local system. First a :FILE command is used to specify the location of the remote data base. After initiating execution of QUERY, you specify the data base name with the DEFINE or DATA BASE= command. The name of the data base must be the same as the name specified as the formal file designator in the :FILE command.

Figure C-2 “Using Method 2” illustrates Method 2 using DS. After USERL establishes a communications link and remote session on the remote system, the user enters a file equation to specify that the data base DBR resides on a remote system with dsdevice name SYSR. The device type may be omitted if the default device type is acceptable. The user runs QUERY on the local system and specifies the data base name DBR with the DATA-BASE= command. Note: The data base name is the formal file designator in the :FILE command.

Figure C-2 Using Method 2

When using NS, you must have previously issued a :FILE command specifying the remote location of the file, to access a remote data base and run QUERY. In the example above, the user would enter:

      :HELLO USERL.ACCTL
      :DSLINE SYSR
      :FILE DBR=DBX:SYSR
      :REMOTE HELLO MEMBER.PAYROLL
      :RUN QUERY.PUB.SYS