PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

QSYS2.GROUP_USERS() – The new UDTF

View previous topic View next topic Go down

QSYS2.GROUP_USERS() – The new UDTF

Post  maran on Wed Feb 06, 2013 1:04 pm

As part of the IBM i 7.1 Technology Refresh 6 (TR6), the new user defined table function QSYS2.GROUP_USERS() has been added.

Given a input Group Profile name, the GROUP_USERS() UDTF will return a single column table with the members of that group.

Figure 1. Example output


Figure 2. Input parameter definition


Figure 3. UDTF output table definition

maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum