Example of NODENUMBER with DB2® Multisystem

Here is an example of how to use the NODENUMBER function.

If CORPDATA.EMPLOYEE is a distributed table, then the node number for each row and the employee name is returned.

SQL Statement:

SELECT NODENUMBER(CORPDATA.EMPLOYEE), LASTNAME
   FROM CORPDATA.EMPLOYEE

OPNQRYF Command:

OPNQRYF FILE((CORPDATA/EMPLOYEE))
        FORMAT(FNAME)
        MAPFLD((NODENAME '%NODENUMBER(1)')
               (LNAME '1/LASTNAME'))