CURRENT MEMBER

CURRENT MEMBER specifies the member name of a current DB2® data sharing member on which a statement is executing. The value of CURRENT MEMBER is a character string.

The data type is CHAR(8). If necessary, the member name is padded to the right with blanks so that its length is 8 bytes.

The value of a CURRENT MEMBER is a string of blanks when the application process is connected to a DB2 subsystem that is not a member of a data sharing group.

The SQL SET statement cannot change the value of CURRENT MEMBER.

Example: Use one of the following statements to set the host variable MEM to the name of the current DB2 member.

   EXEC SQL SET :MEM = CURRENT MEMBER;

   EXEC VALUES (CURRENT MEMBER) into :MEM;