Toad World® Forums

Index DDL with Key expressions are not exported correctly


#1

I recently created an index on a key expression RIGHT ( CHAR (DIGITS(SSNO)),4)
but when I went to show someone the definition via Toad the index did not render
correctly.

CREATE INDEX “FDBEL”.“XRGMST9”

ON “FDBEL”.“REG_MASTER”

( “SSNO” )

USING STOGROUP “FSGALLP”

PRIQTY 2500 SECQTY 1000 ERASE NO

FREEPAGE 0

PCTFREE 10

GBPCACHE CHANGED

DEFINE YES

COMPRESS NO

NOT CLUSTER

NOT PADDED

BUFFERPOOL BP11

CLOSE NO

PIECESIZE 2G

COPY YES ;

Should be

CREATE INDEX “FDBEL”.“XRGMST9”

ON “FDBEL”.“REG_MASTER”

( RIGHT(CHAR(DIGITS(SSNO)),4) )

USING STOGROUP “FSGALLP”

PRIQTY 2500 SECQTY 1000 ERASE NO

FREEPAGE 0

PCTFREE 10

GBPCACHE CHANGED

DEFINE YES

COMPRESS NO

NOT CLUSTER

NOT PADDED

BUFFERPOOL BP11

CLOSE NO

PIECESIZE 2G

COPY YES ;


#2

Mark,

Thank you for bringing this to our attention. I have created cr74617 to track this issue.

Ken Ryan
Toad for DB2 Developer
Quest Software


#3

Message from: bpbjunkemail_093

Ken:

Has this issue, 74617 been resolved? I have the same problem. My version of Toad
won’t properly display an index with expression when I view the DDL on the
scripts tab. I am using Toad version 4.7.0.556. Oddly enough, another person I
work with who has the same version of Toad can see the same index displayed
correctly.

Brian


Historical Messages

Author: bpbjunkemail_093
Date: Fri Apr 15 04:53:50 PDT 2011

Ken:

Has this issue, 74617 been resolved? I have the same problem. My version of Toad
won’t properly display an index with expression when I view the DDL on the
scripts tab. I am using Toad version 4.7.0.556. Oddly enough, another person I
work with who has the same version of Toad can see the same index displayed
correctly.

Brian

__

Author: Ken Ryan
Date: Tue Jun 08 04:46:44 PDT 2010
Mark, Thank you for bringing this to our attention. I have created cr74617 to
track this issue. Ken Ryan Toad for DB2 Developer Quest Software
__

Author: Stone, Mark
Date: Mon Jun 07 16:18:50 PDT 2010
I recently created an index on a key expression RIGHT ( CHAR (DIGITS(SSNO)),4)
but when I went to show someone the definition via Toad the index did not render
correctly. CREATE INDEX “FDBEL”.“XRGMST9” ON “FDBEL”.“REG_MASTER” ( “SSNO” )
USING STOGROUP “FSGALLP” PRIQTY 2500 SECQTY 1000 ERASE NO FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED DEFINE YES COMPRESS NO NOT CLUSTER NOT PADDED BUFFERPOOL BP11
CLOSE NO PIECESIZE 2G COPY YES ; Should be CREATE INDEX “FDBEL”.“XRGMST9” ON
“FDBEL”.“REG_MASTER” ( RIGHT(CHAR(DIGITS(SSNO)),4) ) USING STOGROUP “FSGALLP”
PRIQTY 2500 SECQTY 1000 ERASE NO FREEPAGE 0 PCTFREE 10 GBPCACHE CHANGED DEFINE
YES COMPRESS NO NOT CLUSTER NOT PADDED BUFFERPOOL BP11 CLOSE NO PIECESIZE 2G
COPY YES ;
__



#4

Ken:

Has this issue, 74617 been resolved? I have the same problem. My version of Toad won’t properly display an index with expression when I view the DDL on the scripts tab. I am using Toad version 4.7.0.556. Oddly enough, another person I work with who has the same version of Toad can see the same index displayed correctly.

Brian


#5

Message from: Vlas

This issue was resolved in our 4.7.1 patch release.
Vlas


Historical Messages

Author: Vlas Titov
Date: Fri Apr 15 05:21:51 PDT 2011
This issue was resolved in our 4.7.1 patch release.
Vlas

__

