Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2002 @ 12:08:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

It may do, and even if it is there it's not always easy to get at using SQL. Details are;

-- there is no column in a view/table which holds this information (as far as I'm aware it is basically stored in the table headers on the amps

-- these are not directly accessible using SQL)

-- when you create a table the request string that you submit is accessible in dbc.tables.requesttext and so if you specify values for these parameters they will be shown there.

-- however, if you subsequently issues an alter table to do anything else (e.g. adding/removing columns) then the alter table request string is placed in dbc.tables.requesttext and so wipes out the datablocksize etc parameters that were initially used. Note that these values are still used by the DBMS because they're stored in the table headers, it's just that you cannot find them in dbc.tables.requesttext.

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

	<Prev	Next>		<<First	<Prev	Next>	Last>>