DSXchange

touch.exe ships with DataStage. It can be found in the Engine folder's bin subdirectory.

Oh no you can't! UV_SCHEMA is specifically protected and can only be modified using DDL statements or the repair utility VERIFY.SQL. To clean up UV_SCHEMA you need the VERIFY.SQL command, specifying the pathname - not the name - of the project. Do it without the FIX option first. VERIFY.SQL SCHEMA /...

One should never, ever, ever run VERIFY.SQL in FIX mode without first running it without FIX to see what you are about to "fix". The syntax to repair the Catalog from the project is not what you used. This may be very difficult to recover. The additional entries in the project directory are probably...

There's a lot of that. That's why it's useful (vital) to have the Orchestrate manuals available also.

You probably don't need a routine. An Execute Command activity would do to read the first character from the file. The command is something like cat filename | cut -c1 A Trigger on the Execute Command activity is based on the return value being "N", a second trigger is based on the return value bein...

Not in a timestamp. The definition of a timestamp must coincide with the format of a timestamp. The time zone is, of course, obtainable from the TZ environment variable so, if you convert your timestamp to a string, you can add in the time zone designator wherever you like. GMT is somewhat trickier,...

There's a Skip option in View Data but not, I believe, in the Sequential File stage.

Do you want to skip four records per partition, or four records in total? Is your source a text file or a database table or some other source?

No, not VERIFY.SQL (this fixes UV_SCHEMA). Yes, you can use a regular INSERT, or even a copy. Maybe ED is even better; open an existing project's record, replace the pathname and file as the name you accidentally deleted. For example, if you deleted Project2 (pathname is /usr/Ascential/DataStage/Pro...

Didn't I leave you a set of date handling functions when I was at your site? AddMonths would be one of them. The offset can be positive or negative.

As far as I have read from Rays post that in server, the only way to use parallelism is using the Link Partitioner stage. You have misconstrued whatever it was you read. There are at least five different ways to effect partition parallelism in server jobs, including multiple independent streams in ...

Your UNIX administrator may need to configure your user id into the cron.allow (and/or at.allow) file.

Any time you see "(filtered)" indicates there's a filter in effect. For example in Director log view the default is to limit you to the 100 most recent entries. In all locations you can use Ctrl-T, or the right-mouse menu, to open the Filter dialog. This has nothing whatsoever to do with indexes. Th...

Please clarify if this is correct. In a job sequence: 1. You execute a job that creates one line in a file (is this the PS_BBPGMSTATUS.ref file?) 2. You now want to execute a routine that determines the value of the first character in that file and use the result of the routine to determine whether ...

Note also that the Properties tree's properties change as you change some of the properties (such as Write Mode).