DSXchange

Off you go then. You'll need some stage variables, sorted data partitioned on TRACKID, and possible use of looping within the Transformer stage (depending on how you plan to implement the 50 characters limit).

Why not trade in your copy of DataStage for a UNIX shell script author?

The code is in my response earlier.

There is no default password.
You may be able to use the AppServerAdmin.bat script to set a new administrator password. This script must be run as a local Administrator on the services tier.

Try

I can't see anything in that code snippet that writes to the log.
However there are a line with GoSub and GoTo statements; one would need to investigate what happens there before a definitive answer could be given.

I think that the substringing approach suggested by Arnd is probably more efficient, but wonder how close the following construction would be.

Also visit the Project Properties in DataStage Administrator. You may find (on the Schedule tab) that a different user has been set up to run scheduled jobs.

Does the log show the credentials that were actually passed when connection was attempted?

That mkdbfile reports that it cannot create an object in the file system means that the credentialled user does not have permission to create that object. You need to determine who the credentialled user is (see Engine Credentials in web console for Information Server) and then verify the permission...

How are you scheduling the job?
When it runs from the scheduler, check the job log to verify that the credentials have been passed correctly (I am assuming that they are job parameters).

What's different between the two environments? Hint: "nothing" is clearly not the correct answer. We don't do asap. DSXchange is an all-volunteer site whose members post when and if they can, and are under no compulsion so to do. If you need urgent assistance, sign up for premium service w...

This can also be a symptom of running out of memory on the client machine. Do you have a zillion other applications open? Or an animated screen saver? Are you perhaps viewing streamed video? All these demand memory and CPU resources.

Any 8.7 client should be able to connect to 8.7FP2 services/engine. Beyond that, who knows?

Try width = 40. That is, 38 + sign + decimal placeholder.

The 9 decimal digits are included in the total of 38 significant digits.