Exam4Training

Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?

The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE.

Which of the following processes can be used on subsystem DSN to access MYUSER.EMP table at MYREMOTE location?
A . SELECT * FROM MYUSE
B . EMP;
C . CONNECT TO MYREMOTE; SELECT * FROM MYUSE
D . EMP;
E . SELECT * FROM MYUSE
F . MYREMOT
G . EMP;
H . CREATE ALIAS EMP_ALIAS FOR LOCATIO
. MYREMOT
. MYUSE
. EMP;
SELECT * FROM MYUSE
. EMP_ALIAS;

Answer: B

Exit mobile version