DSXchange

Did you think the Editor would be able to tell you? Why, then, did you post in the Editor's Corner forum?

Hello DaeWhan, Try the start command (or even the AT command). start "C:\Program Files\Cognos\cer2\bin\trnsfrmr.exe" -n -s "D:\OLAP\Model\hlc-m-01.pyi" You have indicated that this is a parallel job. Is this correct? I presume that you are running ExecDOS as an after-job subrouti...

Search the forum for any of "DSGetLogEntry", "DBMSCODE" and "LASTERR". You will find at least two ways to accomplish your requirement.

There is nothing out of the box. You can, of course, create your own.
You could use a QualityStage plugin to run a standardization job to "bucket" the name into components (given name, primary name and generation in this case) and separately case the components, ignoring the generation ("III").

It's an OLE Automation glitch. All complaints to billg@microsoft.com.
But report it to your support provider nonetheless.

It probably won't happen if you only have one Designer client open at a time.

There is no such mechanism. Your developers will need to adopt a more disciplined approach (which includes cleaning up any such files created in the project directory). A standard set of parameters helps; parameters for source directory, rejects directory, work directory and so on.

Pre-populate a hashed file with only the key of each row in the target table. Suddenly it's an easy lookup, one that can probably be cached in memory.

1. Make sure your shared library path environment variable includes the directory that contains the (32-bit) DB2 libraries. This may require a change to the dsenv file. 2. Recompile the job. That the Transformer stage code can not be found suggests that the previous compilation was not totally succe...

Job parameters buy you insurance. Insurance against things that may change over time, such as passwords, selection criteria, and so on. Insurance against things that may be different between different environments (development, test, production) such as data source names and authentication informati...

What are the argument values? Status() returning 1 means that the first argument can not be converted based on the second argument. For example "2006-01-27" can not be converted if the second argument is "D" if your locale's standard representation of a data is MM/DD/YYYY. You would need "DYMD" as t...

Point 1 - the problem is not with creation of the hashed file (note, it's "hashed", not "hash"). Your claiming that is it is can be misleading. Point 2 - how large are the rows? Does this size of load get anywhere near 2GB of data? On the server find out the size of the DATA.30 and OVER.30 files ass...

khanparwaz wrote:Can Anyone Give A complete Solution.

That kind of request presupposes some kind of commercial transaction. Complete solutions take some time to prepare, and self-employed consultants particularly don't have all that much "give" time available.

Sorry I am really busy at the moment and don't have the time - particularly unpaid time - to do detailed POCs. Maybe someone else does.
My previous post on this thread should be sufficient guidance for an experienced DataStage developer.

Think of them as column splitter and column merger stages and you will be closer to what they actually do.

Yes, you can do what the row splitter stage does in a Transformer. But it's harder to do what the row merger stage does without introducting an intermediate passive stage.

1) SetNull()
2) Iconv() and Oconv() are only for server jobs, not parallel jobs.