Re: Index Advisor - Column does no exists on table...

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Jerry,

Thanks for your answer.

No, this table has not any field with a name bigger than ten characters. A
point I hadnt' comment about is that, if I ask the Index advisor to create
the index, it drops the *SUBQJ0001 field.


Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Mon, Apr 12, 2010 at 11:18 AM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:

> Is this the 10 character or less field name given to an SQL DDL field that
> exceeds 10 characters?
>
> Jerry C. Adams
> IBM System i Programmer/Analyst
> --
> B&W Wholesale
> office: 615-995-7024
> email:  jerry@xxxxxxxxxxxxxxx
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
> Sent: Monday, April 12, 2010 10:36 AM
> To: Midrange Systems Technical Discussion
> Subject: Index Advisor - Column does no exists on table...
>
> Hi all,
>
>
>
> I was checking a SQL sentence with Visual Explain and the Index Advisor
> suggested an index with two columns, the first one being *SUBQJ0001 (The
> second column already exists as an index)
>
>
>
> Does anyone have an idea what this refers to?
>
>
>
> Thanks in advance,
>
>
> Luis Rodriguez
> IBM Certified Systems Expert - eServer i5 iSeries
> --
> 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.
>
> --
> 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.