Create index in Declare GTT

IBM's flagship relational database management system

Create index in Declare GTT

Postby gauravfrankly » Tue Oct 20, 2015 11:38 am

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
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Create index in Declare GTT

Postby BillyBoyo » Tue Oct 20, 2015 1:17 pm

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.
Global moderator
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Create index in Declare GTT

Postby NicC » Tue Oct 20, 2015 4:59 pm

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?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Global moderator
Posts: 3026
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Return to DB2


  • Related topics
    Last post