DSXchange

This is a parallel job, so linking to Locate() will be ugly. I'd use a key-only Lookup stage, with the reference input fed by an External Source stage (echo 40,50,100). If the lookup fails then your NOT IN condition is satisfied. You can direct these rows to a reject link and have just those rows se...

They were suggested "for example". You need to find how your Chinese characters are encoded and use that map.

suneelchallagali wrote:...and ran the job still i am unable to complie the job.

That does not make sense. You can not run a job without compiling it.

So what really happened?

It seems to me that you know the number of columns because you have specified the metadata that describe the record. In server jobs the metadata are not dynamic. (I suspect you are wanting to check that the number of delimited fields is correct, and by far the easiest way to do this was specifically...

There is an NLS database in the original repository (though centrally located in the DataStage engine). I have not bothered to research where the default settings for the project are stored. NLS settings in job designs are, of course, properties of the job object or stage/link objects to which they ...

There is an automatic entry very early in the job log that shows all the environment variables of the job's execution environment.

Welcome aboard.

Unfortunately you are on the leading edge with this technology; few of us have had the opportunity to work with it yet.

Hopefully someone who has will be able to respond.

There's nothing out of the box for county.

You could construct a lookup table perhaps based on postal code.

We don't do "ASAP" or "urgent". DSXchange is an all-volunteer site whose members post as and when they can. If you need urgent help sign up with your official support provider for priority service, and learn just how much "urgent" is valued. Also, please strive for a p...

That's the Oracle name of a map. DataStage uses different map names. So do most other environments.

U (one of our posters, and known to me personally) remains a fairly inexperienced developer; I doubt that U will be able to offer you much assistance. The second person personal pronoun in English is spelled "you", not "u". The short answer is that you must find the table(s) in X...

I believe this has been reported before on DSXchange. Did you Search?

(Or did I read about it on IBM's web site? Hmm...)

Licensing information is (I'm guessing) stored deviously somewhere in XMETA with (probably) some other check files to stop you from simply hacking XMETA.

Prove that all 16 CPUs are being used by monitoring the system while running a job that generates more than 16 processes.

Yes, but you're no longer getting it from APT_CombinedOperatorController - you now know which operator (stage) is throwing the error.

Now you need to inspect parameters and properties to determine why the job can not connect to the data source.