DSXchange

If the DS_JOBS index on CATEGORY is out of date, the process of building the category list for the clients will not work properly. I selected DS_JOBS because the error message (cannot open DSR_JOBS) suggests this as the most likely culprit. It remains the case that DSR_JOBS is a subroutine, not a ha...

That's reasonable; when you're using View Data the job doesn't have a start date. You need to supply a replacement value (which is possible if you are using a job parameter, but not if relying in the job on a macro).

4) Use cat file1 file2 file3 file4 file5 as the filter expression in a Sequential File stage.
The output from cat becomes what the stage reads, without needing to create another disk file.

I have grave doubts that the expression as given would work properly. Placement of the DataTypeAsciiPic9() function suggests that it expects a binary value with which to work, yet the result of the expression supplies as its argument will be a string of numeric characters. If all you want is the yea...

To what operating system groups are the DataStage roles assigned?

If you have system backups you can recover. Restore RT_LOGnnn (a hashed file) so any location, and create a VOC pointer to it, with D_RT_LOG as the file dictionary pointer. You now have whatever entries were backed up accessible. You can extract the entries using DataStage/SQL or even a DataStage jo...

Is there anything unusual about this hashed file - static hashed, 2GB in size, etc.?

Yes, just as any Teradata client must. However, there are default values in DataStage; it is sufficient to rely on these unless you want to make use of more amps than the number of processing nodes in your DataStage configuration file.

Does this work in a parallel job?

No.

The only way to transfer a BLOB is to encode it as a text string (for example uuencode) for transfer. Even then there is an upper limit on the size of string with which DataStage can deal.

Just to prolong the hijack, I only had one official at bat.

<Aside>
I had a strange game of baseball last weekend. I got one hit and 6 RBIs.
</Aside>

In Designer. Where you are asserting the RCP is not enabled, the default setting is "use project defaults". You must uncheck this check box explicitly to be able to disable RCP if the project default is "enabled".

The ones that I use if a client lacks their own may be seen from this page

Technically they should process the project in the same order so, provided that they are started far enough apart and there are no very large objects in the project, they should both succeed. If they do not, the later-started export will skip any objects locked by the first-started export, and may t...