Re: Best method to SELECT TOP n TO m of a table

On Wed, 05 Nov 2003 12:22:43 -0800, Lennart Jonsson wrote:

> There is a special register for CURRENT TIMEZONE as well

OK. http://troels.arvin.dk/db/rdbms/#functions-LOCALTIMESTAMP-db2 clarified.

> In the get list of tables DB2
>
> You can also get the tables by:
>
> select * from syscat.tables
[...]

Thanks. Getting lists of tables and other meta-information from the non-command-line situation added to http://troels.arvin.dk/db/rdbms/#TODO

Thanks for your input.

(My trial version of DB2 has ran out, so unfortunately I currently cannot really perform major updates of DB2-related information on the page.)

-- 
Greetings from Troels Arvin, Copenhagen, Denmark