DSXchange

Show us the script. The DB2 commands only work within the context of the db2 environment, so you probably need to have set up a here script within your script to invoke that environment and provide a "feed" mechanism for commands to it.

Try ISO8859-1. If you set this for LC_ALL you don't need to worry about the specific locale categories below it.

The Null Field Value in a fixed width file must have the same length as any non-null data in that field. After all, that's what fixed width means - every value in the column - including the representation of null - has the same width.

ETL. Extraction, Transformation, Load. Any source, any target.

Find whoever told you "connecting to two databases from one job is not a good practice", demand to know why, and post the reply here so we can all have a good laugh.

Search is your friend.

Posting the entire error message would have been helpful also.

How big is the hashed file?

Transforms are not available in parallel jobs.

Historical Note
The "redundant" Transforms stem from the earliest versions of DataStage, when it was not possible (as in not legal) to call Routines directly from jobs; you had to call them using Transforms as interludes.

Parallel job is required as I am converting all server jobs into parallel jobs to improve the performance of the whole process. It won't. For small tasks server jobs, at versions earlier than 8.0, will always be more efficient (finish faster) than the equivalent parallel job. This is mainly because...

Try these for starters. Your command search path environment variable (PATH) does not include the parent directory for your C++ compiler or your APT_COMPILER environment variable is pointing to the wrong location or you don't have a C++ compiler at all. You can not generate a BuildOp without a C++ c...

When you consulted the online help for this option, what did it tell you?

We don't do "urgent" - we are all volunteers who post as and when we can. If you want "urgent" sign up with your support provider for premium services, and learn the true cost of urgent. The column sent to the reject link by the Sequential File stage is in Raw format. You can feed it to a Peek stag...

"Outrageous" is a good adjective for this requirement.

Are you expected to bring back all rows that correspond to a partial match on all keys? (This was not stated.)

Can you - or get "them" to - explain in English what is required, and why ?

The obvious answer is fewer derivations. Keep in mind it's not just compilation. First, the structure of the job must be sanity-checked, then the expressions in the Transformer stage all have to be converted into C++ equivalents from which source code is generated. Then that C++ source code must be ...

Then you need the DataStage PACK for SAP R/3. This gives you plug-in stages that allow you to generate (certified) ABAP code to work within the SAP environment, or to work with IDOCs if that's the way you prefer to operate. Talk to your vendor. Search the IBM web site for more information about SAP ...

kumar_s wrote:Ray you shall add you valuable inputs to this thread, which will be useful for those who have not access to DataStage Essentials class.

Everyone has access to IBM training, in exchange for money.

(The original post still smells like an interview question to me.)

OK, that error message tells you that dos2unix does exist on your server machine, since it was the dos2unix command itself that generated the error message. It's also telling you that there's something about file.csv that it did not like - could not convert. You will need to scrutinize file.csv with...