DSXchange

Integer is fine. There are known problems with VarChar when performing range lookups, at least in version 8.0.

Column properties are properties of the link, so setting Nullable on the inputs of the Join stage (which I suggested earlier) is equivalent to setting it on the outputs of the upstream stages.

Or simply insert the decimal placeholder before doing the conversion.

Just set the DB2-related environment variables separately for each "application".

It's different in different organizations. At its simplest it's DataStage design and development, obviously. In a sufficiently large organization where complete target-from-source mapping documents are available, then that may be all there is. Though obviously there will be some degree of unit testi...

May I suggest that creation of rule sets is not something that can be learned from the manual? You really do need to have hands-on access to the software. And, if you have the software, you have the manuals.

I know of no way (apart from using the client) to export the contents of a category. However you may like to search DSXchange.

You don't. The dsexport command exports the entire project.

Practice questions and other information on the IBM website (look for exam number 415). Actual exams are administered by Prometric and the only ways to obtain those materials are illegal. Exam preparation classes are offered by IBM, but usually only in conjunction with conferences such as IOD 2008. ...

Dump the score for the job and inspect that. Or inspect the generated OSH produced by compiling the job. Or even inspect the Join stage itself.

Welcome aboard.

The scurrilous answer is ".2". Mainly 7.5.2 contains bug fixes so should have fewer bugs than 7.5 "vanilla". Somewhere on your system there will be a file containing "what's new in this release".

Moderator: please move to parallel forum

I very nearly answered this question with a solution that is only appropriate to server jobs.

Magesh_bala wrote:In Execute command we cant execute the shell script commands, We can call only the shell scripts files.

Not true.

If you can prove that your assertion is true I would be interested in seeing the proof.

I execute individual commands through Execute Command activity quite frequently.

When you state "Admin User" do you mean the operating system admin user (superuser) or the Information Server admin user? If it is the Information Server admin user, might that user's password have expired?
Can you get access to, say, the Reporting tab?

Perhaps you could outsource the work to hamzaqk's organization?

(I was going to use the term "offshore" until I realized that there is no sea between India and Pakistan!)