DSXchange

We will need a lot more information than that if we're to help! What is the job intended to do? Describe the job design in terms of the stage types it uses. When does this error appear (compile time or run time)? If there are other warnings in the log, what do these indicate? Do you get more diagnos...

Error on CREATE.FILE command suggests a space or permissions problem. Does the executing user have write permission to the VOC file or to the project directory? Execute (use) permission is also needed to the directory.

The obvious method is to use the Designer client, and modify your jobs properly. You will retort that you don't want to do that, you prefer automatic to manual. In this case your only possibility is carefully to hack an export file. In either case, as suggested, if you want to use an explicit accoun...

I also advocate the UV stage. The other method you specified, of reading the record first, updating it, and overwriting does work using Hashed File stages if you have some particular reason for wanting to do so. In this case, make sure that the link used for reading the record has "lock for update" ...

SDKSequences is a regular hashed file.

Its key value is the sequence name, its only other column is the next value for that sequence.

Use a DataStage job as suggested by Sumit. There's no point writing code where you don't have to.

That's a very interesting date format. Did you mean dddyyyy or did you mean ddmmyy? I shall assume the former. If the number of days is variable (1-366), Substrings() as suggested won't do it for you, you'll need something slightly more complex such as Left(TheDate, Len(TheDate)-4) w...

That should be controlled by the umask setting of the user ID you used to connect via the Administrator client.
To find out what this is, get into the Administrator client's Command window and execute (umask alone reports the current setting).

You are trying to load the entire folder contents into a single text file. Is this text file in the folder in question? (Eek!!) Try FolderStage > TransformerStage > OraOciStage as a preferred design. This is what I mean earlier when I suggested that you "lose the Sequential File stage".

The kind of lock managed by the deadlock daemon are not set by parallel jobs. They are set by connected clients, server jobs and job sequences only.
To use, change the Start option in dsdlockd.config (in your DataStage Engine directory) to 1, and re-start DataStage.

That would be the HowLongIsAPieceOfString() function. The only thing that can be predicted reliably is the number of entries that will appear in the log file if no warnings are generated. These are: job starting, environment variable settings and job finishing (one each per job) active stage startin...

In either case the hashed files will be preserved. If you upgrade, you will need to do nothing. If you uninstall, any hashed files in the project (I happen to know that most of your hashed files ARE in the project) will be lost, and so will need to be restored from backup and VOC entries created aft...

Red Brick Warehouse (now owned by IBM) has RANK as one of the functions built in to its SQL. Also tiling (e.g. TERTILE, percentage, N-tile), moving sums and moving averages, running totals and cumulations, and lots more. It's a database designed specifically for implementing the dimensional model, w...

The Administrator client's agent (dsapi_server/dsapi_slave) process "edits" the DSParams file by editing its in-memory copy, deleting the old and writing the new. This is why the permissions change. Doubtless Ascential have their reasons for doing it this way (easier to code?). If you need a change,...

Won't work on Windows!

The three IPC stage types in server jobs (IPC, Link Partitioner and Link Collector) are new in 7.x. There may still be bugs. Have you logged a support call and, if so, with what result?