DSXchange

Welcome aboard. :D

The phrase "env: null" in the error message immediately caught my eye. Is the Oracle environment to which you are trying to connect correctly defined in tnsnames.ora?

A quick way might be simply to open an Expresion Editor to see whether BASIC functions, such as Iconv() and Oconv() are there.

If you want to track it down in DS_JOBOBJECTS, you will see that the different stage type objects are instantiated from different classes.

System administrator. Who should have knowledge about configuring rsh.

Revert back by changing back what was changed and caused things to stop working.

If your site does not know what was changed, how can you expect us, on different continents, to know?

This is beyond the capacity of CFF stage.

You need to create a job, routine or script to pre-process this file into three files/streams containing the data you require.

If you write a routine, you can load the data directly into hashed files.

Prevention is better than cure.

Is there any other way, leaving this ODBC and Converting into CSV. There's always another way. You could, for example, read the XLS file directly and spend a fortune on Microsoft-savvy consultants who can interpret what each byte in the file means. Doesn't mean that the other ways are sensible! Wha...

The style sheets (for example DSExport-DSX.xsl and DSExport-HTML.xsl) are to be found on your client machine in the DataStage installation folder (for example C:\Program Files\Ascential\DataStage7.5).

The user ID must be recorded in both cron.allow and at.allow to be permitted to schedule. Negotiate with your SA.

The first place you're "doing wrong" is trying to hack DS_JOBOBJECTS. Disclaimer The following advice is provided without any liability, express or implied, being incurred by the provider of the advice. Any damage to your Repository, any voiding of your warranty as a result of actions taken by you a...

poonamgoyal wrote:can't write routines...client said no for it

What would you do if you were a mechanic and your client wanted you to repair an engine but forbade you to use a spanner? Sometimes you just have to challenge apparently arbitrary restrictions, particularly if there are no other solutions available.

Check with your administrator whether permission to use rsh has been changed.

It's probably easier to generate all dates (Column Generator stage) then remove those whose day of week is Saturday or Sunday (Filter stage).

Not sure how RCP would help here; the problem here is that the column itself is missing from the data (if I read the question correctly). RCP is for when you don't want to physically include the column definition in the metadata for a link.

The BASIC Transformer in parallel jobs is not the same as the server Transformer stage. For one thing, it won't do reference lookups.

See extended post in parallel forum for appropriate techniques to use in parallel jobs.

It's not a bad idea to check that DSSetParam() has worked correctly.