DSXchange

In the Locks part of the GUI (the lower window) you will find reference to the particular job name as the Item-ID of the lock. This is the one that you need to release. You should probably log out its owning process - which is the defunct process that lost its connection. It may be that the lock is ...

Sure. They just choose to call it a Transformer stage type. But there's no reason not to caption it Column_Generator_42.

You DO NOT use wrappers. The DataStage job itself is exposed as the Web service. Design is something like: RTI Input ---> XML Input ---> anything ---> XML Output ---> RTI Output The RTI Input stage listens for a web client. The XML Input stage "translates" the incoming XML document into data that th...

Why? Doesn't Search work for you?

There are plenty of hits when you search for "STATUS statement", including this post.

I imagine U (a poster on this forum) can restart a job the same way anyone else can. The real issue in your question is how to undo anything that's already been committed. This must be designed in. If every record added to the target carries a "run ID" or timestamp, then it's easy to delete these it...

StringToDecimal() then divide by 100?

Could be that balaramreddyv is expressing understanding in Japanese - but somehow I doubt it.

If you don't like the previously offered solution, please say so. It can also be done with a routine, using the STATUS statement to determine the date/time modified (for example).

If you're looking for someone to do the work for you, please contact them privately for a quotation.

THen your Java would be the caller, rather than the wrapper. You can do the same thing with shell scripts.

It can be installed anywhere except the root directory, and will behave exactly the same. /home/dsadm is the default only because it must exist if dsadm is doing the install.

Another exception: it must be installed in a "real" directory, not on a symbolic link.

Are you talking about using Oracle 10g as the Repository database for IBM Information Server, or just as a data source?

... and making sure the 32-bit libraries appear in LIBPATH for DataStage processes instead of or, at the very least, ahead of the 64-bit libraries.

Will other applications also be generating surrogate keys for these tables? This is major factor in your choice of technique.

Don't use non-materialized views! I once advised one site who were reporting horribly slow throughput for "a mere 27000 rows" - taking over an hour. Turned out the query was a join between three views, the smallest of which was based on a ten million row SELECT statement. Query the base tables direc...