Archives of the TeradataForum

Message Posted: Thu, 29 Jul 2004 @ 21:11:46 GMT

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

<-- Anonymously Posted: Thursday, July 29, 2004 15:40 -->

I have looked through the manuals and have not found a complete list of Access Types. I have encountered three types in DBC.AccLogTbl: 'AN', 'HR', 'WL' which do not seem to have a definition in the manuals (that I have found). From grouping the statement types for these access types, it seems those records with a statement type relating to Show/Help/Replace table/Macro/View have an Access Type of 'AN' and that 'HR' seems to be related to releasing locks, and finally 'WL' which seems if I were a betting person, to be related to work tables for multiloads (selection/mload/release mload/begin mload/execute mload). Can anyone point to a manual or other related materials that would detail these specific Access Types ('AN', 'HR', 'WL') specifically for the DBC.AccLogTbl table.

Thanks

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