Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 08:29:11 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: The first lines for the result of a request
From:   Victor Sokovin

  The use of TOP fonction is not OK ....  

          > Select TOP 10 userid, Sum(TotalCPUTime) cpu
          > From dbc.DBQLogTbl
          > Group By 1;

Try to run this query first:

     select * from dbc.dbcinfo;

If you see that VERSION is set to something like 05.xx.xx.xx then that is what we call database release 2 (you will hardly see any other release anywhere so this number is always the same, don't worry about it), version 5. As other posters have already noted you need to be on version 6 to enjoy the TOP function. My guess is that you are not there as yet.

Alternatively, you can take a look at the RELEASE entry. It will be set to V2R.06.xx.xx.xx if you are on version 6.

It is always good to know which version of the database you are currently working on and you might include it in your posting when you have specific questions on syntax, usage etc because these things can be version specific.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020