Archives of the TeradataForum

Message Posted: Tue, 11 May 1999 @ 00:50:18 GMT

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

Dean,

There are some Teradata built in variables that may be of use - the 'USER' variable contains the current user. I believe there is also some kind of 'account string expansion' available, however I was unable to find it in the documentation (I would appreciate it if anyone who has knowledge of this facility could post some info about it here)

Are you using Microstrategy? (The scenario you describe is exactly how the MSI toolset works with regard to temporary tables)

The reason I ask is that in the Microstrategy .dss file you can specify a temp table prefix for each user that includes a userid token which is evaluated at logon. In this way all users are able to create temporary tables with identical names (but different prefixes), thus solving your problem.

To do this you need to set up the TempTablePrefix value in the DSS file as follows:

     TempTablePrefix="TempDB.ET_!u_"

This causes any Microstrategy temp tables created by user 'USERID' to be stored in the 'TempDB' database and prefixed by 'ET_USERID_', since the '!u' parameter is evaluated as the current Teradata user id by MSI tools.

If you are using some other vendor's tool you may or may not be able to do the same kind of thing... If you are using an application for which you have the source you might be able to graft this functionality into it. I suspect the easiest approach to implement is the account string expansion I referred to above (if it is what I think it is)...

Regards,

Duncan Heard

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