DSXchange

Sure. Forgot for a sec exactly how default values get applied in Oracle. If you have a required field - one that doesn't allow nulls - then you can't name that field in a DML stagement and try to put a null in it. Even if that field has a default value assigned, it's not valid to explicitly try to p...

Remember the battlecry of the parenthesis: Protect the OR! Next thing you know Ray will come along and remind us all how the OR in DataStage isn't weaker than the AND and doesn't really need protecting after all. Instead, we need to use them to enforce the desired evaluation order in the expressions...

It's not a supported datatype. None of the ANSI datatypes are, as far as I know, only the native Oracle types are.

Not sure what other answer you may have been expecting.

As zam62 noted, the biggest reason I've seen that causes people to 'lose' files they've generated is the output pathname is not a fully qualified pathname - i.e. one that starts with a slash. Any sort of relative path is relative to the current working directory of the process that references it - a...

SeqA + @INROWNUM

Since we don't know for sure what you need, it either needs to look like this: if (Fundname2 <> Fundname1 or Fundname1='') and DateGenericDateDiff(Date2, Date1) < 365 then 0 else TNAamount2-TNAamount1 or: if Fundname2 <> Fundname1 or (Fundname1='' and DateGenericDateDiff(Date...

Show us your syntax with the parens added.

Bummer. Sounds like you have your only solution then. Unless...

Wouldn't you be able to still send nulls to the field but have a Default value defined in the field to set it to a space if it is null?

How would you do it outside of DataStage? More than likey, I'd say you will end up writing to a flat file and then (after job) issuing whatever command is necessary to get the file printed to the remote printer.

Ah... the bulk loader. There is a PRESERVE BLANKS option, from what I recall, for situations like that.

As long as 'using' means 'reading from'.

read up on Oracle VarChar2 - it is a nasty side-effect that it will automatically trim upon input and then end up with a null! We encountered that very same problem on this installation with 10g and using Px. Is that something specific to 10g, Arnd? Because I've never seen that particular behaviour...

Excellent! One other piece of information to keep in mind that hasn't been mentioned yet is this - in these more recent releases of VC, not only can the VERSION project be named something different, it now easily supports multiple Version Control projects. So if you find yourself in a situation wher...

Besides, why would you want to go around 'hacking' DataStage internals when all it takes is a moment or two to create a new Category and then move jobs into it via the Manager?

Use the GUI, Luke!

Ah. I missed the 'only have a Production environment' part for some reason. So Ray is right that you'd need to use the Production project to seed the development project. The default project name for Version Control is VERSION , however it can be pretty much anything you like nowadays. I'd suggest a...