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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

QSYS2.GROUP_USERS() – The new UDTF

Go down

QSYS2.GROUP_USERS() – The new UDTF Empty QSYS2.GROUP_USERS() – The new UDTF

Post  maran 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
QSYS2.GROUP_USERS() – The new UDTF Fig1_b11

Figure 2. Input parameter definition

QSYS2.GROUP_USERS() – The new UDTF Fig2_b10
Figure 3. UDTF output table definitionQSYS2.GROUP_USERS() – The new UDTF Fig3_b10
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top


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