DSXchange

Transformer.

Probably going to regret this, but you *could* build your job like this: XFM --> SP --> OCI --> OCI A single dummy record triggers the SP, passes through and does some sort of harmless no-op style operation in Oracle. Then the main process kicks in and the update leverages your newly polished, shiny...

Honestly, for MCM issues and run-time error problems like that, I'd suggest you contact your official Support provider.

LIST DICT xxxxxx

What does an inner join have to do with how many rows come out? Never heard of a cartesian product? Depends on the nature of the join keys and the data being joined.

You don't need a routine for that - simply use IConv to convert to internal format, subtract 30 and then OConv back to whatever external format you'd like.

$ENV tells DataStage to use the current value defined in the environment.
$UNSET tells it to unset/remove that variable from the environment if it is defined there.

It's still running until it stops running. After job, you need to check the INTERIM status to get what you are looking for.

Not possible. You either need to generate another hashed file with a single key or slap a UV stage over the top of it. Not for the faint hearted, however.

What is your small doubt? Have you tried using... StringToDate()?

Resetting != compiling. You'll be fine simply resetting the job, unless there's something dodgy about your 'user defined routine' that does the reset.

Which implies you need to know the job number for the job in question:


Assuming that 'datastage error log' = job log, that is.

I see this when there are enough broken connections to exhaust certain control structures. Get a list of all connected clients (ps -ef |grep dsapi) and use DS.TOOLS to logout any obvious defunct ones.

What? Who's indexes are you expecting to update stats on smack in the middle of your process?

What is the data type of the COGIPF_LOCALTIMESTAMP column in Oracle (not your job)? What is the exact error you are getting? Saying it "complains" doesn't really help us.