Archives of the TeradataForum

Message Posted: Sat, 31 Oct 2009 @ 17:11:18 GMT

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

Hi Tony,

If DEV and SIT are on different platforms (i.e. Teradata systems) then you really need to keep the same database names on each one.

If they're on the same platform then can the best way to achieve this is to use the concept of a default database. If the tables being accessed are in the user's default database then do NOT code any database names in the macro. If you can't point the macro directly at the tables, then how about using views (of the same name as the table) which ARE in the user's default database.

- Don't forget that in the above paragraph, the "default database" is the default one being used when the macro is created/replaced.

Even with this in place you're still going to need to move the macro by using SHOW/REPLACE and not ARC.

Have you thought of using SP's instead ? They allow you to parameterise the databasenames. Just a thought.

Cheers,

Dave

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

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