Create index in Declare GTT

IBM's flagship relational database management system
Post Reply Previous topicNext topic
gauravfrankly
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Skillset: COBOL, JCL, DB2, REXX
Referer: google

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
Top
BillyBoyo
Global moderator
Posts: 3805
Joined: Tue Jan 25, 2011 12:02 am
Skillset: Easytrieve Plus, Cobol, Utilities, that sort of stuff
Referer: Google

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.
Top
NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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.
Regards
Nic
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DB2”