Page 1 of 1

Create index in Declare GTT

PostPosted: Tue Oct 20, 2015 11:38 am
by gauravfrankly
Hi All,

Can we create and use the INDEX with the DECLARE Global Temp Table in DB2.
If yes, then Please provide the syntax for the same

Re: Create index in Declare GTT

PostPosted: Tue Oct 20, 2015 1:17 pm
by BillyBoyo
What does the manual say for your version of DB2? Did you try anything, if so, what, including any diagnostic messages with the message reference.

Re: Create index in Declare GTT

PostPosted: Tue Oct 20, 2015 4:59 pm
by NicC
If you can then the syntax will be in the manual. Why should we do your research for you when, by doing it yourself, you will probably learn a lot more?