DSXchange

Was that shock at having four, or four factorial ?

Your other question is effectively identical, and the answer is there.

chulett wrote:Kaboom.

Someone is channeling Marvin the Martian!

You can generate today's date as Oconv(Date(),"D-YMD[4,2,2]") or whatever other format you require.

Prevention is far better than cure, because there is no cure.

Don't do it.

I agree with Arnd's assessment.

Stage variables? Other expressions in the Transformer?

There is no guaranteed solution. Your repository may be repairable, but it will require expert support, as noted in my earlier post.

But you'll note that that is now a completely different error. Now your metadata have to be corrected to match the data. It's running into problems at the CTRCT_STATE field, but the actual problem may be in the immediately prior field.

Not possible. Fatal errors are fatal. They are untouchable.

Incidentally, if you could do it, it would be a demotion, not a promotion.

Welcome aboard.

Are all the Oracle client pieces set up, such as ORACLE_HOME environment variable, entries in tnsnames.ora file, Oracle client software installed, etc.?

Is the Oracle OCI plug-in stage installed and registered in this project?

Don't allow null to reach any Transformer stage function or stage variable; they are all intolerant of null.

(This is optionally relaxed in the next version of DataStage early next year.)

Welcome aboard. Bad things only happen when you don't have a backup. Unfortunately your project is corrupted. Specifically the ROOT record for these jobs in the DS_JOBOBJECTS table is either missing or damaged. This record is the entrypoint for finding the design time information. Without a backup o...

I think you specify newline as \n. Verify using on-line help or the manual.

Check the value of APT_STRING_PADCHAR environment variable in each project. I expect that one will be 0x00 and the other 0x20 (space).