I am new to Parallel jobs an was wondering how to Truncate a SQL server table before I insert. I'm using the enterprise SQL Server stage. I have tried searching for this answer but could not find this topic.
Don't have any docs or DataStage in front of me at the moment... usually there is an Update Action akin to "Clear table then Insert" and in most cases that "clear" means truncate. Do you see any such thing in the stage?
-craig
"You can never have too many knives" -- Logan Nine Fingers
I can set the "Write Method" property = Write, then the stage allows me to set the "Write Mode" = Truncate. However, then the SQL property goes away so I'm not able to enter my insert statement. I must be missing something.
I don't see any before/after SQL tabs/properties either.
When you set those properties, there's really no reason for you to be inserting any kind of sql statement - the stage should handle all that for you automagically. Why not just give it a try and see if that works or not? And then let us know, too.
-craig
"You can never have too many knives" -- Logan Nine Fingers