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'))

 

Parent topic:

NODENUMBER with DB2 Multisystem