Re: List on SQL output vs. one row

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

*-- Search for unpivot at*
*-- https://community.ibm.com/community/user/datamanagement/viewdocument/pivoting-tables?CommunityKey=ea909850-39ea-4ac4-9512-8e2eb37ea09a&tab=librarydocuments
<https://community.ibm.com/community/user/datamanagement/viewdocument/pivoting-tables?CommunityKey=ea909850-39ea-4ac4-9512-8e2eb37ea09a&tab=librarydocuments>*
select HEADING, COLUMN_VALUE
  from qsys2.security_info s,
        lateral(values ('SECURITY_LEVEL', S.SECURITY_LEVEL),
                       ('PENDING_SECURITY_LEVEL', S.PENDING_SECURITY_LEVEL),
                       ('PASSWORD_LEVEL', S.PASSWORD_LEVEL)
                        ) AS T(HEADING, COLUMN_VALUE);

Results:
SECURITY_LEVEL redacted
PENDING_SECURITY_LEVEL
PASSWORD_LEVEL redacted

On Thu, Aug 15, 2024 at 11:59 AM Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

> Given the incredibly simple SQL statement :
> SELECT * FROM QSYS2.SECURITY_INFO ;
>
> Is there a way to get the results which include many columns to show up as
> a list as opposed to one very wide row?  (from SQL Scripts in ACS)
>
> --
> Jim Oberholtzer
> Chief Technical Architect
> Agile Technology Architects
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.