Mar 28, 2019 #1 msol25 Programmer Joined Mar 28, 2019 Messages 2 Location GB Hi Friends, Request to please help me to get sql select query to get all the users list in DB2 database.
Hi Friends, Request to please help me to get sql select query to get all the users list in DB2 database.
Mar 28, 2019 #2 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US Hi, What have you tried in your quest to get all users listed in your DB2 database? Please be specific. Skip, Just traded in my OLD subtlety... for a NUance! "The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein Upvote 0 Downvote
Hi, What have you tried in your quest to get all users listed in your DB2 database? Please be specific. Skip, Just traded in my OLD subtlety... for a NUance! "The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
Apr 2, 2019 #3 bwleon Programmer Joined Apr 2, 2019 Messages 1 Location US Try this: SQL: SELECT * FROM TABLE( USERS() ) u I found it on here: [URL unfurl="true"]https://developer.ibm.com/articles/i-power-of-udtf/[/url] Upvote 0 Downvote
Try this: SQL: SELECT * FROM TABLE( USERS() ) u I found it on here: [URL unfurl="true"]https://developer.ibm.com/articles/i-power-of-udtf/[/url]