DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
datastage
Participant

Group memberships:
Premium Members, DSXchange Team, Heartland Usergroup

Joined: 23 Oct 2002
Posts: 229
Location: Omaha
Points: 1566

Post Posted: Mon May 31, 2004 6:19 pm Reply with quote    Back to top    

I'm trying to understand the difference between the 'SQL Server Build - No Constraints.sql' and 'SQL Server Build Constraints.sql' scripts and their relation to the main build script 'SQL Server Build.sql'

Is it as simple as Build.sql is a combination of both, and No Constraints.sql is what you would execute if you wanted the database without all the indexes, keys, integrity, and triggers that were absolutely necessary? And then Build Constraints.sql is what adds what was left off in case wanted at a later date?

_________________
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.

"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
datastage
Participant

Group memberships:
Premium Members, DSXchange Team, Heartland Usergroup

Joined: 23 Oct 2002
Posts: 229
Location: Omaha
Points: 1566

Post Posted: Mon May 31, 2004 6:20 pm Reply with quote    Back to top    

What is the purpose of SQL Server Enterprise Property Init.sql and when is it needed and when can it be omitted?

_________________
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.

"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
Rate this response:  
Not yet rated
falsehate
Participant



Joined: 16 Mar 2004
Posts: 9

Points: 150

Post Posted: Thu Aug 26, 2004 10:13 pm Reply with quote    Back to top    

This is a template for some 'canned' properties to support Hyperion Enterprise. If you run the script it will create the property categories and the properties. These are really only useful if the Enterprise export class was purchased and activated.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours