Hey, did you catch that redirect? The Toad World URL is now community.toadworld.com. Don't worry -- you'll still find all the same great content here (and more on the way). We're just in the process of giving our Toad World site some well-deserved love. Stay tuned for some more updates coming this way.
Meanwhile, enjoy community.toadworld.com.
Description: Contains one row for each table, view, or alias.
The value is 0 if the row describes a view, alias, or auxiliary table.
For a created temporary table, DATACAPTURE is always blank.
The value is 'E' for tables in non work file databases and blank for
tables in work file databases created prior to Version 5 or the default
Adapted from material found in the IBM DB2 Universal Database for z/OS V9.1 SQL Reference (SC18-9854-03).