Author: bpbjunkemail_093
Date: Fri Apr 15 04:53:50 PDT 2011

Ken:

Has this issue, 74617 been resolved? I have the same problem. My version of Toad
won’t properly display an index with expression when I view the DDL on the
scripts tab. I am using Toad version 4.7.0.556. Oddly enough, another person I
work with who has the same version of Toad can see the same index displayed
correctly.

Brian

__

Author: bpbjunkemail_093
Date: Fri Apr 15 04:53:50 PDT 2011
Message from: bpbjunkemail_093 Ken: Has this issue, 74617 been resolved? I have
the same problem. My version of Toad won’t properly display an index with
expression when I view the DDL on the scripts tab. I am using Toad version
4.7.0.556. Oddly enough, another person I work with who has the same version of
Toad can see the same index displayed correctly. Brian
_______________________________________ Historical Messages Author:
bpbjunkemail_093 Date: Fri Apr 15 04:53:50 PDT 2011 Ken: Has this issue, 74617
been resolved? I have the same problem. My version of Toad won’t properly
display an index with expression when I view the DDL on the scripts tab. I am
using Toad version 4.7.0.556. Oddly enough, another person I work with who has
the same version of Toad can see the same index displayed correctly. Brian __
Author: Ken Ryan Date: Tue Jun 08 04:46:44 PDT 2010 Mark, Thank you for bringing
this to our attention. I have created cr74617 to track this issue. Ken Ryan Toad
for DB2 Developer Quest Software __ Author: Stone, Mark Date: Mon Jun 07
16:18:50 PDT 2010 I recently created an index on a key expression RIGHT ( CHAR
(DIGITS(SSNO)),4) but when I went to show someone the definition via Toad the
index did not render correctly. CREATE INDEX “FDBEL”.“XRGMST9” ON
“FDBEL”.“REG_MASTER” ( “SSNO” ) USING STOGROUP “FSGALLP” PRIQTY 2500 SECQTY 1000
ERASE NO FREEPAGE 0 PCTFREE 10 GBPCACHE CHANGED DEFINE YES COMPRESS NO NOT
CLUSTER NOT PADDED BUFFERPOOL BP11 CLOSE NO PIECESIZE 2G COPY YES ; Should be
CREATE INDEX “FDBEL”.“XRGMST9” ON “FDBEL”.“REG_MASTER” (
RIGHT(CHAR(DIGITS(SSNO)),4) ) USING STOGROUP “FSGALLP” PRIQTY 2500 SECQTY 1000
ERASE NO FREEPAGE 0 PCTFREE 10 GBPCACHE CHANGED DEFINE YES COMPRESS NO NOT
CLUSTER NOT PADDED BUFFERPOOL BP11 CLOSE NO PIECESIZE 2G COPY YES ; __


__

Author: Ken Ryan
Date: Tue Jun 08 04:46:44 PDT 2010
Mark, Thank you for bringing this to our attention. I have created cr74617 to
track this issue. Ken Ryan Toad for DB2 Developer Quest Software
__

Author: Stone, Mark
Date: Mon Jun 07 16:18:50 PDT 2010
I recently created an index on a key expression RIGHT ( CHAR (DIGITS(SSNO)),4)
but when I went to show someone the definition via Toad the index did not render
correctly. CREATE INDEX “FDBEL”.“XRGMST9” ON “FDBEL”.“REG_MASTER” ( “SSNO” )
USING STOGROUP “FSGALLP” PRIQTY 2500 SECQTY 1000 ERASE NO FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED DEFINE YES COMPRESS NO NOT CLUSTER NOT PADDED BUFFERPOOL BP11
CLOSE NO PIECESIZE 2G COPY YES ; Should be CREATE INDEX “FDBEL”.“XRGMST9” ON
“FDBEL”.“REG_MASTER” ( RIGHT(CHAR(DIGITS(SSNO)),4) ) USING STOGROUP “FSGALLP”
PRIQTY 2500 SECQTY 1000 ERASE NO FREEPAGE 0 PCTFREE 10 GBPCACHE CHANGED DEFINE
YES COMPRESS NO NOT CLUSTER NOT PADDED BUFFERPOOL BP11 CLOSE NO PIECESIZE 2G
COPY YES ;
__



#6

This issue was resolved in our 4.7.1 patch release.
Vlas