DSXchange

Or the other 'Toad Trick' is to wrap your query in one that just does a 'select count(*) from (your query)'. Either way you have the (hopefully negligible) added time it takes to sort or count, but in either case you'll get a better picture of how long it takes to build the entire result set, not ju...

The point is there's no need to write routines to do this validation. Check the year portion of the date and if it is below an acceptable range, reject it. Stage variables would work nicely for this and if named appropriately make it all 'self documenting'. Worst case, send it to SQL Server and catc...

NULL is never equal to NULL, not even in DataStage. In all cases you'd have to convert it to a 'known' value and use that in the comparison. Oracle provides the NVL function for that and in DataStage there are the 'NullTo' transforms like NullToEmpty which comes in very handy for stuff like this. Yo...

Sadly, I couldn't find any reference to a 'Wondows Xp Patch'.

Does it log these phantoms only in Production? If so, are you using any routines that may be out of sync?

No... how about a clue as to the nature of the failure? All we know is it uses 'over 22 hashed files' which is nothing all that unusual. And are you saying it only runs once in production per compile, in other words you need to recompile it after every time it runs before it will run again?

Not one I've seen before. Do you get this for all jobs, all projects, some jobs, some projects, what? Anything 'special' about the job(s) or project(s) when you see it ? Regardless, I'd suggest opening a Support case for something like that. ps. It's 'could' not 'cud' unless there's a cow involved s...

Didn't - db2 with the UDB API stage. I asked.

Or let them run it for you under your guidance. I've done that before and it's fairly painless. Unless you are deep in their Good Graces, they're not going to give you the root password. However, they may grant you 'sudo' privs on the installation script which I've also done and works fine. They wil...

I would think that would be pretty obvious, based on what select privileges are being requested. Especially to a DBA. Just really curious what havoc they think you can wreak with all this new found SELECT power when granted?

You may want to consider using a Execute Command stage instead as that's what it is for after all. Unless there's more going on than just the script call, of course. In any case, the answer is 'go ahead'. There's an actual trigger Expression Type built in for ReturnValue - Conditional, use that to c...

The only 'help' compiling would bring would be to remove the 'multi-instance' entries from the Director's Status view. As you noted, however, the log entries would remain. The only times I'm aware of that Auto Purge doesn't work as expected are 1) when someone has done a CLEAR.FILE on the log or 2) ...

The reference to 'Life, the Universe and Everything' was supposed to clue you into a Hitchhiker's Guide to the Galaxy reference - and 42 was a pivotal number from the series and was, in fact as Ray notes, the answer to that very question.

Depends what "and assign to a variable in the datastage" means. Simplest way is probably in a job, but it all hinges on what you mean - how you plan on using this information you're selecting.

Of course not, nobody does - so check the database. That's what hashed files are for and the concepts of preloading and using them to determine insert versus update are the heart and soul of the Server product. Learn it. Love it. The people who come after you will thank you. However, that's a whole ...