DSXchange

TYPE is the DOS equivalent of the UNIX cat command. That's why Craig mentioned both.

You could use REVERSE string, you could match the rightmost characters, you could generate Reverse Soundex.

Are you using QualityStage? Are you able to use QualityStage?

Do you migrate the Parameter Set files?

soumya5891 wrote:If the column length is greater then 6 ,say 8 then it will not work.

Please provide proof of that assertion. I don't believe it is correct.

If the data type is string, you can use

It's a report of the output of uname; it is not the uname command itself.

No. This information is not documented in the public domain. They are modules of the Orchestrate engine. For example, if you needed to connect to Oracle, you would probably see a module called orchorcl loaded.

That part of my answer that you can see gives you your answer.

The easiest way to see the entirety of premium posters' posts is to obtain a premium membership. This is the mechanism used to fund the continued existence of DSXchange (hosting and bandwidth costs).

QualityStage in version 8 is integrated with DataStage - they use the same engine and use the same Designer and Director clients. However they remain separately licensed products, so you will still need to buy licenses for each. If you need to keep them separate, use different projects. There is a c...

It's not a command. It's merely a report that the main program (your job) is running (was started on) the conductor node and provides a few statistics associated with that machine.

They're modules that do stuff that that particular job needs. Or may need.

How much scratch space do you have? Can you allocate more?

How large are these 1.9 million records?

I think that one's taken.

Read my reply again.