Re: Can an SQL field be shortned for output display and/or print?

[Dan <dan27649@xxxxxxxxx>]

To follow up on Rob's comment, I've been a long time user of the Squirrel
SQL Client, which allows you resize columns to the longest entry in the
column.  Typically, though, I export the results to Excel, which allows you
to resize all columns in one shot.

Navigator's Run SQL Scripts, from what I can tell, does not allow resizing
to the longest entry.  (I'm using the Windows client version, so that
feature may have been added since then.)  Edit: Just now installed ACS, and
Run SQL Scripts there does not have this resize feature.

- Dan

On Wed, Mar 22, 2017 at 7:23 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> Often you will find that you need to CAST the column.  Check out the
> difference in these three statements
>
> select objname, objtype,
>        objtext,
>        objsize
> FROM TABLE(QSYS2.OBJECT_STATISTICS('ROB', '*ALL')) AS a
> order by objsize desc
>
> select objname, objtype,
>        left(objtext, 5) as Short,
>        objsize
> FROM TABLE(QSYS2.OBJECT_STATISTICS('ROB', '*ALL')) AS a
> order by objsize desc
>
> select objname, objtype,
>        cast(left(objtext, 5) as char(5)) as Short,
>        objsize
> FROM TABLE(QSYS2.OBJECT_STATISTICS('ROB', '*ALL')) AS a
> order by objsize desc
>
> Then again, if it's just for display purposes and if you run these in Run
> SQL Scripts instead of STRSQL you may find that you don't give a rip.
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
> To:     "'Midrange Systems Technical Discussion'"
> <midrange-l@xxxxxxxxxxxx>
> Date:   03/21/2017 05:02 PM
> Subject:        Can an SQL field be shortned for output display and/or
> print?
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> Can an SQL field be shortened for output display and/or print?
>
> I tried using Left(field, length).
> No impact, no change.
>
> SELECT Left(Local_Address,15) , Local_Port, Job_Name,
> Remote_Address FROM QSYS2.NETSTAT_JOB_INFO WHERE Local_ADDRESS =
> '10.5.2.5' ORDER BY Local_port, REMOTE_ADDRESS , JOB_NAME
> SELECT statement run complete.
>
> Thank You
> _____
> Paul Steinmetz
> IBM i Systems Administrator
>
> Pencor Services, Inc.
> 462 Delaware Ave
> Palmerton Pa 18071
>
> 610-826-9117 work
> 610-826-9188 fax
> 610-349-0913 cell
> 610-377-6012 home
>
> psteinmetz@xxxxxxxxxx<mailto:psteinmetz@xxxxxxxxxx>
> http://www.pencor.com/
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD