Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Deploying Macros
From:   DWellman

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.



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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023